mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-05-28 13:01:26 +03:00
6f69194462
InSub::handleFunc() was incorrectly exiting early for an IN subquery containing an isnull predicate in the OR operation in the WHERE clause. This patch properly handles the OR predicate containing an isnull/isnotnull predicate in the WHERE clause. We don't remove the isnull operand from the filter ParseTree in 6.x as the server no longer injects the isnull predicate in the IN subquery due to MCOL-4617, where we moved the creation and injection of in-to-exists predicate into the engine.
36 lines
1.5 KiB
Plaintext
36 lines
1.5 KiB
Plaintext
--source ../include/have_columnstore.inc
|
|
--source ctype_cmp_combinations.inc
|
|
|
|
--echo #
|
|
--echo # MCOL-4642 NOT IN subquery containing an isnull in the OR predicate crashes server
|
|
--echo #
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcol4642;
|
|
--enable_warnings
|
|
|
|
CREATE DATABASE mcol4642;
|
|
USE mcol4642;
|
|
|
|
CREATE TABLE cs1 (a int);
|
|
INSERT INTO cs1 VALUES (1), (2), (3), (4), (null);
|
|
CREATE TABLE cs2 (b int, c int);
|
|
INSERT INTO cs2 VALUES (1, 100), (1, 101), (2, 200),(3, 300), (3, 301), (3, 302), (null, null);
|
|
|
|
SELECT * FROM cs1 WHERE a NOT IN (SELECT b FROM cs2 WHERE b is not null OR b is null);
|
|
SELECT * FROM cs1 WHERE a NOT IN (SELECT b FROM cs2 WHERE b is null OR b is not null);
|
|
SELECT * FROM cs1 WHERE a IN (SELECT b FROM cs2 WHERE b is not null OR b is null);
|
|
SELECT * FROM cs1 WHERE a IN (SELECT b FROM cs2 WHERE b is null OR b is not null);
|
|
|
|
SELECT * FROM cs1 WHERE a NOT IN (SELECT b FROM cs2 WHERE b=123 OR b is null);
|
|
SELECT * FROM cs1 WHERE a NOT IN (SELECT b FROM cs2 WHERE b is null OR b=123);
|
|
SELECT * FROM cs1 WHERE a IN (SELECT b FROM cs2 WHERE b=123 OR b is null);
|
|
SELECT * FROM cs1 WHERE a IN (SELECT b FROM cs2 WHERE b is null OR b=123);
|
|
|
|
SELECT * FROM cs1 WHERE a NOT IN (SELECT b FROM cs2 WHERE b=123 OR b is not null);
|
|
SELECT * FROM cs1 WHERE a NOT IN (SELECT b FROM cs2 WHERE b is not null OR b=123);
|
|
SELECT * FROM cs1 WHERE a IN (SELECT b FROM cs2 WHERE b=123 OR b is not null);
|
|
SELECT * FROM cs1 WHERE a IN (SELECT b FROM cs2 WHERE b is not null OR b=123);
|
|
|
|
DROP DATABASE mcol4642;
|