Details
- 
    Bug 
- 
    Status: Open (View Workflow)
- 
    Major 
- 
    Resolution: Unresolved
- 
    10.0.12
- 
    None
- 
    None
- 
        10.2.1-1, 10.2.1-2
Description
| mysql 5.6.17 (root) [test] db1> CREATE TABLE `t1` ( | 
|     ->   `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | 
|     ->   `d` datetime DEFAULT NULL, | 
|     ->   PRIMARY KEY (`id`) | 
|     -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | 
| Query OK, 0 rows affected (0.11 sec) | 
|  | 
| mysql 5.6.17 (root) [test] db1> flush table t1 for export; | 
| Query OK, 0 rows affected (0.01 sec) | 
| mysql 5.5.5-10.0.12-MariaDB (root) [test] db1> CREATE TABLE `t1` ( | 
|     ->   `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | 
|     ->   `d` datetime DEFAULT NULL, | 
|     ->   PRIMARY KEY (`id`) | 
|     -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | 
|     -> ; | 
| Query OK, 0 rows affected (0.08 sec) | 
|  | 
| mysql 5.5.5-10.0.12-MariaDB (root) [test] db1> alter table t1 discard tablespace; | 
| Query OK, 0 rows affected (0.01 sec) | 
|  | 
| mysql 5.5.5-10.0.12-MariaDB (root) [test] db1> | 
| [2]+  Stopped                 mysql | 
| [kolbe@centos6-build mariadb-10.0.12-linux-x86_64]$ cp ~/t1.{cfg,ibd} ./data/test/ | 
| [kolbe@centos6-build mariadb-10.0.12-linux-x86_64]$ fg | 
| mysql | 
| mysql 5.5.5-10.0.12-MariaDB (root) [test] db1> | 
| mysql 5.5.5-10.0.12-MariaDB (root) [test] db1> alter table t1 import tablespace; | 
| ERROR 1808 (HY000): Schema mismatch (Column d precise type mismatch.) | 
Attachments
Issue Links
- is duplicated by
- 
                    MDEV-11351 Not able to rebuild tables with old timestamp format -         
- Confirmed
 
-         
- is part of
- 
                    MDEV-5377 Row-based replication of MariaDB temporal data types with FSP>0 into a different column type -         
- Closed
 
-         
- relates to
- 
                    MDEV-9967 Convert old temporal types on ALTER TABLE ... FORCE -         
- Closed
 
-         
- 
                    MDEV-15225 Can't import .ibd file with temporal type format differing from mysql56_temporal_format -         
- Closed
 
-