798
CREATE TABLE t1 (a INT);
799
INSERT INTO t1 VALUES (1), (2), (11);
800
# 2nd and 3rd columns should be same
801
SELECT a, ROW(11, 12) = (SELECT a, 22), ROW(11, 12) IN (SELECT a, 22) FROM t1 GROUP BY t1.a;
802
a ROW(11, 12) = (SELECT a, 22) ROW(11, 12) IN (SELECT a, 22)
806
SELECT a, ROW(11, 12) = (SELECT a, 12), ROW(11, 12) IN (SELECT a, 12) FROM t1 GROUP BY t1.a;
807
a ROW(11, 12) = (SELECT a, 12) ROW(11, 12) IN (SELECT a, 12)
811
SELECT a, ROW(11, 12) = (SELECT a, 22), ROW(11, 12) IN (SELECT a, 22) FROM t1;
812
a ROW(11, 12) = (SELECT a, 22) ROW(11, 12) IN (SELECT a, 22)
816
SELECT a, ROW(11, 12) = (SELECT a, 12), ROW(11, 12) IN (SELECT a, 12) FROM t1;
817
a ROW(11, 12) = (SELECT a, 12) ROW(11, 12) IN (SELECT a, 12)
821
SELECT a AS x, ROW(11, 12) = (SELECT MAX(x), 22), ROW(11, 12) IN (SELECT MAX(x), 22) FROM t1;
822
x ROW(11, 12) = (SELECT MAX(x), 22) ROW(11, 12) IN (SELECT MAX(x), 22)
826
# 2nd and 3rd columns should be same for x == 11 only
827
SELECT a AS x, ROW(11, 12) = (SELECT MAX(x), 12), ROW(11, 12) IN (SELECT MAX(x), 12) FROM t1;
828
x ROW(11, 12) = (SELECT MAX(x), 12) ROW(11, 12) IN (SELECT MAX(x), 12)
833
# both columns should be same
834
SELECT ROW(1,2) = (SELECT NULL, NULL), ROW(1,2) IN (SELECT NULL, NULL);
835
ROW(1,2) = (SELECT NULL, NULL) ROW(1,2) IN (SELECT NULL, NULL)
837
SELECT ROW(1,2) = (SELECT 1, NULL), ROW(1,2) IN (SELECT 1, NULL);
838
ROW(1,2) = (SELECT 1, NULL) ROW(1,2) IN (SELECT 1, NULL)
840
SELECT ROW(1,2) = (SELECT NULL, 2), ROW(1,2) IN (SELECT NULL, 2);
841
ROW(1,2) = (SELECT NULL, 2) ROW(1,2) IN (SELECT NULL, 2)
843
SELECT ROW(1,2) = (SELECT NULL, 1), ROW(1,2) IN (SELECT NULL, 1);
844
ROW(1,2) = (SELECT NULL, 1) ROW(1,2) IN (SELECT NULL, 1)
846
SELECT ROW(1,2) = (SELECT 1, 1), ROW(1,2) IN (SELECT 1, 1);
847
ROW(1,2) = (SELECT 1, 1) ROW(1,2) IN (SELECT 1, 1)
849
SELECT ROW(1,2) = (SELECT 1, 2), ROW(1,2) IN (SELECT 1, 2);
850
ROW(1,2) = (SELECT 1, 2) ROW(1,2) IN (SELECT 1, 2)
799
853
create table t0 (a int);
800
854
insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);