← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect.result

  • Committer: Brian Aker
  • Date: 2009-08-18 07:20:29 UTC
  • mfrom: (1117.1.9 merge)
  • Revision ID: brian@gaz-20090818072029-s9ch5lcmltxwidn7
Merge of Brian

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/subselect.result
1093
1093
`pseudo` varchar(35) NOT NULL default '',
1094
1094
PRIMARY KEY  (`id`),
1095
1095
UNIQUE KEY `pseudo` (`pseudo`)
1096
 
) ENGINE=MyISAM PACK_KEYS=1 ROW_FORMAT=DYNAMIC;
 
1096
) ENGINE=MyISAM ROW_FORMAT=DYNAMIC;
1097
1097
INSERT INTO t1 (pseudo) VALUES ('test');
1098
1098
SELECT 0 IN (SELECT 1 FROM t1 a);
1099
1099
0 IN (SELECT 1 FROM t1 a)
1189
1189
PRIMARY KEY  (`id`),
1190
1190
UNIQUE KEY `email` (`email`),
1191
1191
UNIQUE KEY `pseudo` (`pseudo`)
1192
 
) ENGINE=MyISAM PACK_KEYS=1 ROW_FORMAT=DYNAMIC;
 
1192
) ENGINE=MyISAM ROW_FORMAT=DYNAMIC;
1193
1193
INSERT INTO t1 (id,pseudo,email) VALUES (1,'test','test'),(2,'test1','test1');
1194
1194
SELECT pseudo as a, pseudo as b FROM t1 GROUP BY (SELECT a) ORDER BY (SELECT id*1);
1195
1195
a       b