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