~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/mix2_myisam.result

  • Committer: Brian Aker
  • Date: 2009-11-18 22:58:22 UTC
  • mto: (1223.1.1 push) (1226.1.2 push)
  • mto: This revision was merged to the branch mainline in revision 1224.
  • Revision ID: brian@gaz-20091118225822-4ryr9rviir23o0kr
Second pass through bugs related to CREATE TABLE LIKE

Show diffs side-by-side

added added

removed removed

Lines of Context:
958
958
drop table t1,t2,t3, t4, t5, t6;
959
959
create TEMPORARY table t1 (a int) engine=MyISAM;
960
960
create table t2 like t1;
 
961
ERROR HY000: Can't create table 'test.t2' (errno: 138)
 
962
create table t2 like t1 engine=innodb;
961
963
show create table t2;
962
964
Table   Create Table
963
965
t2      CREATE TABLE `t2` (
964
966
  `a` int DEFAULT NULL
965
 
) ENGINE=MyISAM
 
967
) ENGINE=InnoDB
966
968
drop table t1,t2;
967
969
flush status;
968
970
show status like "binlog_cache_use";