← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect_no_mat.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_no_mat.result
1097
1097
`pseudo` varchar(35) NOT NULL default '',
1098
1098
PRIMARY KEY  (`id`),
1099
1099
UNIQUE KEY `pseudo` (`pseudo`)
1100
 
) ENGINE=MyISAM PACK_KEYS=1 ROW_FORMAT=DYNAMIC;
 
1100
) ENGINE=MyISAM ROW_FORMAT=DYNAMIC;
1101
1101
INSERT INTO t1 (pseudo) VALUES ('test');
1102
1102
SELECT 0 IN (SELECT 1 FROM t1 a);
1103
1103
0 IN (SELECT 1 FROM t1 a)
1193
1193
PRIMARY KEY  (`id`),
1194
1194
UNIQUE KEY `email` (`email`),
1195
1195
UNIQUE KEY `pseudo` (`pseudo`)
1196
 
) ENGINE=MyISAM PACK_KEYS=1 ROW_FORMAT=DYNAMIC;
 
1196
) ENGINE=MyISAM ROW_FORMAT=DYNAMIC;
1197
1197
INSERT INTO t1 (id,pseudo,email) VALUES (1,'test','test'),(2,'test1','test1');
1198
1198
SELECT pseudo as a, pseudo as b FROM t1 GROUP BY (SELECT a) ORDER BY (SELECT id*1);
1199
1199
a       b