Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3.2
-
None
Description
Following should return empty set
CREATE TABLE t (i INT);
|
INSERT INTO t VALUES (1),(2);
|
SELECT * FROM t WHERE i != ANY ( SELECT 6 INTERSECT SELECT 3 );
|
i
|
2
|
drop table t;
|
test suite
CREATE TABLE t (i INT);
|
INSERT INTO t VALUES (1),(2);
|
SELECT * FROM t WHERE i != ANY ( SELECT 6 INTERSECT SELECT 3 );
|
drop table t;
|
Attachments
Issue Links
- relates to
-
MDEV-13723 Server crashes in ha_heap::find_unique_row or Assertion `0' failed in st_select_lex_unit::optimize with INTERSECT
- Closed