Debian Codegraph @

mysql-test/suite/storage_engine/index_primary.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN> PRIMARY KEY,
3 b <CHAR_COLUMN>
4 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
5 SHOW KEYS IN t1;
6 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
7 t1 0 PRIMARY 1 a # # NULL NULL # #
8 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
9 INSERT INTO t1 (a,b) VALUES (1,'c');
10 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
11 # Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY).
12 # If you got a difference in error message, just add it to rdiff file
13 DROP TABLE t1;
14 CREATE TABLE t1 (a <INT_COLUMN> PRIMARY KEY,
15 b <CHAR_COLUMN> PRIMARY KEY
16 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
17 ERROR 42000: Multiple primary key defined
18 CREATE TABLE t1 (a <INT_COLUMN>,
19 b <CHAR_COLUMN>,
20 PRIMARY KEY (a,b)
21 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
22 SHOW INDEX IN t1;
23 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
24 t1 0 PRIMARY 1 a # # NULL NULL # #
25 t1 0 PRIMARY 2 b # # NULL NULL # #
26 INSERT INTO t1 (a,b) VALUES (1,'a'),(1,'b'),(2,'a'),(2,'b');
27 INSERT INTO t1 (a,b) VALUES (1,'b');
28 ERROR 23000: Duplicate entry '1-b' for key 'PRIMARY'
29 # Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY).
30 # If you got a difference in error message, just add it to rdiff file
31 DROP TABLE t1;
32 CREATE TABLE t1 (a <INT_COLUMN> KEY,
33 b <CHAR_COLUMN>,
34 <CUSTOM_INDEX> (b)
35 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
36 SHOW INDEX IN t1;
37 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
38 t1 0 PRIMARY 1 a # # NULL NULL # #
39 t1 1 b 1 b # # NULL NULL # #
40 DROP TABLE t1;
41 CREATE TABLE t1 (a <INT_COLUMN>,
42 b <CHAR_COLUMN> PRIMARY KEY
43 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
44 SHOW INDEX IN t1;
45 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
46 t1 0 PRIMARY 1 b # # NULL NULL # #
47 ALTER TABLE t1 DROP INDEX `PRIMARY`;
48 ALTER TABLE t1 ADD CONSTRAINT PRIMARY KEY pk (a);
49 SHOW KEYS IN t1;
50 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
51 t1 0 PRIMARY 1 a # # NULL NULL # #
52 ALTER TABLE t1 DROP PRIMARY KEY;
53 DROP TABLE t1;