Debian Codegraph @

mysql-test/suite/storage_engine/autoinc_secondary.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN> AUTO_INCREMENT, b <CHAR_COLUMN>, PRIMARY KEY (a,b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (b) VALUES ('a'),('b'),('b'),('c'),('a');
4 SELECT LAST_INSERT_ID();
5 LAST_INSERT_ID()
6 1
7 SELECT a,b FROM t1;
8 a b
9 1 a
10 2 b
11 3 b
12 4 c
13 5 a
14 DROP TABLE t1;
15 CREATE TABLE t1 (a <CHAR_COLUMN>, b <INT_COLUMN> AUTO_INCREMENT, PRIMARY KEY (a,b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
16 INSERT INTO t1 (a) VALUES ('a'),('b'),('b'),('c'),('a');
17 SELECT LAST_INSERT_ID();
18 LAST_INSERT_ID()
19 1
20 SELECT a,b FROM t1;
21 a b
22 a 1
23 a 2
24 b 1
25 b 2
26 c 1
27 DROP TABLE t1;
28 CREATE TABLE t1 (a <CHAR_COLUMN>, b <INT_COLUMN> AUTO_INCREMENT, PRIMARY KEY (a,b), <CUSTOM_INDEX>(b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
29 INSERT INTO t1 (a) VALUES ('a'),('b'),('b'),('c'),('a');
30 SELECT LAST_INSERT_ID();
31 LAST_INSERT_ID()
32 1
33 SELECT a,b FROM t1;
34 a b
35 a 1
36 a 5
37 b 2
38 b 3
39 c 4
40 DROP TABLE t1;