← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/create.result

  • Committer: Brian Aker
  • Date: 2009-11-18 03:04:25 UTC
  • mto: This revision was merged to the branch mainline in revision 1222.
  • Revision ID: brian@gaz-20091118030425-ezceti6llrwg464p
Updated fix for create table like.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/create.result
1441
1441
) ENGINE=DEFAULT
1442
1442
drop table имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48;
1443
1443
create table t1 like information_schema.processlist;
 
1444
ERROR HY000: Table storage engine 'INFORMATION_ENGINE' does not support the create option 'TEMPORARY'
 
1445
create table t1 like information_schema.processlist engine=innodb;
1444
1446
show create table t1;
1445
1447
Table   Create Table
1446
1448
t1      CREATE TABLE `t1` (
1452
1454
  `TIME` bigint NOT NULL DEFAULT '0',
1453
1455
  `STATE` varchar(64) DEFAULT NULL,
1454
1456
  `INFO` text
1455
 
) ENGINE=MyISAM
 
1457
) ENGINE=InnoDB
1456
1458
drop table t1;
1457
1459
create temporary table t1 like information_schema.processlist;
 
1460
ERROR HY000: Table storage engine 'INFORMATION_ENGINE' does not support the create option 'TEMPORARY'
 
1461
create temporary table t1 like information_schema.processlist engine=myisam;
1458
1462
show create table t1;
1459
1463
Table   Create Table
1460
1464
t1      CREATE TEMPORARY TABLE `t1` (