Debian Codegraph @

mysql-test/suite/maria/collations.result

raw
1 DROP TABLE IF EXISTS t1;
2 Warnings:
3 Note 1051 Unknown table 'test.t1'
4 CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_croatian_ci, KEY(a)) ENGINE=ARIA;
5 INSERT INTO t1 VALUES ('na'),('nj'),('nz'),('Z');
6 explain SELECT a FROM t1 ORDER BY a;
7 id select_type table type possible_keys key key_len ref rows Extra
8 1 SIMPLE t1 index NULL a 33 NULL 4 Using index
9 SELECT a FROM t1 ORDER BY a;
10 a
11 na
12 nz
13 nj
14 Z
15 ALTER TABLE t1 engine=myisam;
16 explain SELECT a FROM t1 ORDER BY a;
17 id select_type table type possible_keys key key_len ref rows Extra
18 1 SIMPLE t1 index NULL a 33 NULL 4 Using index
19 SELECT a FROM t1 ORDER BY a;
20 a
21 na
22 nz
23 nj
24 Z
25 drop table t1;