diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-10-30 02:37:10 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-10-30 02:37:10 -0700 |
| commit | 4cf3cb7240d5d176ff0a87c273a0a8130c85f154 (patch) | |
| tree | 5703367d0ab4ed151d7a97ff7066bdba04175e6c /mysql-test/r/innodb_icp.result | |
| parent | 7bc6a83b027aeddbe1d84ceb6647928d5cfb3bca (diff) | |
| download | mariadb-git-4cf3cb7240d5d176ff0a87c273a0a8130c85f154.tar.gz | |
Backported the test case for bug 58837. The fix was backported earlier.
Diffstat (limited to 'mysql-test/r/innodb_icp.result')
| -rw-r--r-- | mysql-test/r/innodb_icp.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_icp.result b/mysql-test/r/innodb_icp.result index 8293b3fbf83..aacb129b5de 100644 --- a/mysql-test/r/innodb_icp.result +++ b/mysql-test/r/innodb_icp.result @@ -462,6 +462,29 @@ pk c1 DROP TABLE t1; set optimizer_switch= @save_optimizer_switch; # +# Bug#58837: ICP crash or valgrind error due to uninitialized +# value in innobase_index_cond +# +CREATE TABLE t1 ( +t1_int INT, +t1_time TIME +); +CREATE TABLE t2 ( +t2_int int PRIMARY KEY, +t2_int2 INT +); +INSERT INTO t2 VALUES (); +INSERT INTO t1 VALUES (); +SELECT * FROM t1 AS t1a +WHERE NOT EXISTS (SELECT * FROM t1 AS t1b +WHERE t1b.t1_int NOT IN +(SELECT t2.t2_int FROM t2 +WHERE t1b.t1_time LIKE t1b.t1_int +OR t1b.t1_time <> t2.t2_int2 +AND 6=7)); +t1_int t1_time +DROP TABLE t1,t2; +# # BUG#778434 Wrong result with in_to_exists=on in maria-5.3-mwl89 # CREATE TABLE t1 ( f11 int) ; |