diff options
Diffstat (limited to 'mysql-test/t/intersect.test')
-rw-r--r-- | mysql-test/t/intersect.test | 44 |
1 files changed, 32 insertions, 12 deletions
diff --git a/mysql-test/t/intersect.test b/mysql-test/t/intersect.test index 68ada126686..d7abf41a8b2 100644 --- a/mysql-test/t/intersect.test +++ b/mysql-test/t/intersect.test @@ -8,9 +8,9 @@ insert into t2 values (2,2),(3,3); drop tables t1,t2; -create table t1 (a int, b int); -create table t2 (c int, d int); -create table t3 (e int, f int); +create table t1 (a int, b int) engine=MyISAM; +create table t2 (c int, d int) engine=MyISAM; +create table t3 (e int, f int) engine=MyISAM; insert into t1 values (1,1),(2,2),(3,3); insert into t2 values (2,2),(3,3),(4,4); insert into t3 values (1,1),(2,2),(5,5); @@ -34,6 +34,26 @@ prepare stmt from "select * from ((select a,b from t1) intersect (select c,d fro execute stmt; execute stmt; +(select a,b from t1) intersect (select c,e from t2,t3); +EXPLAIN (select a,b from t1) intersect (select c,e from t2,t3); +EXPLAIN extended (select a,b from t1) intersect (select c,e from t2,t3); +EXPLAIN extended select * from ((select a,b from t1) intersect (select c,e from t2,t3)) a; +EXPLAIN format=json (select a,b from t1) intersect (select c,e from t2,t3); +--replace_regex /"r_total_time_ms": [0-9]*[.]?[0-9]*/"r_total_time_ms": "REPLACED"/ +ANALYZE format=json (select a,b from t1) intersect (select c,e from t2,t3); +--replace_regex /"r_total_time_ms": [0-9]*[.]?[0-9]*/"r_total_time_ms": "REPLACED"/ +ANALYZE format=json select * from ((select a,b from t1) intersect (select c,e from t2,t3)) a; +select * from ((select a,b from t1) intersect (select c,e from t2,t3)) a; + +prepare stmt from "(select a,b from t1) intersect (select c,e from t2,t3);"; +execute stmt; +execute stmt; + +prepare stmt from "select * from ((select a,b from t1) intersect (select c,e from t2,t3)) a"; +execute stmt; +execute stmt; + + drop tables t1,t2,t3; @@ -59,9 +79,9 @@ insert into t2 values (2, "fgh", 2, "dffggtt"),(3, "ffggddd", 3, "dfgg"); drop tables t1,t2; -create table t1 (a int, b blob); -create table t2 (c int, d blob); -create table t3 (e int, f blob); +create table t1 (a int, b blob) engine=MyISAM; +create table t2 (c int, d blob) engine=MyISAM; +create table t3 (e int, f blob) engine=MyISAM; insert into t1 values (1,1),(2,2),(3,3); insert into t2 values (2,2),(3,3),(4,4); insert into t3 values (1,1),(2,2),(5,5); @@ -83,9 +103,9 @@ show create table t4; drop tables t1,t2,t3,t4; -create table t1 (a int, b blob); -create table t2 (c int, d blob); -create table t3 (e int, f blob); +create table t1 (a int, b blob) engine=MyISAM; +create table t2 (c int, d blob) engine=MyISAM; +create table t3 (e int, f blob) engine=MyISAM; insert into t1 values (1,1),(2,2),(3,3); insert into t2 values (2,2),(3,3); insert into t3 values (1,1),(2,2),(3,3); @@ -116,9 +136,9 @@ drop tables t1,t2,t3; --echo # --echo # INTERSECT precedence --echo # -create table t1 (a int, b blob); -create table t2 (c int, d blob); -create table t3 (e int, f blob); +create table t1 (a int, b blob) engine=MyISAM; +create table t2 (c int, d blob) engine=MyISAM; +create table t3 (e int, f blob) engine=MyISAM; insert into t1 values (5,5),(6,6); insert into t2 values (2,2),(3,3); insert into t3 values (1,1),(3,3); |