Debian Codegraph @

mysql-test/suite/innodb/t/no_pad.test

raw
1 --source include/have_innodb.inc
2
3 CREATE TABLE t1 (a CHAR(8), id INT, PRIMARY KEY (a,id)) COLLATE utf8_nopad_bin
4 ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
5
6 INSERT INTO t1 VALUES ('',1);
7 ALTER TABLE t1 ROW_FORMAT=DYNAMIC;
8 INSERT INTO t1 VALUES ('',2);
9 ALTER TABLE t1 ROW_FORMAT=REDUNDANT;
10 DROP TABLE t1;
11
12
13 --echo #
14 --echo # MDEV-26743 InnoDB: CHAR+nopad does not work well
15 --echo #
16
17 --echo #
18 --echo # Basic Latin letter vs equal accented letter
19 --echo #
20
21 SET NAMES utf8mb3;
22 CREATE TABLE t1 (a CHAR(2), PRIMARY KEY(a)) COLLATE utf8_unicode_nopad_ci ENGINE=InnoDB ROW_FORMAT=COMPACT;
23 --error ER_DUP_ENTRY
24 INSERT INTO t1 VALUES ('a'),('ä');
25 DROP TABLE t1;
26
27 --echo #
28 --echo # Two letters vs equal (but space padded) expansion
29 --echo #
30
31 CREATE TABLE t1 (a CHAR(2), PRIMARY KEY(a)) COLLATE utf8_unicode_nopad_ci ENGINE=InnoDB ROW_FORMAT=COMPACT;
32 INSERT INTO t1 VALUES ('ss'),('ß');
33 SET sql_mode=PAD_CHAR_TO_FULL_LENGTH;
34 SELECT HEX(a) FROM t1;
35 SET sql_mode=DEFAULT;
36 DROP TABLE t1;
37
38 --echo #
39 --echo # Basic Latin letter (but followed by an ignorable character) vs equal accented letter
40 --echo #
41
42 SET NAMES utf8mb3;
43 CREATE TABLE t1 (a CHAR(3), PRIMARY KEY(a)) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_nopad_ci ENGINE=InnoDB ROW_FORMAT=COMPACT;
44 INSERT INTO t1 VALUES (CONCAT('a',_utf8mb3 0x01)),('ä');
45 SET sql_mode=PAD_CHAR_TO_FULL_LENGTH;
46 SELECT HEX(a) FROM t1 ORDER BY HEX(a);
47 SET sql_mode=DEFAULT;
48 DROP TABLE t1;
49
50 SET NAMES utf8mb3;
51 CREATE TABLE t1 (a CHAR(2), PRIMARY KEY(a)) COLLATE utf8_unicode_nopad_ci ENGINE=InnoDB ROW_FORMAT=COMPACT;
52 INSERT INTO t1 VALUES (CONCAT('a',_utf8mb3 0x01)),('ä');
53 SET sql_mode=PAD_CHAR_TO_FULL_LENGTH;
54 SELECT HEX(a) FROM t1 ORDER BY HEX(a);
55 SET sql_mode=DEFAULT;
56 DROP TABLE t1;