Debian Codegraph @

mysql-test/suite/innodb/t/innodb-2byte-collation.test

raw
1 # Test for InnoDB support of 2 bytes (15 bits) collation ID
2 # Some of the example and test setup are adopted from ctype_ldml.test
3
4 --source include/have_debug.inc
5
6 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
7 show variables like 'character_sets_dir%';
8
9 set names utf8;
10
11 # Test that the "ID" column in I_S and SHOW queries can handle two bytes
12 select collation_name, character_set_name, id from information_schema.collations where id>256 order by id;
13 show collation like '%test%';
14
15 # Test that two-byte collation ID is correctly transfered to the client side.
16 show collation like 'ucs2_vn_ci';
17 create table 2byte_collation (c1 char(1) character set ucs2 collate ucs2_vn_ci)
18 engine = InnoDB;
19
20 insert into 2byte_collation values (0x0061);
21 --enable_metadata
22 set @@character_set_results=NULL;
23 select hex(c1) from 2byte_collation;
24 --disable_metadata
25 drop table 2byte_collation;
26
27 #
28 # Check maximum collation ID (2047 as of MySQL-6.0.9)
29 #
30 CREATE TABLE 2byte_collation (s1 char(10) character set utf8 collate utf8_maxuserid_ci) engine = innodb;
31 INSERT INTO 2byte_collation VALUES ('a'),('b');
32 SELECT * FROM 2byte_collation WHERE s1='a' ORDER BY BINARY s1;
33 DROP TABLE 2byte_collation;
34
35 # Excercise some change buffer code with the help of
36 # "innodb_change_buffering_debug"
37 -- error 0,ER_UNKNOWN_SYSTEM_VARIABLE
38 SET @innodb_change_buffering_debug_orig = @@innodb_change_buffering_debug;
39 -- error 0,ER_UNKNOWN_SYSTEM_VARIABLE
40 SET GLOBAL innodb_change_buffering_debug = 1;
41
42 -- enable_query_log
43
44 set names utf8;
45
46 show collation like 'utf8_maxuserid_ci';
47
48 CREATE TABLE 2byte_collation(
49 a INT AUTO_INCREMENT PRIMARY KEY,
50 b CHAR(100) character set utf8 collate utf8_maxuserid_ci,
51 c INT,
52 z INT,
53 INDEX(b))
54 ENGINE=InnoDB STATS_PERSISTENT=0;
55
56 INSERT INTO 2byte_collation VALUES(0,'x',1, 1);
57
58 CREATE UNIQUE INDEX idx3 ON 2byte_collation(c, b);
59
60 INSERT INTO 2byte_collation SELECT 0,b,c+1,z+1 FROM 2byte_collation;
61 INSERT INTO 2byte_collation SELECT 0,b,c+10,z+10 FROM 2byte_collation;
62 INSERT INTO 2byte_collation SELECT 0,b,c+20,z+20 FROM 2byte_collation;
63 INSERT INTO 2byte_collation SELECT 0,b,c+50,z+50 FROM 2byte_collation;
64 INSERT INTO 2byte_collation SELECT 0,b,c+100,z+100 FROM 2byte_collation;
65 INSERT INTO 2byte_collation SELECT 0,b,c+200,z+200 FROM 2byte_collation;
66 INSERT INTO 2byte_collation SELECT 0,b,c+400,z+400 FROM 2byte_collation;
67 INSERT INTO 2byte_collation SELECT 0,b,c+800,z+800 FROM 2byte_collation;
68 INSERT INTO 2byte_collation SELECT 0,b,c+1600,z+1600 FROM 2byte_collation;
69 INSERT INTO 2byte_collation SELECT 0,b,c+4000,z+4000 FROM 2byte_collation;
70
71 CREATE INDEX idx5 ON 2byte_collation(b, c);
72
73 SELECT b FROM 2byte_collation LIMIT 10;
74
75 INSERT INTO 2byte_collation VALUES (10001, "a", 20001, 20001);
76
77 UPDATE 2byte_collation set b = "aaa" where c = 20001;
78
79 DROP TABLE 2byte_collation;
80
81 -- error 0, ER_UNKNOWN_SYSTEM_VARIABLE
82 SET GLOBAL innodb_change_buffering_debug = 0;
83