merge

2 files changed, 13 insertions, 0 deletions

diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result
index 99827238540..98adbc19eeb 100644
--- a/mysql-test/r/subselect.result
+++ b/mysql-test/r/subselect.result
@@ -2026,3 +2026,8 @@ select count(distinct id) from t1 where id in (select id from t2 where match(bod
 count(distinct id)
 1
 drop table t2,t1;
+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));
+s1	s2
+drop table t1;
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;