← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/select.test

  • Committer: lbieber
  • Date: 2010-08-23 22:45:16 UTC
  • mfrom: (1727.2.1 staging)
  • Revision ID: lbieber@orisndriz03-20100823224516-k12j5r4znqnznr9d
Merge Vijay - bug 621866 - Changed --transaction-log.sync-method to --transaction-log.flush-frequency
Merge Lee - bug 622005 updateing test results that need to sorted by adding --sorted_result - 
Merge Andrew - bug #617537 re-connect connectionID is wrong 
Merge Andrew - bug #617534 incorrect error when reconnecting

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/select.test
1535
1535
#
1536
1536
 
1537
1537
select * from t1,t1 t12;
 
1538
--sorted_result
1538
1539
select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >= 250501 and t22.fld1 <= 250505;
1539
1540
 
1540
1541
#
1828
1829
insert into t1 values ();
1829
1830
insert into t1 values ();
1830
1831
# ,
 
1832
--sorted_result
1831
1833
select * from (t1 as t2 left join t1 as t3 using (a)), t1;
1832
1834
select * from t1, (t1 as t2 left join t1 as t3 using (a));
1833
1835
# stright_join