diff options
| author | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2009-10-15 14:42:51 +0400 |
|---|---|---|
| committer | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2009-10-15 14:42:51 +0400 |
| commit | 79406bc49a7f657c387c9a9e94fcfa83502be9bb (patch) | |
| tree | bb4f7a174fc872003133990644cb90b528d572df /mysql-test | |
| parent | eade89806142877dd0676d7ed27d864dcbda133d (diff) | |
| parent | bc9f56a6c2b121e3a5de277585322068afbe1887 (diff) | |
| download | mariadb-git-79406bc49a7f657c387c9a9e94fcfa83502be9bb.tar.gz | |
Manual merge.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/range.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/range.test | 11 |
2 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index c98a7696ea6..0d44e79b39a 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -1398,3 +1398,12 @@ a < 10; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t3 range a a 5 NULL 8 Using where; Using index DROP TABLE t1, t2, t3; +# +# Bug #47123: Endless 100% CPU loop with STRAIGHT_JOIN +# +CREATE TABLE t1(a INT, KEY(a)); +INSERT INTO t1 VALUES (1), (NULL); +SELECT * FROM t1 WHERE a <> NULL and (a <> NULL or a <= NULL); +a +DROP TABLE t1; +End of 5.1 tests diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index dc119b6a77e..f0fa99f3d95 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -1171,3 +1171,14 @@ a < 5 OR a < 10; DROP TABLE t1, t2, t3; + +--echo # +--echo # Bug #47123: Endless 100% CPU loop with STRAIGHT_JOIN +--echo # + +CREATE TABLE t1(a INT, KEY(a)); +INSERT INTO t1 VALUES (1), (NULL); +SELECT * FROM t1 WHERE a <> NULL and (a <> NULL or a <= NULL); +DROP TABLE t1; + +--echo End of 5.1 tests |