diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-11-10 11:22:51 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-11-10 11:22:51 +0100 |
| commit | 78a31db6b322ec0e63601ed471feaedc0ad2987c (patch) | |
| tree | 471b5e5211d8a895071dd9f130d3df477c242496 /mysql-test/t/except.test | |
| parent | 06a9a366a3df18b02a97fce8e585229f0c01bd09 (diff) | |
| download | mariadb-git-bb-10.3-MDEV-13723.tar.gz | |
MDEV-13723: Server crashes in ha_heap::find_unique_row or Assertion `0' failed in st_select_lex_unit::optimize with INTERSECTbb-10.3-MDEV-13723
With INTERSECT/EXCEPT fakt that subquery item of IN/ALL/ANY was not assigned value does not mean that temporary table used for calculating unit is empty (records could be deleted).
Diffstat (limited to 'mysql-test/t/except.test')
| -rw-r--r-- | mysql-test/t/except.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/except.test b/mysql-test/t/except.test index e13137701a9..f88d9b29e35 100644 --- a/mysql-test/t/except.test +++ b/mysql-test/t/except.test @@ -81,3 +81,17 @@ create table t3 (select a,b,b1 from t1) except (select c,d,d1 from t2); show create table t3; drop tables t1,t2,t3; + +--echo # +--echo # MDEV-13723: Server crashes in ha_heap::find_unique_row or +--echo # Assertion `0' failed in st_select_lex_unit::optimize with INTERSECT +--echo # +CREATE TABLE t (i INT); +INSERT INTO t VALUES (1),(2); + +SELECT * FROM t WHERE i != ANY ( SELECT 3 EXCEPT SELECT 3 ); + +drop table t; + + +--echo # End of 10.3 tests |