← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/default_collation.result

  • Committer: Stewart Smith
  • Date: 2010-07-27 00:49:32 UTC
  • mto: (1720.1.1 drizzle)
  • mto: This revision was merged to the branch mainline in revision 1721.
  • Revision ID: stewart@flamingspork.com-20100727004932-basq3vx9szmmbswm
fix storing and manipulating foreign keys in the proto around ALTER TABLE, CREATE TABLE and ALTER TABLE ADD/DROP FOREIGN KEY. We also (mostly) emulate the naming of innodb foreign keys in the upper layer.

Show diffs side-by-side

added added

removed removed

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