diff options
| author | Martin Hansson <martin.hansson@sun.com> | 2010-05-06 10:59:28 +0200 |
|---|---|---|
| committer | Martin Hansson <martin.hansson@sun.com> | 2010-05-06 10:59:28 +0200 |
| commit | 0c82d3f3f4692748f17461174eb16781f17a66d4 (patch) | |
| tree | ea7097a66192ed94e270cccc95bf8fa355522fe0 /mysql-test/t/join_outer.test | |
| parent | addd0a3e67164037149140b71c027272ecbaee49 (diff) | |
| parent | 1eada91053287af3d46da93b88d5feb30ed4ba27 (diff) | |
| download | mariadb-git-0c82d3f3f4692748f17461174eb16781f17a66d4.tar.gz | |
Merge of fix for Bug#52357
Diffstat (limited to 'mysql-test/t/join_outer.test')
| -rw-r--r-- | mysql-test/t/join_outer.test | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index e3d68d71603..aaea8b3120b 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -913,4 +913,27 @@ WHERE (COALESCE(t1.f1, t2.f1), f3) IN ((1, 3), (2, 2)); DROP TABLE t1, t2; +--echo # +--echo # Bug#52357: Assertion failed: join->best_read in greedy_search +--echo # optimizer_search_depth=0 +--echo # +CREATE TABLE t1( a INT ); + +INSERT INTO t1 VALUES (1),(2); +SET optimizer_search_depth = 0; + +--echo # Should not core dump on query preparation +EXPLAIN +SELECT 1 +FROM t1 tt3 LEFT OUTER JOIN t1 tt4 ON 1 + LEFT OUTER JOIN t1 tt5 ON 1 + LEFT OUTER JOIN t1 tt6 ON 1 + LEFT OUTER JOIN t1 tt7 ON 1 + LEFT OUTER JOIN t1 tt8 ON 1 + RIGHT OUTER JOIN t1 tt2 ON 1 + RIGHT OUTER JOIN t1 tt1 ON 1 + STRAIGHT_JOIN t1 tt9 ON 1; + +SET optimizer_search_depth = DEFAULT; +DROP TABLE t1; --echo End of 5.1 tests |