Debian Codegraph @

mysql-test/suite/innodb/r/sql_mode_pad_char_to_full_length.result

raw
1 SET default_storage_engine=InnoDB;
2 #
3 # Start of 10.4 tests
4 #
5 #
6 # MDEV-28190 sql_mode makes MDEV-371 virtual column expressions nondeterministic
7 #
8 #
9 # MDEV-28190 sql_mode makes MDEV-371 virtual column expressions nondeterministic
10 #
11 CREATE TABLE t1 (a INT,b CHAR(20));
12 SHOW CREATE TABLE t1;
13 Table Create Table
14 t1 CREATE TABLE `t1` (
15 `a` int(11) DEFAULT NULL,
16 `b` char(20) DEFAULT NULL
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
18 CREATE UNIQUE INDEX bi USING HASH ON t1 (b);
19 INSERT INTO t1 VALUES (0,0);
20 SET sql_mode='pad_char_to_full_length';
21 DELETE FROM t1;
22 DROP TABLE t1;
23 SET sql_mode='';
24 CREATE TABLE t1 (a INT,b CHAR(20));
25 SHOW CREATE TABLE t1;
26 Table Create Table
27 t1 CREATE TABLE `t1` (
28 `a` int(11) DEFAULT NULL,
29 `b` char(20) DEFAULT NULL
30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
31 CREATE UNIQUE INDEX bi USING HASH ON t1 (b);
32 SET sql_mode='pad_char_to_full_length';
33 INSERT INTO t1 VALUES (0,0);
34 DELETE FROM t1;
35 DROP TABLE t1;
36 SET sql_mode='';
37 CREATE OR REPLACE TABLE t1 (a CHAR(20),b CHAR(20));
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `a` char(20) DEFAULT NULL,
42 `b` char(20) DEFAULT NULL
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
44 CREATE UNIQUE INDEX bi USING HASH ON t1 (b);
45 INSERT INTO t1 VALUES (0,0);
46 SET sql_mode='pad_char_to_full_length';
47 DELETE FROM t1;
48 DROP TABLE t1;
49 #
50 # End of 10.4 tests
51 #