diff options
| author | Igor Babaev <igor@askmonty.org> | 2014-10-17 14:06:54 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2014-10-17 14:06:54 -0700 |
| commit | ec89abfef4d0ceef06e4037e8fa1a3cdad7ca18d (patch) | |
| tree | 6c917245aab4070607e0bca9f48f8ab07b7c0d3e /mysql-test/t/union.test | |
| parent | aa0fd5ca53b381094c03fce4808032c98d0fe0f4 (diff) | |
| parent | a4d1783aaeea6a3e4a46084fde161ff7152fd2da (diff) | |
| download | mariadb-git-ec89abfef4d0ceef06e4037e8fa1a3cdad7ca18d.tar.gz | |
Merge branch '10.1' of ../10.1-mdev334 into 10.1
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index 8d10c3d64ea..929eb3f9534 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -1417,3 +1417,15 @@ DROP TABLE t1, t2; --echo # End of WL1763 tests +--echo # +--echo # Bug mdev-6874: crash with UNION ALL in a subquery +--echo # + +CREATE TABLE t1 (a int, b int); +INSERT INTO t1 VALUES (1,1), (2,8); + +SELECT * FROM t1 t1_1 LEFT JOIN t1 t1_2 ON ( t1_2.b = t1_1.a ) + WHERE t1_2.b NOT IN ( SELECT 4 UNION ALL SELECT 5 ); + +DROP TABLE t1; + |