← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/having.result

  • Committer: Brian Aker
  • Date: 2009-06-16 00:53:22 UTC
  • mto: This revision was merged to the branch mainline in revision 1094.
  • Revision ID: brian@gaz-20090616005322-w0ode4jul9z8s2y9
Partial fix for tests for tmp

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/having.result
87
87
5
88
88
9
89
89
drop table t1;
90
 
CREATE TABLE t1 (
 
90
CREATE TEMPORARY TABLE t1 (
91
91
`id` bigint NOT NULL default '0',
92
92
`description` text
93
93
) ENGINE=MyISAM;
94
 
CREATE TABLE t2 (
 
94
CREATE TEMPORARY TABLE t2 (
95
95
`id` bigint NOT NULL default '0',
96
96
`description` varchar(20)
97
97
) ENGINE=MyISAM;
98
98
INSERT INTO t1  VALUES (1, 'test');
99
99
INSERT INTO t2 VALUES (1, 'test');
100
 
CREATE TABLE t3 (
 
100
CREATE TEMPORARY TABLE t3 (
101
101
`id`       bigint NOT NULL default '0',
102
102
`order_id` bigint NOT NULL default '0'
103
103
) ENGINE=MyISAM;