summaryrefslogtreecommitdiff
path: root/mysql-test/main/subselect.test
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.com>2018-07-31 10:09:53 +0400
committerAlexander Barkov <bar@mariadb.com>2018-07-31 10:09:53 +0400
commit2bbee0e1ecc1d71cc7ca890d70e101a69955e5d9 (patch)
tree801208afe184a4bddd6ff11197577ea16116ac93 /mysql-test/main/subselect.test
parent28ff7e89c6f68cbf0c413f828ac31b5200443bc7 (diff)
downloadmariadb-git-2bbee0e1ecc1d71cc7ca890d70e101a69955e5d9.tar.gz
MDEV-16861 Split Item::update_null_value() into a new virtual method in Type_handler
Diffstat (limited to 'mysql-test/main/subselect.test')
-rw-r--r--mysql-test/main/subselect.test20
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/subselect.test b/mysql-test/main/subselect.test
index 1623d135a9b..37d57e51f1b 100644
--- a/mysql-test/main/subselect.test
+++ b/mysql-test/main/subselect.test
@@ -6145,3 +6145,23 @@ SELECT * FROM t t1 RIGHT JOIN t t2 ON (t2.pk = t1.pk)
DROP TABLE t;
--echo # End of 10.2 tests
+
+
+--echo #
+--echo # Start of 10.4 tests
+--echo #
+
+--echo #
+--echo # MDEV-16861 Split Item::update_null_value() into a new virtual method in Type_handler
+--echo #
+
+--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
+SELECT ROW(1,2) = EXISTS (SELECT 1);
+--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
+SELECT ROW(1,2) = 1 IN (SELECT 1 UNION SELECT 2);
+--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
+SELECT ROW(1,2) = (1 = ANY (SELECT 1 UNION SELECT 2));
+
+--echo #
+--echo # End of 10.4 tests
+--echo #