← Back to branch summary

~drizzle-pbxt/drizzle/drizzle-pbxt-2

« back to all changes in this revision

Viewing changes to tests/r/having.result

  • Committer: Paul McCullagh
  • Date: 2009-11-10 14:18:39 UTC
  • mfrom: (1038.1.7 drizzle-pbxt-pre-merge)
  • Revision ID: paul.mccullagh@primebase.org-20091110141839-2j3k43b17ag6f605
Merged Drizzle trunk and PBXT 1.0.09

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;