← 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: 2010-03-02 19:10:25 UTC
  • mto: (1317.1.8)
  • mto: This revision was merged to the branch mainline in revision 1322.
  • Revision ID: mordred@inaugust.com-20100302191025-zoxjz4xwkoa6160h
Prevent unauthorized users from changing schema.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/default_collation.result
34
34
show create table t1;
35
35
Table   Create Table
36
36
t1      CREATE TABLE `t1` (
37
 
  `a` VARCHAR(10) COLLATE utf8_bin DEFAULT NULL
38
 
) ENGINE=DEFAULT COLLATE = utf8_bin
 
37
  `a` varchar(10) COLLATE utf8_bin DEFAULT NULL
 
38
) ENGINE=InnoDB
39
39
show create table t2;
40
40
Table   Create Table
41
41
t2      CREATE TABLE `t2` (
42
 
  `a` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
43
 
) ENGINE=DEFAULT COLLATE = utf8_general_ci
 
42
  `a` varchar(10) DEFAULT NULL
 
43
) ENGINE=InnoDB
44
44
select count(*) from t1 where a='a';
45
45
count(*)
46
46
1