diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2014-06-16 13:34:03 +0400 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2014-06-16 13:34:03 +0400 |
| commit | 581b889771447f7a9f33d467f0b5ef2aa96e072b (patch) | |
| tree | f61a59ead177e392b71c0032ded6e0be40e04608 /mysql-test/r/analyze_stmt.result | |
| parent | 917b22393f16a2143fd0e480473123731be5b6d1 (diff) | |
| download | mariadb-git-581b889771447f7a9f33d467f0b5ef2aa96e072b.tar.gz | |
Update analyze_stmt.result after the last commit
Diffstat (limited to 'mysql-test/r/analyze_stmt.result')
| -rw-r--r-- | mysql-test/r/analyze_stmt.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/analyze_stmt.result b/mysql-test/r/analyze_stmt.result index 42616bce70b..f388450760a 100644 --- a/mysql-test/r/analyze_stmt.result +++ b/mysql-test/r/analyze_stmt.result @@ -46,4 +46,18 @@ a b 8 108 9 9 drop table t1; +# Check that UNION works +create table t1(a int, b int); +insert into t1 select a,a from t0; +analyze (select * from t1 A where a<5) union (select * from t1 B where a in (5,6)); +id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra +1 PRIMARY A ALL NULL NULL NULL NULL 10 10 100.00 50.00 Using where +2 UNION B ALL NULL NULL NULL NULL 10 10 100.00 20.00 Using where +NULL UNION RESULT <union1,2> ALL NULL NULL NULL NULL NULL 7 NULL NULL +analyze (select * from t1 A where a<5) union (select * from t1 B where a in (1,2)); +id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra +1 PRIMARY A ALL NULL NULL NULL NULL 10 10 100.00 50.00 Using where +2 UNION B ALL NULL NULL NULL NULL 10 10 100.00 20.00 Using where +NULL UNION RESULT <union1,2> ALL NULL NULL NULL NULL NULL 5 NULL NULL +drop table t1; drop table t0; |