Debian Codegraph @

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

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