Debian Codegraph @

mysql-test/suite/engines/funcs/r/ta_string_to_pk.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(30) NOT NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t1
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `c1` char(30) NOT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 ALTER TABLE t1 ADD PRIMARY KEY (c1);
12 SHOW TABLES;
13 Tables_in_test
14 t1
15 SHOW CREATE TABLE t1;
16 Table Create Table
17 t1 CREATE TABLE `t1` (
18 `c1` char(30) NOT NULL,
19 PRIMARY KEY (`c1`)
20 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
21 DROP TABLE t1;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL);
25 SHOW TABLES;
26 Tables_in_test
27 t1
28 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `c1` varchar(30) NOT NULL
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 ALTER TABLE t1 ADD PRIMARY KEY (c1);
34 SHOW TABLES;
35 Tables_in_test
36 t1
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `c1` varchar(30) NOT NULL,
41 PRIMARY KEY (`c1`)
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 DROP TABLE t1;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TABLE t1(c1 BINARY(30) NOT NULL);
47 SHOW TABLES;
48 Tables_in_test
49 t1
50 SHOW CREATE TABLE t1;
51 Table Create Table
52 t1 CREATE TABLE `t1` (
53 `c1` binary(30) NOT NULL
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 ALTER TABLE t1 ADD PRIMARY KEY (c1);
56 SHOW TABLES;
57 Tables_in_test
58 t1
59 SHOW CREATE TABLE t1;
60 Table Create Table
61 t1 CREATE TABLE `t1` (
62 `c1` binary(30) NOT NULL,
63 PRIMARY KEY (`c1`)
64 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE t1;
66 SHOW TABLES;
67 Tables_in_test
68 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL);
69 SHOW TABLES;
70 Tables_in_test
71 t1
72 SHOW CREATE TABLE t1;
73 Table Create Table
74 t1 CREATE TABLE `t1` (
75 `c1` varbinary(30) NOT NULL
76 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
77 ALTER TABLE t1 ADD PRIMARY KEY (c1);
78 SHOW TABLES;
79 Tables_in_test
80 t1
81 SHOW CREATE TABLE t1;
82 Table Create Table
83 t1 CREATE TABLE `t1` (
84 `c1` varbinary(30) NOT NULL,
85 PRIMARY KEY (`c1`)
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE t1;
88 SHOW TABLES;
89 Tables_in_test