Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Negative Numbers are wrong with Binary Log Format = ROW #107

Unanswered
qrizly2 asked this question in Q&A
Discussion options

So i had to use this snippet to fix some values.
Does anybody have a better implementation of this?

 public function fixSignedNumbers(RowsDTO $event, array $values): array
 {
 /** @var \MySQLReplication\Event\RowEvent\ColumnDTO $column */
 foreach ($event->getTableMap()->getColumnDTOCollection() as $column) {
 if(
 isset($values[ $column->getName() ]) &&
 is_int($values[ $column->getName() ]) &&
 ! $column->isUnsigned()
 ) {
 list($type) = explode("(", $column->getFieldDTO()->getColumnType());
 switch ($type) {
 case 'int':
 if($values[ $column->getName() ] > 2147483647) {
 $values[ $column->getName() ] = $values[ $column->getName() ] - 2147483647 - 2147483647 - 2;
 }
 break;
 case 'mediumint':
 if($values[ $column->getName() ] > 8388607) {
 $values[ $column->getName() ] = $values[ $column->getName() ] - 8388607 - 8388607 - 2;
 }
 break;
 case 'smallint':
 if($values[ $column->getName() ] > 32767) {
 $values[ $column->getName() ] = $values[ $column->getName() ] - 32767 - 32767 - 2;
 }
 break;
 case 'tinyint':
 if($values[ $column->getName() ] > 127) {
 $values[ $column->getName() ] = $values[ $column->getName() ] - 127 - 127 - 2;
 }
 break;
 }
 }
 }
 return $values;
 }
You must be logged in to vote

Replies: 1 comment

Comment options

can you provider create table with insert on what data you need to fix signed ? 🤔

nvm I see #108

You must be logged in to vote
0 replies
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet

AltStyle によって変換されたページ (->オリジナル) /