diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-03-26 11:44:24 +0400 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-03-26 11:44:24 +0400 |
| commit | f57839cd6060ff2d8edb4bf0875b67d0176d88e4 (patch) | |
| tree | c5a754b2062abebbea62dea7e12133cdfcc41d7c /mysql-test/r/join.result | |
| parent | bccf219bfc61bb45d334b40d732651eb9bef5075 (diff) | |
| download | mariadb-git-f57839cd6060ff2d8edb4bf0875b67d0176d88e4.tar.gz | |
Bug#52177 crash with explain, row comparison, join, text field
The crash is the result of an attempt made by JOIN::optimize to evaluate
the WHERE condition when no records have been actually read.
The fix is to remove erroneous 'outer_join' variable check.
mysql-test/r/join.result:
test result
mysql-test/t/join.test:
test case
sql/sql_select.cc:
removed erroneous 'outer_join' variable check.
Diffstat (limited to 'mysql-test/r/join.result')
| -rw-r--r-- | mysql-test/r/join.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/join.result b/mysql-test/r/join.result index bacfa81160a..2585bf7a26e 100644 --- a/mysql-test/r/join.result +++ b/mysql-test/r/join.result @@ -930,4 +930,16 @@ Warnings: Note 1003 select 1 AS `1` from `test`.`t1` left join `test`.`t1` `t2` on((1 = 1)) left join (`test`.`t1` left join `test`.`t1` `t2` on((1 = 1))) on(rand()) where 1 DROP VIEW v1; DROP TABLE t1; +# +# Bug#52177 crash with explain, row comparison, join, text field +# +CREATE TABLE t1 (a TINYINT, b TEXT, KEY (a)); +INSERT INTO t1 VALUES (0,''),(0,''); +FLUSH TABLES; +EXPLAIN SELECT 1 FROM t1 LEFT JOIN t1 a ON 1 +WHERE ROW(t1.a, 1111.11) = ROW(1111.11, 1111.11) AND +ROW(t1.b, 1111.11) <=> ROW('',''); +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +DROP TABLE t1; End of 5.0 tests. |