9 lines
249 B
Plaintext
9 lines
249 B
Plaintext
# Test BR and AutoIncrement
|
|
|
|
CREATE TABLE t1 (a INT PRIMARY KEY NONCLUSTERED AUTO_INCREMENT, b INT) AUTO_ID_CACHE = 100;
|
|
INSERT INTO t1 (b) VALUES (1), (2), (3);
|
|
SHOW TABLE t1 NEXT_ROW_ID;
|
|
|
|
--backup_and_restore t1 AS tt1
|
|
|
|
SHOW TABLE tt1 NEXT_ROW_ID; |