← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/union.test

  • Committer: Monty Taylor
  • Date: 2010-03-11 18:27:20 UTC
  • mfrom: (1333 staging)
  • mto: This revision was merged to the branch mainline in revision 1348.
  • Revision ID: mordred@inaugust.com-20100311182720-hd1h87y6cb1b1mp0
Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/union.test
474
474
insert t1 select a+1, a+b from t1;
475
475
insert t1 select a+1, a+b from t1;
476
476
FLUSH STATUS;
 
477
--replace_column 2 #
477
478
show status like 'Slow_queries';
478
479
select count(*) from t1 where a=7;
 
480
--replace_column 2 #
479
481
show status like 'Slow_queries';
480
482
select count(*) from t1 where b=13;
 
483
--replace_column 2 #
481
484
show status like 'Slow_queries';
482
485
select count(*) from t1 where b=13 union select count(*) from t1 where a=7;
 
486
--replace_column 2 #
483
487
show status like 'Slow_queries';
484
488
select count(*) from t1 where a=7 union select count(*) from t1 where b=13;
 
489
--replace_column 2 #
485
490
show status like 'Slow_queries';
486
491
# additional test for examined rows
487
492
flush status;
488
493
select a from t1 where b not in (1,2,3) union select a from t1 where b not in (4,5,6); 
 
494
--replace_column 2 #
489
495
show status like 'Slow_queries';
490
496
drop table t1;
491
497
 
801
807
create table t2 select * from t1 union select 'abcdefghijkl';
802
808
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
803
809
show create table t2;
804
 
select row_format from information_schema.TABLES where table_schema="test" and table_name="t2";
 
810
select row_format from data_dictionary.TABLES where table_schema="test" and table_name="t2";
805
811
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
806
812
show create table t2;
807
813
drop table t1,t2;