← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/union.test

  • Committer: Tim Penhey
  • Date: 2010-01-20 02:39:01 UTC
  • mto: This revision was merged to the branch mainline in revision 1275.
  • Revision ID: tim.penhey@canonical.com-20100120023901-8teeunid6gwlthzx
Add in a rot 13 function.

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 #
478
477
show status like 'Slow_queries';
479
478
select count(*) from t1 where a=7;
480
 
--replace_column 2 #
481
479
show status like 'Slow_queries';
482
480
select count(*) from t1 where b=13;
483
 
--replace_column 2 #
484
481
show status like 'Slow_queries';
485
482
select count(*) from t1 where b=13 union select count(*) from t1 where a=7;
486
 
--replace_column 2 #
487
483
show status like 'Slow_queries';
488
484
select count(*) from t1 where a=7 union select count(*) from t1 where b=13;
489
 
--replace_column 2 #
490
485
show status like 'Slow_queries';
491
486
# additional test for examined rows
492
487
flush status;
493
488
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 #
495
489
show status like 'Slow_queries';
496
490
drop table t1;
497
491
 
807
801
create table t2 select * from t1 union select 'abcdefghijkl';
808
802
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
809
803
show create table t2;
810
 
select row_format from data_dictionary.TABLES where table_schema="test" and table_name="t2";
 
804
select row_format from information_schema.TABLES where table_schema="test" and table_name="t2";
811
805
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
812
806
show create table t2;
813
807
drop table t1,t2;