diff options
| author | unknown <sergefp@mysql.com> | 2006-06-30 09:34:06 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2006-06-30 09:34:06 +0400 |
| commit | d2f08db40c90a0b0ffd8fe84cda99fbb9af0c6c9 (patch) | |
| tree | 7e4b4e52bfc758b4542fc60beb55479230782f74 /mysql-test/r/partition_pruning.result | |
| parent | f030f85860e20bfdc93df37ebedf96021d85feda (diff) | |
| download | mariadb-git-d2f08db40c90a0b0ffd8fe84cda99fbb9af0c6c9.tar.gz | |
BUG#20484: "Partitions: crash with EXPLAIN and UNION"
- Don't forget to produce "partitions" column for "UNION RESULT" row of EXPLAIN output
mysql-test/r/partition_pruning.result:
BUG#20484: Testcase
mysql-test/t/partition_pruning.test:
BUG#20484: Testcase
Diffstat (limited to 'mysql-test/r/partition_pruning.result')
| -rw-r--r-- | mysql-test/r/partition_pruning.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/partition_pruning.result b/mysql-test/r/partition_pruning.result index ee294242bf7..3b08f522129 100644 --- a/mysql-test/r/partition_pruning.result +++ b/mysql-test/r/partition_pruning.result @@ -697,3 +697,10 @@ ref NULL rows 2 Extra drop table t2; +create table t1 (s1 int); +explain partitions select 1 from t1 union all select 2; +id select_type table partitions type possible_keys key key_len ref rows Extra +1 PRIMARY t1 NULL system NULL NULL NULL NULL 0 const row not found +2 UNION NULL NULL NULL NULL NULL NULL NULL NULL No tables used +NULL UNION RESULT <union1,2> NULL ALL NULL NULL NULL NULL NULL +drop table t1; |