← 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-17 06:21:44 UTC
  • mto: This revision was merged to the branch mainline in revision 1118.
  • Revision ID: brian@gaz-20090817062144-8lxn1sg93pd8nhev
Remove PACK_KEYS

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