diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2016-02-18 17:20:48 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2016-02-21 22:16:17 +0100 |
| commit | 4b08b10b3ace67481cb7c03e0d3e95aaf6e954f7 (patch) | |
| tree | f83ac80eae1b5e5d7e7cfa80d13aebf3de26f54a /mysql-test/t/subselect_mat.test | |
| parent | fd8e846a3b049903706267d58e6d8e61eea97df8 (diff) | |
| download | mariadb-git-4b08b10b3ace67481cb7c03e0d3e95aaf6e954f7.tar.gz | |
MDEV-9489:Assertion `0' failed in Protocol::end_statement() on UNION ALL
Restoring currect_select fixed.
Diffstat (limited to 'mysql-test/t/subselect_mat.test')
| -rw-r--r-- | mysql-test/t/subselect_mat.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_mat.test b/mysql-test/t/subselect_mat.test index 09c6b3e1747..9c7c9683d0b 100644 --- a/mysql-test/t/subselect_mat.test +++ b/mysql-test/t/subselect_mat.test @@ -254,3 +254,19 @@ SELECT a, b, (a, b) NOT IN (SELECT a, b FROM t2) as sq FROM t1; drop table t1, t2; + +--echo # +--echo # MDEV-9489: Assertion `0' failed in Protocol::end_statement() on +--echo # UNION ALL +--echo # + +CREATE TABLE t1 (f1 INT); +CREATE TABLE t2 (f2 INT); +INSERT INTO t1 VALUES (1),(2); + +( SELECT 1 FROM t1 WHERE f1 NOT IN ( SELECT f2 FROM t2 ) LIMIT 0 ) +UNION ALL +( SELECT 1 FROM t1 WHERE f1 NOT IN ( SELECT f2 FROM t2 ) ) +; + +drop table t1, t2; |