Debian Codegraph @

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

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