Debian Codegraph @

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

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