~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/create.result

  • Committer: Monty Taylor
  • Date: 2010-05-21 06:34:40 UTC
  • mfrom: (1530.3.1)
  • mto: (1530.2.8)
  • mto: This revision was merged to the branch mainline in revision 1556.
  • Revision ID: mordred@inaugust.com-20100521063440-n98r0n8mgb0hg65d
Merged align-static-plugins into plugin-to-module.

Show diffs side-by-side

added added

removed removed

Lines of Context:
44
44
  `a` int DEFAULT NULL
45
45
) ENGINE=DEFAULT
46
46
create table t1 like `a/a`;
 
47
show create table t1;
 
48
Table   Create Table
 
49
t1      CREATE TABLE `t1` (
 
50
  `a` int DEFAULT NULL
 
51
) ENGINE=DEFAULT
 
52
show create table `t1`;
 
53
Table   Create Table
 
54
t1      CREATE TABLE `t1` (
 
55
  `a` int DEFAULT NULL
 
56
) ENGINE=DEFAULT
47
57
drop table `a/a`;
48
58
drop table `t1`;
49
59
create table `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa int);
1481
1491
c4 VARCHAR(255) NOT NULL DEFAULT 'a',
1482
1492
c5 VARCHAR(255) COLLATE utf8_unicode_ci NULL DEFAULT 'b',
1483
1493
c6 VARCHAR(255))
1484
 
COLLATE utf8_bin;
 
1494
COLLATE=utf8_bin;
1485
1495
 
1486
1496
SHOW CREATE TABLE t1;
1487
1497
Table   Create Table