YEAR type is recovered incorrectly
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Data Recovery Tool for InnoDB |
Fix Committed
|
High
|
Aleksandr Kuzminsky |
Bug Description
Year 2006 is recovered as 0000. See below
mysql> select * from sakila_
*******
original_
rental_
replacement
special_
1 row in set (0.00 sec)
mysql> select * from sakila.film limit 1\G
*******
original_
rental_
replacement
special_
1 row in set (0.00 sec)
mysql>
Changed in percona-data-recovery-tool-for-innodb: | |
importance: | Undecided → High |
milestone: | none → release-0.6 |
assignee: | nobody → Aleksandr Kuzminsky (akuzminsky) |
Changed in percona-data-recovery-tool-for-innodb: | |
status: | New → In Progress |
status: | In Progress → Fix Committed |
Year is stored as X - 1900 number.
For 2006 106 is stored internally.