~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/temp_table.test

  • Committer: Padraig O'Sullivan
  • Date: 2009-08-08 04:22:33 UTC
  • mto: (1115.3.4 captain)
  • mto: This revision was merged to the branch mainline in revision 1117.
  • Revision ID: osullivan.padraig@gmail.com-20090808042233-q0z88zc490z3f3r7
Renamed the Command class to be Statement. Renamed the command directory to
statement and also the command header file to statement. Updated various
source files to reflect this renaming.

Show diffs side-by-side

added added

removed removed

Lines of Context:
18
18
CREATE TABLE t2 (x int not null, y int not null);
19
19
alter table t2 rename t1;
20
20
select * from t1;
21
 
create TEMPORARY TABLE t2 engine=MEMORY select * from t1;
22
 
create TEMPORARY TABLE IF NOT EXISTS t2 (a int) engine=MEMORY;
 
21
create TEMPORARY TABLE t2 engine=heap select * from t1;
 
22
create TEMPORARY TABLE IF NOT EXISTS t2 (a int) engine=heap;
23
23
 
24
24
# This should give errors
25
25
--error 1050
88
88
 
89
89
flush status;
90
90
select * from t1 group by d;
91
 
--replace_column 2 #
92
91
show status like "created_tmp%tables";
93
92
drop table t1;
94
93