← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/having.test

  • 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/t/having.test
81
81
#              select list and TEXT field 
82
82
#
83
83
 
84
 
CREATE TABLE t1 (
 
84
CREATE TEMPORARY TABLE t1 (
85
85
  `id` bigint NOT NULL default '0',
86
86
  `description` text
87
87
) ENGINE=MyISAM;
88
88
 
89
 
CREATE TABLE t2 (
 
89
CREATE TEMPORARY TABLE t2 (
90
90
  `id` bigint NOT NULL default '0',
91
91
  `description` varchar(20)
92
92
) ENGINE=MyISAM;
94
94
INSERT INTO t1  VALUES (1, 'test');
95
95
INSERT INTO t2 VALUES (1, 'test');
96
96
 
97
 
CREATE TABLE t3 (
 
97
CREATE TEMPORARY TABLE t3 (
98
98
  `id`       bigint NOT NULL default '0',
99
99
  `order_id` bigint NOT NULL default '0'
100
100
) ENGINE=MyISAM;