merge

1 files changed, 8 insertions, 0 deletions

diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test
index b76f5140e78..e78874453b9 100644
--- a/mysql-test/t/subselect.test
+++ b/mysql-test/t/subselect.test
@@ -1328,3 +1328,11 @@ insert into t1 values(1),(2),(3);
 insert into t2 values (1,'test'), (2,'mysql'), (3,'test'), (4,'test');
 select count(distinct id) from t1 where id in (select id from t2 where match(body) against ('mysql' in boolean mode));
 drop table t2,t1;
+
+#
+# Equal operation under row and empty subquery
+#
+create table t1 (s1 int,s2 int);
+insert into t1 values (20,15);
+select * from t1 where  (('a',null) <=> (select 'a',s2 from t1 where s1 = 0));
+drop table t1;