← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/order_by.test

  • 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/t/order_by.test
451
451
insert into t1 select null, b, c, d from t2;
452
452
insert into t2 select null, b, c, d from t1;
453
453
insert into t1 select null, b, c, d from t2;
454
 
optimize table t1;
 
454
alter table t1 engine="default";
455
455
set @row=10;
456
456
insert into t1 select 1, b, c + (@row:=@row - 1) * 10, d - @row from t2 limit 10;
457
457
select * from t1 where a=1 and b in (1) order by c, b, a;