diff options
| author | igor@rurik.mysql.com <> | 2006-09-06 08:21:43 -0700 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2006-09-06 08:21:43 -0700 |
| commit | b7ded1e34fe28d76a26b0372867b15393c5c725c (patch) | |
| tree | ef9797f03cfe4a0614da783fc7572b33e0363eb3 /mysql-test/r/olap.result | |
| parent | ca3229dc1b3c8046ed613d782e7525f146ef9c04 (diff) | |
| download | mariadb-git-b7ded1e34fe28d76a26b0372867b15393c5c725c.tar.gz | |
Fixed bug #5500: EXPLAIN returned a wrong select_type for queries using views.
Select_type in the EXPLAIN output for the query SELECT * FROM t1 was
'SIMPLE', while for the query SELECT * FROM v1, where the view v1
was defined as SELECT * FROM t1, the EXPLAIN output contained 'PRIMARY'
for the select_type column.
Diffstat (limited to 'mysql-test/r/olap.result')
| -rw-r--r-- | mysql-test/r/olap.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/olap.result b/mysql-test/r/olap.result index 28c1dc59540..7cdd5e1b152 100644 --- a/mysql-test/r/olap.result +++ b/mysql-test/r/olap.result @@ -611,7 +611,7 @@ C NULL EXPLAIN SELECT type FROM v1 GROUP BY type WITH ROLLUP; id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 10 Using filesort +1 SIMPLE t1 ALL NULL NULL NULL NULL 10 Using filesort DROP VIEW v1; DROP TABLE t1; CREATE TABLE t1 (a int(11) NOT NULL); |