← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/default_collation.result

  • Committer: Monty Taylor
  • Date: 2009-09-16 18:18:47 UTC
  • mto: (1128.1.1 captain-20090921-01)
  • mto: This revision was merged to the branch mainline in revision 1132.
  • Revision ID: mordred@inaugust.com-20090916181847-2qqbr62u1bjc8otr
https://launchpad.net/bugs/430740
Removed unused dtrace.m4 file.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/default_collation.result
2
2
show create database mysqltest;
3
3
Database        Create Database
4
4
mysqltest       CREATE DATABASE `mysqltest` COLLATE = utf8_bin
5
 
alter database mysqltest collate = utf8_general_ci;
6
 
show create database mysqltest;
7
 
Database        Create Database
8
 
mysqltest       CREATE DATABASE `mysqltest` COLLATE = utf8_general_ci
9
 
alter database mysqltest collate = utf8_bin;
10
 
show create database mysqltest;
11
 
Database        Create Database
12
 
mysqltest       CREATE DATABASE `mysqltest` COLLATE = utf8_bin
13
5
use mysqltest;
14
6
create table t1 (a varchar(10));
15
7
create table t2 (a varchar(10)) collate = utf8_general_ci;
34
26
show create table t1;
35
27
Table   Create Table
36
28
t1      CREATE TABLE `t1` (
37
 
  `a` VARCHAR(10) COLLATE utf8_bin DEFAULT NULL
38
 
) ENGINE=DEFAULT COLLATE = utf8_bin
 
29
  `a` varchar(10) COLLATE utf8_bin DEFAULT NULL
 
30
) ENGINE=InnoDB
39
31
show create table t2;
40
32
Table   Create Table
41
33
t2      CREATE TABLE `t2` (
42
 
  `a` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
43
 
) ENGINE=DEFAULT COLLATE = utf8_general_ci
 
34
  `a` varchar(10) DEFAULT NULL
 
35
) ENGINE=InnoDB
44
36
select count(*) from t1 where a='a';
45
37
count(*)
46
38
1