Spracherkennung für: .test vermutete Sprache: SQL {SQL[170] ABAP[100] VDM[50]} [Methode: maximale Elemente, drei Dimensionen]
--source include/have_rocksdb.inc
#
# Check whether AUTO_INCREMENT option
# is supported in CREATE and ALTER TABLE
#
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY) ENGINE=rocksdb AUTO_INCREMENT=10;
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (NULL);
SELECT * FROM t1;
ALTER TABLE t1 AUTO_INCREMENT=100;
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (NULL);
SELECT * FROM t1 ORDER BY a;
ALTER TABLE t1 AUTO_INCREMENT=50;
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (NULL);
SELECT * FROM t1 ORDER BY a;
DROP TABLE t1;
[Dauer der Verarbeitung: 0.1 Sekunden, vorverarbeitet 2026-10-08]
