1002.1.2
by Devananda vdv
created test case for default database collation |
1 |
create database mysqltest collate = utf8_bin; |
1089.10.1
by Stewart Smith
fix SHOW CREATE DATABASE for default collation. Move database metadata reading code around to be a bit more sane. |
2 |
show create database mysqltest; |
3 |
Database Create Database |
|
4 |
mysqltest CREATE DATABASE `mysqltest` COLLATE = utf8_bin |
|
1235.4.15
by Stewart Smith
commit test case showing buggy ALTER DATABASE COLLATE = foo that was broken by previous patch (fix coming in next commit) |
5 |
alter database mysqltest collate = utf8_general_ci; |
6 |
show create database mysqltest; |
|
7 |
Database Create Database |
|
1273.19.28
by Brian Aker
More cleanup on ALTER SCHEMA. Hey! MySQL never had errors on half of it... |
8 |
mysqltest CREATE DATABASE `mysqltest` COLLATE = utf8_general_ci |
1235.4.15
by Stewart Smith
commit test case showing buggy ALTER DATABASE COLLATE = foo that was broken by previous patch (fix coming in next commit) |
9 |
alter database mysqltest collate = utf8_bin; |
10 |
show create database mysqltest; |
|
11 |
Database Create Database |
|
12 |
mysqltest CREATE DATABASE `mysqltest` COLLATE = utf8_bin |
|
1002.1.2
by Devananda vdv
created test case for default database collation |
13 |
use mysqltest; |
14 |
create table t1 (a varchar(10)); |
|
15 |
create table t2 (a varchar(10)) collate = utf8_general_ci; |
|
16 |
insert into t1 values ('a'),('A'),('aA'),('Aa'),('ab'),('Ab'); |
|
17 |
insert into t2 values ('a'),('A'),('aA'),('Aa'),('ab'),('Ab'); |
|
18 |
select * from t1 order by a; |
|
19 |
a
|
|
20 |
A
|
|
21 |
Aa
|
|
22 |
Ab
|
|
23 |
a
|
|
24 |
aA
|
|
25 |
ab
|
|
26 |
select * from t2 order by a; |
|
27 |
a
|
|
28 |
a
|
|
29 |
A
|
|
30 |
aA
|
|
31 |
Aa
|
|
32 |
ab
|
|
33 |
Ab
|
|
34 |
show create table t1; |
|
35 |
Table Create Table |
|
36 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
37 |
`a` VARCHAR(10) COLLATE utf8_bin DEFAULT NULL |
1638.10.67
by Stewart Smith
default_collation.result with explicit COLLATE in SHOW CREATE TABLE |
38 |
) ENGINE=DEFAULT COLLATE = utf8_bin |
1002.1.2
by Devananda vdv
created test case for default database collation |
39 |
show create table t2; |
40 |
Table Create Table |
|
41 |
t2 CREATE TABLE `t2` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
42 |
`a` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL |
1638.10.67
by Stewart Smith
default_collation.result with explicit COLLATE in SHOW CREATE TABLE |
43 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1002.1.2
by Devananda vdv
created test case for default database collation |
44 |
select count(*) from t1 where a='a'; |
45 |
count(*) |
|
46 |
1
|
|
47 |
select count(*) from t2 where a='a'; |
|
48 |
count(*) |
|
49 |
2
|
|
50 |
select count(*) from t1 where a like 'a%'; |
|
51 |
count(*) |
|
52 |
3
|
|
53 |
select count(*) from t2 where a like 'a%'; |
|
54 |
count(*) |
|
55 |
6
|
|
56 |
drop table if exists t1; |
|
57 |
drop table if exists t2; |
|
58 |
drop database if exists mysqltest; |