1272
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
1273
SHOW VARIABLES LIKE "%auto_inc%";
1275
auto_increment_increment 1
1276
auto_increment_offset 1
1277
CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
1278
INSERT INTO t1 VALUES (2147483648, 'a');
1279
SHOW CREATE TABLE t1;
1281
t1 CREATE TABLE `t1` (
1282
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1283
`c2` varchar(10) DEFAULT NULL,
1285
) ENGINE=InnoDB AUTO_INCREMENT=2147483649 DEFAULT CHARSET=latin1
1289
ALTER TABLE t1 CHANGE c1 c1 INT;
1291
Warning 1264 Out of range value for column 'c1' at row 1
1292
SHOW CREATE TABLE t1;
1294
t1 CREATE TABLE `t1` (
1295
`c1` int(11) NOT NULL DEFAULT '0',
1296
`c2` varchar(10) DEFAULT NULL,
1298
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1299
INSERT INTO t1(c2) VALUES('b');
1304
SHOW CREATE TABLE t1;
1306
t1 CREATE TABLE `t1` (
1307
`c1` int(11) NOT NULL DEFAULT '0',
1308
`c2` varchar(10) DEFAULT NULL,
1310
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1312
CREATE TABLE t1 (c1 INT AUTO_INCREMENT PRIMARY KEY, c2 INT) ENGINE = MyISAM;
1313
INSERT INTO t1 (c1) VALUES (NULL), (-290783232), (NULL);
1315
Warning 1264 Out of range value for column 'c1' at row 3
1316
SHOW CREATE TABLE t1;
1318
t1 CREATE TABLE `t1` (
1319
`c1` int(11) NOT NULL AUTO_INCREMENT,
1320
`c2` int(11) DEFAULT NULL,
1322
) ENGINE=MyISAM AUTO_INCREMENT=2147483648 DEFAULT CHARSET=latin1
1328
ALTER TABLE t1 ENGINE = InnoDB;
1334
SHOW CREATE TABLE t1;
1336
t1 CREATE TABLE `t1` (
1337
`c1` int(11) NOT NULL AUTO_INCREMENT,
1338
`c2` int(11) DEFAULT NULL,
1340
) ENGINE=InnoDB AUTO_INCREMENT=2147483648 DEFAULT CHARSET=latin1
1341
REPLACE INTO t1 (c2 ) VALUES (0);
1342
ERROR HY000: Failed to read auto-increment value from storage engine
1349
CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB
1350
AUTO_INCREMENT=10000000000000000000;
1351
SHOW CREATE TABLE t1;
1353
t1 CREATE TABLE `t1` (
1354
`c1` double NOT NULL AUTO_INCREMENT,
1356
) ENGINE=InnoDB AUTO_INCREMENT=10000000000000000000 DEFAULT CHARSET=latin1
1357
INSERT INTO t1 VALUES ();
1358
ERROR HY000: Failed to read auto-increment value from storage engine