diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2012-05-12 11:53:14 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2012-05-12 11:53:14 +0400 |
| commit | 97ae1682f185be05276b172919e47fd86e9fd953 (patch) | |
| tree | f80d651fb4737a652de85372a7b41b478f478c01 /mysql-test/t | |
| parent | a37768e11d3eebab700dd4bb8fd271bda003dae3 (diff) | |
| download | mariadb-git-97ae1682f185be05276b172919e47fd86e9fd953.tar.gz | |
BUG#997747: Assertion `join->best_read < ((double)1.79..5e+308L)' failed
in greedy_search with LEFT JOINs and unique keys
- Backport the fix for BUG#806524 from MariaDB 5.3
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/table_elim.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/table_elim.test b/mysql-test/t/table_elim.test index 5576362b396..f5a90efe9a3 100644 --- a/mysql-test/t/table_elim.test +++ b/mysql-test/t/table_elim.test @@ -499,3 +499,25 @@ WHERE t3.f2 ; DROP TABLE t1,t2,t3,t4,t5; +--echo # +--echo # BUG#997747: Assertion `join->best_read < ((double)1.79..5e+308L)' +--echo # failed in greedy_search with LEFT JOINs and unique keys +--echo # +CREATE TABLE t1 (a1 INT); +CREATE TABLE t2 (b1 INT); +CREATE TABLE t3 (c1 INT, UNIQUE KEY(c1)); +CREATE TABLE t4 (d1 INT, UNIQUE KEY(d1)); +CREATE TABLE t5 (e1 INT); + +INSERT INTO t1 VALUES (1),(2); +INSERT INTO t2 VALUES (2),(3); +INSERT INTO t3 VALUES (3),(4); +INSERT INTO t4 VALUES (4),(5); +INSERT INTO t5 VALUES (5),(6); + +SELECT a1 FROM t1 LEFT JOIN t2 LEFT JOIN t3 LEFT JOIN t4 +ON c1 = d1 ON d1 = b1 ON a1 = b1 +LEFT JOIN t5 ON a1 = e1 ; + +DROP TABLE t1,t2,t3,t4,t5; + |