diff options
| author | Elena Stepanova <elenst@montyprogram.com> | 2018-02-15 18:39:29 +0200 |
|---|---|---|
| committer | Elena Stepanova <elenst@montyprogram.com> | 2018-02-15 18:41:32 +0200 |
| commit | 8df787d375ec0aa83d1fb6e2641821aa7438eb55 (patch) | |
| tree | 07a1d56b53ab91c5174164ad27993b518083ce62 /mysql-test/suite/storage_engine/autoincrement.test | |
| parent | 4074c7455655466b81f4f19f77a31fbd9ea605e5 (diff) | |
| download | mariadb-git-8df787d375ec0aa83d1fb6e2641821aa7438eb55.tar.gz | |
Follow-up for 54db0be3be59 (Added Max_index_length and Temporary)
Diffstat (limited to 'mysql-test/suite/storage_engine/autoincrement.test')
| -rw-r--r-- | mysql-test/suite/storage_engine/autoincrement.test | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/suite/storage_engine/autoincrement.test b/mysql-test/suite/storage_engine/autoincrement.test index ddb0ab1b464..1ca0b650039 100644 --- a/mysql-test/suite/storage_engine/autoincrement.test +++ b/mysql-test/suite/storage_engine/autoincrement.test @@ -50,7 +50,7 @@ if (!$mysql_errname) # SHOW TABLE STATUS shows the auto-increment value in column 11, # that's all we need here and further --source mask_engine.inc - --replace_column 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 # + --replace_column 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 # 19 # SHOW TABLE STATUS FROM test LIKE 't1'; # Mix of automatic and explicit values @@ -58,7 +58,7 @@ if (!$mysql_errname) INSERT INTO t1 (a,b) VALUES (6,'g'),(7,'h'); SELECT LAST_INSERT_ID(); - --replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 # + --replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 # 19 # SHOW TABLE STATUS FROM test LIKE 't1'; @@ -66,21 +66,21 @@ if (!$mysql_errname) SELECT a,b FROM t1 ORDER BY a; SELECT LAST_INSERT_ID(); - --replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 # + --replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 # 19 # SHOW TABLE STATUS FROM test LIKE 't1'; # Creating a gap in the sequence INSERT INTO t1 (a,b) VALUES (20,'k'); - --replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 # + --replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 # 19 # SHOW TABLE STATUS FROM test LIKE 't1'; INSERT INTO t1 (a,b) VALUES (NULL,'l'); SELECT a,b FROM t1 ORDER BY a; SELECT LAST_INSERT_ID(); - --replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 # + --replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 # 19 # SHOW TABLE STATUS FROM test LIKE 't1'; # Negative values: we will try to insert one just to check that it does not cause a crash, |