diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-10-30 03:34:26 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-10-30 03:34:26 -0700 |
| commit | c118219f38e9685fe1145bc7050f6e07d620ac01 (patch) | |
| tree | 5c2cc51c0699802befba85aef51b0e6185b75823 /mysql-test/include/icp_tests.inc | |
| parent | 4cf3cb7240d5d176ff0a87c273a0a8130c85f154 (diff) | |
| download | mariadb-git-c118219f38e9685fe1145bc7050f6e07d620ac01.tar.gz | |
Backported the test case for bug 59186 from mysql-5.6 code line.
The bug was fixed by the patch for LP bug 694092 that was
applied earlier to the mariadb-5.3 code.
Diffstat (limited to 'mysql-test/include/icp_tests.inc')
| -rw-r--r-- | mysql-test/include/icp_tests.inc | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/include/icp_tests.inc b/mysql-test/include/icp_tests.inc index e6c949a0ab2..8faff204078 100644 --- a/mysql-test/include/icp_tests.inc +++ b/mysql-test/include/icp_tests.inc @@ -522,6 +522,35 @@ SELECT * FROM t1 AS t1a DROP TABLE t1,t2; +--echo # +--echo # Bug#59186: Wrong results of join when ICP is enabled +--echo # (fixed by the patch for LP bug #694092) +--echo # + +CREATE TABLE t1 ( + pk INTEGER NOT NULL, + c1 VARCHAR(3) NOT NULL, + PRIMARY KEY (pk) +); +INSERT INTO t1 VALUES (1,'y'),(0,'or'); + +CREATE TABLE t2 ( + pk INTEGER NOT NULL, + c1 VARCHAR(3) NOT NULL, + c2 VARCHAR(6) NOT NULL, + PRIMARY KEY (pk) +); +INSERT INTO t2 VALUES (6,'y','RPOYT'),(10,'m','JINQE'); + +EXPLAIN +SELECT c2 FROM t1 JOIN t2 ON t1.c1 = t2.c1 +WHERE (t2.pk <= 4 AND t1.pk IN (2,1)) OR + (t1.pk > 1 AND t2.pk BETWEEN 6 AND 6); +SELECT c2 FROM t1 JOIN t2 ON t1.c1 = t2.c1 +WHERE (t2.pk <= 4 AND t1.pk IN (2,1)) OR + (t1.pk > 1 AND t2.pk BETWEEN 6 AND 6); + +DROP TABLE t1, t2; --echo # --echo # BUG#778434 Wrong result with in_to_exists=on in maria-5.3-mwl89 |