YEAR type is recovered incorrectly

Bug #850345 reported by Aleksandr Kuzminsky
6
This bug affects 1 person
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_recovered.film limit 1\G
*************************** 1. row ***************************
             film_id: 1
               title: ACADEMY DINOSAUR
         description: A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies
        release_year: 0000
         language_id: 1
original_language_id: NULL
     rental_duration: 6
         rental_rate: 0.99
              length: 86
    replacement_cost: 20.99
              rating: PG
    special_features: Deleted Scenes,Behind the Scenes
         last_update: 2006-02-15 05:03:42
1 row in set (0.00 sec)

mysql> select * from sakila.film limit 1\G
*************************** 1. row ***************************
             film_id: 1
               title: ACADEMY DINOSAUR
         description: A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies
        release_year: 2006
         language_id: 1
original_language_id: NULL
     rental_duration: 6
         rental_rate: 0.99
              length: 86
    replacement_cost: 20.99
              rating: PG
    special_features: Deleted Scenes,Behind the Scenes
         last_update: 2006-02-15 05:03:42
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)
Revision history for this message
Aleksandr Kuzminsky (akuzminsky) wrote :

Year is stored as X - 1900 number.
For 2006 106 is stored internally.

Changed in percona-data-recovery-tool-for-innodb:
status: New → In Progress
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.