Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.0.21
Description
as reported by @Ara4Sh on #mariab
|
|
16:50 < Ara4Sh> Hello i dump my backup in a mariadb server (mysql Ver 15.1 Distrib 10.0.14-MariaDB) and import in another mariadb server (mysql Ver 15.1 Distrib 10.0.21-MariaDB) and here is
|
the problem
|
16:51 < Ara4Sh> ERROR 1064 (42000) at line 4185: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near
|
'AUTO_INCREMENT=61308' at line 10
|
MariaDB [test]> CREATE TABLE IF NOT EXISTS `arash` (
|
-> `call_id` int(11) NOT NULL AUTO_INCREMENT,
|
-> `number` varchar(15) CHARACTER SET utf8 COLLATE utf8_persian_ci DEFAULT NULL,
|
-> `date` datetime DEFAULT '0000-00-00 00:00:00',
|
-> `sms_call` int(1) DEFAULT NULL,
|
-> `compid` int(11) NOT NULL DEFAULT '0',
|
-> PRIMARY KEY (`call_id`,`compid`)
|
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8
|
-> /*!50100 PARTITION BY HASH (compid)
|
-> PARTITIONS 400 */ AUTO_INCREMENT=61308 ;
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUTO_INCREMENT=61308' at line 10
|
swapping parition and auto_increment table options is successful:
MariaDB [test]> CREATE TABLE IF NOT EXISTS `arash` ( `call_id` int(11) NOT NULL AUTO_INCREMENT, `number` varchar(15) CHARACTER SET utf8 COLLATE utf8_persian_ci DEFAULT NULL, `date` datetime DEFAULT '0000-00-00 00:00:00', `sms_call` int(1) DEFAULT NULL, `compid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`call_id`,`compid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=61308 /*!50100 PARTITION BY HASH (compid) PARTITIONS 400 */;
|
Query OK, 0 rows affected (1.06 sec)
|
|
|