← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/group_min_max.result

  • Committer: Brian Aker
  • Date: 2009-11-26 02:37:40 UTC
  • mto: (1226.1.2 push)
  • mto: This revision was merged to the branch mainline in revision 1227.
  • Revision ID: brian@gaz-20091126023740-oqpp5xsxmirrgbnp
Remove OPTIMIZE, place in ALTER TABLE (which does the same thing).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/group_min_max.result
1965
1965
drop table t1;
1966
1966
CREATE TABLE t1 (a varchar(5), b int, PRIMARY KEY (a,b));
1967
1967
INSERT INTO t1 VALUES ('AA',1), ('AA',2), ('AA',3), ('BB',1), ('AA',4);
1968
 
OPTIMIZE TABLE t1;
1969
 
Table   Op      Msg_type        Msg_text
1970
 
test.t1 optimize        status  OK
 
1968
ALTER TABLE t1 ENGINE="DEFAULT";
1971
1969
SELECT a FROM t1 WHERE a='AA' GROUP BY a;
1972
1970
a
1973
1971
AA