mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
7f444caa0a
MDEV-11 - Modifed tests and result files to use explicit column lists
in INSERT and SELECT statements
40 lines
920 B
Text
40 lines
920 B
Text
DROP TABLE IF EXISTS t1;
|
|
CREATE TABLE t1 (a <INT_COLUMN> AUTO_INCREMENT, b <CHAR_COLUMN>, PRIMARY KEY (a,b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
|
|
INSERT INTO t1 (b) VALUES ('a'),('b'),('b'),('c'),('a');
|
|
SELECT LAST_INSERT_ID();
|
|
LAST_INSERT_ID()
|
|
1
|
|
SELECT a,b FROM t1;
|
|
a b
|
|
1 a
|
|
2 b
|
|
3 b
|
|
4 c
|
|
5 a
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (a <CHAR_COLUMN>, b <INT_COLUMN> AUTO_INCREMENT, PRIMARY KEY (a,b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
|
|
INSERT INTO t1 (a) VALUES ('a'),('b'),('b'),('c'),('a');
|
|
SELECT LAST_INSERT_ID();
|
|
LAST_INSERT_ID()
|
|
1
|
|
SELECT a,b FROM t1;
|
|
a b
|
|
a 1
|
|
a 2
|
|
b 1
|
|
b 2
|
|
c 1
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (a <CHAR_COLUMN>, b <INT_COLUMN> AUTO_INCREMENT, PRIMARY KEY (a,b), <CUSTOM_INDEX>(b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
|
|
INSERT INTO t1 (a) VALUES ('a'),('b'),('b'),('c'),('a');
|
|
SELECT LAST_INSERT_ID();
|
|
LAST_INSERT_ID()
|
|
1
|
|
SELECT a,b FROM t1;
|
|
a b
|
|
a 1
|
|
a 5
|
|
b 2
|
|
b 3
|
|
c 4
|
|
DROP TABLE t1;
|