Debian Codegraph @

mysql-test/suite/funcs_2/include/check_charset.inc

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS test.t1;
3 --enable_warnings
4
5 eval SET NAMES $cset;
6
7 let $std_cset= 1;
8
9 if ($bin_cset)
10 {
11 eval CREATE TABLE test.t1 (a VARCHAR(3) CHARACTER SET $cset) ENGINE=$engine_type CHARACTER SET $cset;
12 let $bin_cset= 0;
13 let $std_cset= 0;
14 }
15 if ($std_cset)
16 {
17 eval CREATE TABLE test.t1 (a VARCHAR(3) CHARACTER SET $cset COLLATE $coll) ENGINE=$engine_type CHARACTER SET $cset COLLATE $coll;
18 }
19
20 --replace_column 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 11 # 12 # 13 # 14 # 16 # 17 # 18 # 19 #
21 SHOW TABLE STATUS LIKE 't1';
22
23 --disable_warnings
24 --disable_query_log
25 ALTER TABLE test.t1 ADD code VARCHAR(16) NOT NULL;
26 let $1= 221;
27 while ($1)
28 {
29 eval INSERT IGNORE INTO test.t1 VALUES(CHAR(254-$1), HEX(254-$1));
30 dec $1;
31 }
32 DELETE FROM test.t1 WHERE CHAR_LENGTH(a) <> 1;
33 DELETE FROM test.t1 WHERE a='?' AND code<>'3F';
34 --enable_query_log
35 --enable_warnings
36
37 SELECT HEX(ASCII(a)) AS a_ascii, CHAR_LENGTH(a) AS a_len FROM test.t1 ORDER BY a, ORD(a);
38
39 --disable_warnings
40 DROP TABLE IF EXISTS test.t1;
41 --enable_warnings
42