This is an automated email from the ASF dual-hosted git repository.
jhyde pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/calcite.git
The following commit(s) were added to refs/heads/main by this push:
new 0dcf3ab418 Bump Quidem from 0.10 to 0.11
0dcf3ab418 is described below
commit 0dcf3ab4185647243255af29f0128b52737c1bf2
Author: Julian Hyde <[email protected]>
AuthorDate: Fri Feb 10 15:19:01 2023 -0800
Bump Quidem from 0.10 to 0.11
---
babel/src/test/resources/sql/big-query.iq | 2 --
babel/src/test/resources/sql/select.iq | 1 -
core/src/test/resources/sql/agg.iq | 16 -------------
core/src/test/resources/sql/conditions.iq | 19 ----------------
core/src/test/resources/sql/functions.iq | 1 -
core/src/test/resources/sql/match.iq | 4 ----
core/src/test/resources/sql/misc.iq | 4 ----
core/src/test/resources/sql/pivot.iq | 4 ----
core/src/test/resources/sql/set-op.iq | 4 ----
core/src/test/resources/sql/some.iq | 38 -------------------------------
core/src/test/resources/sql/spatial.iq | 4 ----
core/src/test/resources/sql/sub-query.iq | 36 -----------------------------
core/src/test/resources/sql/winagg.iq | 7 ------
gradle.properties | 2 +-
plus/src/test/resources/sql/basic.iq | 1 -
15 files changed, 1 insertion(+), 142 deletions(-)
diff --git a/babel/src/test/resources/sql/big-query.iq
b/babel/src/test/resources/sql/big-query.iq
index 9172488d33..c31141d2db 100755
--- a/babel/src/test/resources/sql/big-query.iq
+++ b/babel/src/test/resources/sql/big-query.iq
@@ -827,7 +827,6 @@ select datetime(timestamp "2008-01-01 01:03:05") as
t_winter,
SELECT
TIME(15, 30, 00) as time_hms,
TIME(TIMESTAMP "2008-12-25 07:30:00" /* TODO should be "2008-12-25
15:30:00+08" */, "America/Los_Angeles") as time_tstz;
-
+----------+-----------+
| time_hms | time_tstz |
+----------+-----------+
@@ -838,7 +837,6 @@ SELECT
!ok
SELECT TIME(DATETIME "2008-12-25 15:30:00.000000") AS time_dt;
-
+----------+
| time_dt |
+----------+
diff --git a/babel/src/test/resources/sql/select.iq
b/babel/src/test/resources/sql/select.iq
index 1b6f40bdce..e82f21d7d4 100755
--- a/babel/src/test/resources/sql/select.iq
+++ b/babel/src/test/resources/sql/select.iq
@@ -63,7 +63,6 @@ select(...)
# [CALCITE-5410] Assertion error on PERCENT_REMAINDER operator with DECIMAL
type
select 1.0 % 2;
-
+--------+
| EXPR$0 |
+--------+
diff --git a/core/src/test/resources/sql/agg.iq
b/core/src/test/resources/sql/agg.iq
index 150025bb89..1210727959 100644
--- a/core/src/test/resources/sql/agg.iq
+++ b/core/src/test/resources/sql/agg.iq
@@ -983,7 +983,6 @@ group by rollup(1);
select deptno, group_id() as g, count(*) as c
from "scott".emp
group by grouping sets (deptno, (), ());
-
+--------+---+----+
| DEPTNO | G | C |
+--------+---+----+
@@ -1014,7 +1013,6 @@ select deptno
order by deptno
, job
, empno;
-
+--------+-----------+-------+--------+----------+-----------------------------------+
| DEPTNO | JOB | EMPNO | ENAME | SUMSAL | GR_TEXT
|
+--------+-----------+-------+--------+----------+-----------------------------------+
@@ -1074,7 +1072,6 @@ select deptno
order by deptno
, job
, empno;
-
+--------+-----------+-------+--------+----------+-----------------------------------+
| DEPTNO | JOB | EMPNO | ENAME | SUMSAL | GR_TEXT
|
+--------+-----------+-------+--------+----------+-----------------------------------+
@@ -2151,7 +2148,6 @@ from
) sq(x,y,z)
group by z
order by sum_cnt;
-
+---------+----------+
| SUM_CNT | CNT_DIST |
+---------+----------+
@@ -2818,7 +2814,6 @@ group by MONTH(HIREDATE);
select deptno, collect(empno) within group (order by empno asc) as empnos
from "scott".emp
group by deptno;
-
+--------+--------------------------------------+
| DEPTNO | EMPNOS |
+--------+--------------------------------------+
@@ -2836,7 +2831,6 @@ EnumerableAggregate(group=[{7}], EMPNOS=[COLLECT($0)
WITHIN GROUP ([0])])
select deptno, collect(empno) within group (order by empno desc) as empnos
from "scott".emp
group by deptno;
-
+--------+--------------------------------------+
| DEPTNO | EMPNOS |
+--------+--------------------------------------+
@@ -2857,7 +2851,6 @@ collect(empno) as empnos_1,
collect(empno) within group (order by empno desc) as empnos_2
from "scott".emp
group by deptno;
-
+--------+--------------------------------------+--------------------------------------+
| DEPTNO | EMPNOS_1 | EMPNOS_2
|
+--------+--------------------------------------+--------------------------------------+
@@ -2876,7 +2869,6 @@ select deptno, collect(empno) within group (order by
empno desc)
filter (where empno > 7500) as empnos
from "scott".emp
group by deptno;
-
+--------+--------------------------------+
| DEPTNO | EMPNOS |
+--------+--------------------------------+
@@ -2896,7 +2888,6 @@ select deptno, collect(empno) within group (order by
empno desc) as empnos1,
collect(empno) within group (order by empno asc) as empnos2
from "scott".emp
group by deptno;
-
+--------+--------------------------------------+--------------------------------------+
| DEPTNO | EMPNOS1 | EMPNOS2
|
+--------+--------------------------------------+--------------------------------------+
@@ -2919,7 +2910,6 @@ select dept.deptno,
from "scott".emp
join "scott".dept using (deptno)
group by dept.deptno;
-
+--------+-------------------------------------------------------+-------------------------------------------------------+-----------------------------+
| DEPTNO | S | S1
| S2 |
+--------+-------------------------------------------------------+-------------------------------------------------------+-----------------------------+
@@ -2942,7 +2932,6 @@ EnumerableAggregate(group=[{0}], S=[COLLECT($1) WITHIN
GROUP ([1 DESC])], S1=[CO
select deptno, collect(empno + 1) within group (order by 1) as empnos
from "scott".emp
group by deptno;
-
+--------+--------------------------------------+
| DEPTNO | EMPNOS |
+--------+--------------------------------------+
@@ -2960,7 +2949,6 @@ EnumerableAggregate(group=[{0}], EMPNOS=[COLLECT($1)
WITHIN GROUP ([2])])
# BIT_AND, BIT_OR, BIT_XOR aggregate functions
select bit_and(deptno), bit_or(deptno), bit_xor(deptno) from "scott".emp;
-
+--------+--------+--------+
| EXPR$0 | EXPR$1 | EXPR$2 |
+--------+--------+--------+
@@ -2971,7 +2959,6 @@ select bit_and(deptno), bit_or(deptno), bit_xor(deptno)
from "scott".emp;
!ok
select deptno, bit_and(empno), bit_or(empno), bit_xor(empno) from "scott".emp
group by deptno;
-
+--------+--------+--------+--------+
| DEPTNO | EXPR$1 | EXPR$2 | EXPR$3 |
+--------+--------+--------+--------+
@@ -3474,7 +3461,6 @@ select
from emp
group by
case when deptno in (1, 2, 3, 4, 5) THEN 1 else 0 end;
-
+--------+
| EXPR$0 |
+--------+
@@ -3490,7 +3476,6 @@ select
from emp
group by
case when deptno in (1, 2, 3, 4, 5) THEN 1 else 0 end;
-
+--------+
| EXPR$0 |
+--------+
@@ -3510,7 +3495,6 @@ from
CTE1,CTE2
where
CTE1.val1 = CTE2.val2;
-
+--------+------+--------+------+
| ROWNR1 | VAL1 | ROWNR2 | VAL2 |
+--------+------+--------+------+
diff --git a/core/src/test/resources/sql/conditions.iq
b/core/src/test/resources/sql/conditions.iq
index 96a6bf4ebe..1ef97e206a 100644
--- a/core/src/test/resources/sql/conditions.iq
+++ b/core/src/test/resources/sql/conditions.iq
@@ -28,7 +28,6 @@ select *
from tmp
where a = 1 or b = 1
order by 1, 2;
-
+---+---+
| A | B |
+---+---+
@@ -50,7 +49,6 @@ select *
from tmp
where not (a = 1 or b = 1)
order by 1, 2;
-
+---+---+
| A | B |
+---+---+
@@ -70,7 +68,6 @@ select *
from tmp
where a = 1 AND b = 1
order by 1, 2;
-
+---+---+
| A | B |
+---+---+
@@ -88,7 +85,6 @@ select *
from tmp
where not (a = 1 AND b = 1)
order by 1, 2;
-
+---+---+
| A | B |
+---+---+
@@ -105,7 +101,6 @@ select *
# Test cases for CALCITE-980
select "value" from "nullables" a where "value" = 'A' or "value" = 'B' order
by 1;
-
+-------+
| value |
+-------+
@@ -117,7 +112,6 @@ select "value" from "nullables" a where "value" = 'A' or
"value" = 'B' order by
!ok
select "value" from "nullables" a where not ("value" = 'A' or "value" = 'B')
order by 1;
-
+-------+
| value |
+-------+
@@ -128,7 +122,6 @@ select "value" from "nullables" a where not ("value" = 'A'
or "value" = 'B') ord
!ok
select "value" from "nullables" a where not (not ("value" = 'A' or "value" =
'B')) order by 1;
-
+-------+
| value |
+-------+
@@ -140,7 +133,6 @@ select "value" from "nullables" a where not (not ("value" =
'A' or "value" = 'B'
!ok
select "value" from "nullables" a where "value" = 'A' and "value" = 'B' order
by 1;
-
+-------+
| value |
+-------+
@@ -150,7 +142,6 @@ select "value" from "nullables" a where "value" = 'A' and
"value" = 'B' order by
!ok
select "value" from "nullables" a where not ("value" = 'A' and "value" = 'B')
order by 1;
-
+-------+
| value |
+-------+
@@ -163,7 +154,6 @@ select "value" from "nullables" a where not ("value" = 'A'
and "value" = 'B') or
!ok
select "value" from "nullables" a where not (not ("value" = 'A' and "value" =
'B')) order by 1;
-
+-------+
| value |
+-------+
@@ -175,7 +165,6 @@ select "value" from "nullables" a where not (not ("value" =
'A' and "value" = 'B
select "value" from "nullables" a
where case when not ("value" = 'A' or "value" = 'B') then 1 else 0 end = 1
order by 1;
-
+-------+
| value |
+-------+
@@ -193,7 +182,6 @@ select "value" from "nullables" a
else 0
end = 2
order by 1;
-
+-------+
| value |
+-------+
@@ -211,7 +199,6 @@ select "value" from "nullables" a
else 0
end = 1 /* <- diff from above*/
order by 1;
-
+-------+
| value |
+-------+
@@ -229,7 +216,6 @@ select "value" from "nullables" a
else 0
end = 0 /* <- diff from above*/
order by 1;
-
+-------+
| value |
+-------+
@@ -249,7 +235,6 @@ select "value" from "nullables" a
else 0
end = 2 /* <- diff from above*/
order by 1;
-
+-------+
| value |
+-------+
@@ -273,7 +258,6 @@ from ax where ((s,t) in (('a','a'),(null, 'bb'))) is null;
with ax(s) as (values (1),(0))
select case when s=0 then false else 100/s > 0 end from ax;
-
+--------+
| EXPR$0 |
+--------+
@@ -287,7 +271,6 @@ select case when s=0 then false else 100/s > 0 end from ax;
# Test case for CALCITE-2783
with ax(s) as (values (true),(false),(cast(null as boolean)))
select s, (s or s is null), (s and s is not null) from ax;
-
+-------+--------+--------+
| S | EXPR$1 | EXPR$2 |
+-------+--------+--------+
@@ -422,7 +405,6 @@ EnumerableCalc(expr#0..2=[{inputs}], EMPNO=[$t0])
select r.empno, s.deptno
from emp as r
left join dept as s on (select count(true) > 0 from emp) and s.deptno
= r.deptno;
-
+-------+--------+
| EMPNO | DEPTNO |
+-------+--------+
@@ -449,7 +431,6 @@ from emp as r
select r.empno, s.deptno
from emp as r
left join dept as s on (select count(job) > 0 from bonus);
-
+-------+--------+
| EMPNO | DEPTNO |
+-------+--------+
diff --git a/core/src/test/resources/sql/functions.iq
b/core/src/test/resources/sql/functions.iq
index 9b9ab67089..a232f838ef 100644
--- a/core/src/test/resources/sql/functions.iq
+++ b/core/src/test/resources/sql/functions.iq
@@ -207,7 +207,6 @@ select nvl("name", 'undefined') FROM "hr"."emps";
EnumerableCalc(expr#0..4=[{inputs}], expr#5=[IS NOT NULL($t2)],
expr#6=[CAST($t2):VARCHAR], expr#7=['undefined':VARCHAR], expr#8=[CASE($t5,
$t6, $t7)], EXPR$0=[$t8])
EnumerableTableScan(table=[[hr, emps]])
!plan
-
+-----------+
| EXPR$0 |
+-----------+
diff --git a/core/src/test/resources/sql/match.iq
b/core/src/test/resources/sql/match.iq
index 3df375310e..887c781c15 100755
--- a/core/src/test/resources/sql/match.iq
+++ b/core/src/test/resources/sql/match.iq
@@ -102,7 +102,6 @@ from "hr"."emps" match_recognize (
"empid" as empid
pattern (s up)
define up as up."commission" < prev(up."commission"));
-
C EMPID
---- -----
1000 100
@@ -119,7 +118,6 @@ from "hr"."emps" match_recognize (
CLASSIFIER() as cl
pattern (s up)
define up as up."commission" < prev(up."commission"));
-
C EMPID CL
---- ----- --
1000 100 S
@@ -135,7 +133,6 @@ from "hr"."emps" match_recognize (
LAST("empid") as empid
pattern (s up)
define up as up."commission" < prev(up."commission"));
-
C EMPID
---- -----
1000 100
@@ -152,7 +149,6 @@ from "hr"."emps" match_recognize (
LAST(S."empid") as empid
pattern (s up)
define up as up."commission" < prev(up."commission"));
-
C CL EMPID
---- -- -----
1000 S 100
diff --git a/core/src/test/resources/sql/misc.iq
b/core/src/test/resources/sql/misc.iq
index 38e0069370..d7fa85e73c 100644
--- a/core/src/test/resources/sql/misc.iq
+++ b/core/src/test/resources/sql/misc.iq
@@ -177,7 +177,6 @@ with data(c_row, c_timestamp) as (select * from (values
(22, TIMESTAMP '1996-02-29 17:32:01'),
(23, TIMESTAMP '1996-03-01 17:32:01')))
select cast(c_timestamp as varchar(20)), cast(c_timestamp as date) from data
where c_row <> 12;
-
+---------------------+------------+
| EXPR$0 | EXPR$1 |
+---------------------+------------+
@@ -479,7 +478,6 @@ where not exists (
select 1 from "hr"."depts" where "depts"."deptno" = "emps"."deptno")
or not exists (
select 1 from "hr"."depts" where "depts"."deptno" + 90 = "emps"."empid");
-
+-------+--------+-----------+---------+------------+
| empid | deptno | name | salary | commission |
+-------+--------+-----------+---------+------------+
@@ -1262,7 +1260,6 @@ select * from "scott".emp where empno between '7500' and
'07600';
# BETWEEN follows the PostgreSQL style to coerce STRING operand to type of the
other
# NUMERIC operands, see TypeCoercionImpl#commonTypeForBinaryComparison.
select * from "scott".emp where deptno between '7369' and '7876';
-
Caused by: java.lang.NumberFormatException: Value out of range. Value:"7369"
Radix:10
!error
@@ -2307,7 +2304,6 @@ with data(c_date, c_timestamp) as (select * from (values
(DATE'2019-06-28', TIMESTAMP '2019-06-28 17:32:01'),
(DATE'2019-12-12', TIMESTAMP '2019-12-12 12:12:01')))
select last_day(c_date), last_day(c_timestamp) from data;
-
EXPR$0, EXPR$1
1965-01-31, 1965-01-31
2019-01-31, 2019-01-31
diff --git a/core/src/test/resources/sql/pivot.iq
b/core/src/test/resources/sql/pivot.iq
index 6d2b88e695..ac576f88af 100755
--- a/core/src/test/resources/sql/pivot.iq
+++ b/core/src/test/resources/sql/pivot.iq
@@ -394,7 +394,6 @@ UNPIVOT (
IN ((c10_ss, c10_c) AS ('CLERK', 10),
(c20_ss, c20_c) AS ('CLERK', 20),
(a20_ss, a20_c) AS ('ANALYST', 20)));
-
+--------+---------+--------+---------+------------+
| GENDER | JOB | DEPTNO | SUM_SAL | COUNT_STAR |
+--------+---------+--------+---------+------------+
@@ -501,7 +500,6 @@ UNPIVOT INCLUDE NULLS (
(c20_ss) AS ('CLERK', 20),
(c20_ss) AS ('CLERK', 20),
(c10_ss) AS ('ANALYST', 20)));
-
+--------+-------+-------+---------+-------+---------+--------+---------+
| GENDER | C10_C | C20_C | A20_SS | A20_C | JOB | DEPTNO | SUM_SAL |
+--------+-------+-------+---------+-------+---------+--------+---------+
@@ -538,7 +536,6 @@ UNPIVOT (
(c20_ss) AS ('CLERK', 20),
(c20_ss) AS ('CLERK', 20),
(c10_ss) AS ('ANALYST', 20)));
-
+--------+-------+-------+---------+-------+---------+--------+---------+
| GENDER | C10_C | C20_C | A20_SS | A20_C | JOB | DEPTNO | SUM_SAL |
+--------+-------+-------+---------+-------+---------+--------+---------+
@@ -709,7 +706,6 @@ UNPIVOT ((m0, m1, m2)
FOR (a0, a1)
IN ((c1, c2, c3) as ('col1','col2'),
(c2, c3, c4)));
-
+----+----------+----------+----+----+----+
| C0 | A0 | A1 | M0 | M1 | M2 |
+----+----------+----------+----+----+----+
diff --git a/core/src/test/resources/sql/set-op.iq
b/core/src/test/resources/sql/set-op.iq
index 019d09bf5d..c5e277fe9d 100644
--- a/core/src/test/resources/sql/set-op.iq
+++ b/core/src/test/resources/sql/set-op.iq
@@ -54,7 +54,6 @@ select * from
intersect all
(select x, y from (values (cast(NULL as int), cast(NULL as varchar(1))),
(cast(NULL as int), cast(NULL as varchar(1)))) as t2(x, y));
-
+---+---+
| X | Y |
+---+---+
@@ -72,7 +71,6 @@ select * from
intersect
(select x, y from (values (cast(NULL as int), cast(NULL as varchar(1))),
(cast(NULL as int), cast(NULL as varchar(1)))) as t2(x, y));
-
+---+---+
| X | Y |
+---+---+
@@ -195,7 +193,6 @@ select * from
except all
(select x, y from (values (cast(NULL as int), cast(NULL as varchar(1))),
(cast(NULL as int), cast(NULL as varchar(1)))) as t2(x, y));
-
+---+---+
| X | Y |
+---+---+
@@ -212,7 +209,6 @@ select * from
except
(select x, y from (values (cast(NULL as int), cast(NULL as varchar(1))),
(cast(NULL as int), cast(NULL as varchar(1)))) as t2(x, y));
-
+---+---+
| X | Y |
+---+---+
diff --git a/core/src/test/resources/sql/some.iq
b/core/src/test/resources/sql/some.iq
index e0f14bb43d..17a5e83408 100644
--- a/core/src/test/resources/sql/some.iq
+++ b/core/src/test/resources/sql/some.iq
@@ -47,7 +47,6 @@ where empno = any (select empno from "scott".emp);
# Both sides NOT NULL
select * from "scott".emp
where empno > any (select deptno from "scott".dept);
-
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
@@ -73,7 +72,6 @@ where empno > any (select deptno from "scott".dept);
# ANY; left side NOT NULL, right side nullable.
select * from "scott".emp
where sal > any (select comm from "scott".emp);
-
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
@@ -99,7 +97,6 @@ where sal > any (select comm from "scott".emp);
# ALL; left side NOT NULL, right side nullable.
select * from "scott".emp
where sal > all (select comm from "scott".emp);
-
+-------+-------+-----+-----+----------+-----+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----+-----+----------+-----+------+--------+
@@ -111,7 +108,6 @@ where sal > all (select comm from "scott".emp);
# Previous, as scalar sub-query
select *, sal > all (select comm from "scott".emp) as x
from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
@@ -143,7 +139,6 @@ EnumerableCalc(expr#0..10=[{inputs}], expr#11=[0],
expr#12=[=($t9, $t11)], expr#
# NOT SOME; left side NOT NULL, right side nullable; converse of previous
query.
select * from "scott".emp
where not sal <= some (select comm from "scott".emp);
-
+-------+-------+-----+-----+----------+-----+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----+-----+----------+-----+------+--------+
@@ -155,7 +150,6 @@ where not sal <= some (select comm from "scott".emp);
# Similar, as scalar sub-query.
select *, sal <= some (select comm from "scott".emp) as x
from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+------+
@@ -183,7 +177,6 @@ from "scott".emp;
select *
from "scott".emp
where empno <> some (values (100), (200));
-
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
@@ -209,7 +202,6 @@ where empno <> some (values (100), (200));
# Previous, as scalar sub-query.
select *, empno <> some (values (100), (200)) as x
from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+------+
@@ -236,7 +228,6 @@ from "scott".emp;
select *
from "scott".emp
where empno <> some (values (7499),(NULL));
-
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
@@ -261,7 +252,6 @@ where empno <> some (values (7499),(NULL));
# Previous, as scalar sub-query.
select *, empno <> some (values (7499), (NULL)) as x
from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+------+
@@ -288,7 +278,6 @@ from "scott".emp;
select *
from "scott".emp
where empno <> some (select empno from "scott".emp where empno = 8000);
-
+-------+-------+-----+-----+----------+-----+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----+-----+----------+-----+------+--------+
@@ -300,7 +289,6 @@ where empno <> some (select empno from "scott".emp where
empno = 8000);
# Previous, as scalar sub-query.
select *, empno <> some (select empno from "scott".emp where empno = 8000) as x
from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
@@ -327,7 +315,6 @@ from "scott".emp;
select *
from "scott".emp
where emp.comm <> some (values (300), (500));
-
+-------+--------+----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+----------+------+------------+---------+---------+--------+
@@ -343,7 +330,6 @@ where emp.comm <> some (values (300), (500));
# Previous, as scalar sub-query.
select *, emp.comm <> some (values (300), (500)) as x
from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+------+
@@ -370,7 +356,6 @@ from "scott".emp;
select *
from "scott".emp
where emp.comm <> some (select comm from "scott".emp);
-
+-------+--------+----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+----------+------+------------+---------+---------+--------+
@@ -386,7 +371,6 @@ where emp.comm <> some (select comm from "scott".emp);
# Previous, as scalar sub-query.
select *, emp.comm <> some (select comm from "scott".emp) as x
from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+------+
@@ -413,7 +397,6 @@ from "scott".emp;
select *
from "scott".emp
where emp.comm <> some (select comm from "scott".emp where comm = 800);
-
+-------+-------+-----+-----+----------+-----+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----+-----+----------+-----+------+--------+
@@ -425,7 +408,6 @@ where emp.comm <> some (select comm from "scott".emp where
comm = 800);
# Previous, as scalar sub-query.
select *, emp.comm <> some (select comm from "scott".emp where comm = 800) as x
from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
@@ -452,7 +434,6 @@ from "scott".emp;
select * from "scott".emp
where comm < all (select comm from "scott".emp where 1 = 0)
order by empno;
-
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
@@ -478,7 +459,6 @@ order by empno;
# If sub-query is empty, "< some" is trivially false. Even for null comm.
select * from "scott".emp
where comm < some (select comm from "scott".emp where 1 = 0);
-
+-------+-------+-----+-----+----------+-----+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----+-----+----------+-----+------+--------+
@@ -489,7 +469,6 @@ where comm < some (select comm from "scott".emp where 1 =
0);
select * from "scott".emp
where sal > all (select comm from "scott".emp where comm <> null);
-
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
@@ -514,7 +493,6 @@ where sal > all (select comm from "scott".emp where comm <>
null);
select * from "scott".emp
where sal > all(500, 2000);
-
+-------+-------+-----------+------+------------+---------+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----------+------+------------+---------+------+--------+
@@ -531,7 +509,6 @@ where sal > all(500, 2000);
select * from "scott".emp
where sal > all (4000, 2000);
-
+-------+-------+-----------+-----+------------+---------+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----------+-----+------------+---------+------+--------+
@@ -543,7 +520,6 @@ where sal > all (4000, 2000);
select * from "scott".emp
where sal > some (4000, 2000);
-
+-------+-------+-----------+------+------------+---------+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----------+------+------------+---------+------+--------+
@@ -560,7 +536,6 @@ where sal > some (4000, 2000);
select * from "scott".emp
where sal > any (4000, 2000);
-
+-------+-------+-----------+------+------------+---------+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----------+------+------------+---------+------+--------+
@@ -583,7 +558,6 @@ more than one value in agg SINGLE_VALUE
select * from "scott".emp
where sal > any (select sal * 2 from "scott".emp)
order by sal desc;
-
+-------+-------+-----------+------+------------+---------+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----------+------+------------+---------+------+--------+
@@ -601,7 +575,6 @@ order by sal desc;
select * from "scott".emp
where sal < all (select sal * 2 from "scott".emp)
order by sal desc;
-
+-------+--------+----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+----------+------+------------+---------+---------+--------+
@@ -649,7 +622,6 @@ order by sal desc;
select * from "scott".emp
where sal < all (select comm * 2 from "scott".emp);
-
+-------+-------+-----+-----+----------+-----+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----+-----+----------+-----+------+--------+
@@ -661,7 +633,6 @@ where sal < all (select comm * 2 from "scott".emp);
select * from "scott".emp
where sal < any (select comm * 2 from "scott".emp)
order by empno;
-
+-------+--------+----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+----------+------+------------+---------+---------+--------+
@@ -683,7 +654,6 @@ order by empno;
# It should return all rows.
select * from "scott".emp
where sal < any (select comm * 2 from "scott".emp) is unknown;
-
+-------+-------+-----------+------+------------+---------+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----------+------+------------+---------+------+--------+
@@ -699,7 +669,6 @@ where sal < any (select comm * 2 from "scott".emp) is
unknown;
# Oracle gives error, but I believe the statement is valid and result is
correct.
select *, sal > all(select comm from "scott".emp) as x from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
@@ -724,7 +693,6 @@ select *, sal > all(select comm from "scott".emp) as x from
"scott".emp;
select * from "scott".emp
where sal > all (select comm from "scott".emp);
-
+-------+-------+-----+-----+----------+-----+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----+-----+----------+-----+------+--------+
@@ -735,7 +703,6 @@ where sal > all (select comm from "scott".emp);
select * from "scott".emp
where sal > any (select comm from "scott".emp);
-
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
@@ -760,7 +727,6 @@ where sal > any (select comm from "scott".emp);
select * from "scott".emp
where sal > any (select comm from "scott".emp where comm < 1000);
-
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
@@ -785,7 +751,6 @@ where sal > any (select comm from "scott".emp where comm <
1000);
select * from "scott".emp
where sal > any (select comm from "scott".emp where comm < 2000);
-
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
@@ -810,7 +775,6 @@ where sal > any (select comm from "scott".emp where comm <
2000);
select * from "scott".emp
where sal > any (select comm * 2 from "scott".emp where comm < 2000);
-
+-------+--------+-----------+------+------------+---------+---------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+---------+--------+
@@ -835,7 +799,6 @@ where sal > any (select comm * 2 from "scott".emp where
comm < 2000);
select * from "scott".emp
where sal > all (select comm * 2 from "scott".emp where comm < 2000);
-
+-------+-------+-----------+------+------------+---------+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----------+------+------------+---------+------+--------+
@@ -851,7 +814,6 @@ where sal > all (select comm * 2 from "scott".emp where
comm < 2000);
select * from "scott".emp
where sal > all (select comm from "scott".emp where comm is not null);
-
+-------+--------+-----------+------+------------+---------+--------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+--------+-----------+------+------------+---------+--------+--------+
diff --git a/core/src/test/resources/sql/spatial.iq
b/core/src/test/resources/sql/spatial.iq
index d926ab9a4a..fe12e9d1fc 100644
--- a/core/src/test/resources/sql/spatial.iq
+++ b/core/src/test/resources/sql/spatial.iq
@@ -421,7 +421,6 @@ POLYGON ((10 10, 10 11, 11 11, 11 10, 10 10))
!ok
SELECT ST_AsText(ST_MakeEnvelope(12.0, -1.0, 6.0, 4.0, 4326));
-
EXPR$0
POLYGON ((12 -1, 12 4, 6 4, 6 -1, 12 -1))
!ok
@@ -704,7 +703,6 @@ EXPR$0
SELECT round(ST_Distance(
ST_Transform(ST_GeomFromText('POINT(-72.1235 42.3521)', 4326), 2163),
ST_Transform(ST_GeomFromText('LINESTRING(-72.1260 42.45, -72.123
42.1546)', 4326), 2163)), 10);
-
EXPR$0
126.6642560574
!ok
@@ -1255,7 +1253,6 @@ SELECT ST_GeometryType(geomA) As geomtype,
ST_Contains(geomA,geomA) AS acontains
FROM (VALUES ( ST_Buffer(ST_Point(1.0,1.0), 5/*,1*/) ),
( ST_MakeLine(ST_Point(1.0,1.0), ST_Point(-1.0,-1.0) ) ),
( ST_Point(1.0,1.0))) As foo(geomA);
-
GEOMTYPE, ACONTAINSA, ACONTAINSPROPA, ACONTAINSBA, ACONTAINSPROPBA
LINESTRING, true, true, false, false
POINT, true, true, false, false
@@ -2156,7 +2153,6 @@ FROM (
SELECT ST_GeomFromText('POINT Z(-2 3 1)') as the_geom
UNION ALL
SELECT ST_GeomFromText('LINESTRING Z(5 5 5, 10 10 10)') as the_geom ) as foo;
-
EXPR$0
GEOMETRYCOLLECTION Z(POINT Z(-2 3 1), LINESTRING Z(5 5 5, 10 10 10), POLYGON
Z((-7 4.2 2, -7.1 4.2 3, -7.1 4.3 2, -7 4.2 2)))
!ok
diff --git a/core/src/test/resources/sql/sub-query.iq
b/core/src/test/resources/sql/sub-query.iq
index e464dba2e5..9b1da29f9b 100644
--- a/core/src/test/resources/sql/sub-query.iq
+++ b/core/src/test/resources/sql/sub-query.iq
@@ -50,7 +50,6 @@ t2(x) as (select * from (values (1),(case when 1 = 1 then
null else 3 end)) as
select *
from t1
where t1.x not in (select t2.x from t2);
-
X
---
(0 rows)
@@ -2224,7 +2223,6 @@ EnumerableCalc(expr#0..2=[{inputs}], ENAME=[$t1])
EnumerableCalc(expr#0..7=[{inputs}], expr#8=[IS NOT NULL($t3)],
expr#9=[CAST($t3):INTEGER NOT NULL], expr#10=[0], expr#11=[CASE($t8, $t9,
$t10)], $f8=[$t11])
EnumerableTableScan(table=[[scott, EMP]])
!plan
-
ENAME
--------
ADAMS
@@ -2270,7 +2268,6 @@ EnumerableCalc(expr#0..5=[{inputs}], expr#6=[<>($t2,
$t1)], expr#7=[1], expr#8=[
# Previous, as scalar sub-query.
select empno, empno <> some (select emp2.empno from "scott".emp emp2 where
emp2.empno = emp1.empno) as x
from "scott".emp emp1;
-
+-------+-------+
| EMPNO | X |
+-------+-------+
@@ -2326,7 +2323,6 @@ EnumerableCalc(expr#0..12=[{inputs}], expr#13=[<>($t9,
$t8)], expr#14=[1], expr#
# Previous, as scalar sub-query.
select *, empno <> some (select comm from "scott".emp where deptno =
emp1.deptno) as x
from "scott".emp as emp1;
-
+-------+--------+-----------+------+------------+---------+---------+--------+------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+------+
@@ -2375,7 +2371,6 @@ EnumerableCalc(expr#0..12=[{inputs}], expr#13=[<>($t9,
$t8)], expr#14=[1], expr#
# Previous, as scalar sub-query.
select *, empno <> some (select 2 from "scott".dept dept1 where dept1.deptno =
emp1.empno) as x
from "scott".emp as emp1;
-
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
@@ -2424,7 +2419,6 @@ EnumerableCalc(expr#0..12=[{inputs}], expr#13=[<>($t9,
$t8)], expr#14=[1], expr#
# Previous, as scalar sub-query.
select *, comm <> some (select 2 from "scott".dept dept1 where dept1.deptno =
emp1.empno) as x
from "scott".emp as emp1;
-
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
@@ -2476,7 +2470,6 @@ EnumerableCalc(expr#0..12=[{inputs}], expr#13=[<>($t9,
$t8)], expr#14=[1], expr#
# Previous, as scalar sub-query.
select *, emp1.comm <> some (select comm from "scott".emp where sal =
emp1.sal) as x
from "scott".emp emp1;
-
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| X |
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
@@ -2508,7 +2501,6 @@ from "scott".emp emp1;
select deptno
from "scott".dept
where unique (select comm from "scott".emp where comm is not null);
-
+--------+
| DEPTNO |
+--------+
@@ -2535,7 +2527,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], $condi
# Previous, as scalar sub-query.
select deptno, unique (select comm from "scott".emp where comm is not null) as
u
from "scott".dept;
-
+--------+------+
| DEPTNO | U |
+--------+------+
@@ -2562,7 +2553,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], U=[$t2
# Previous, but NOT UNIQUE.
select deptno, not unique (select comm from "scott".emp where comm is not
null) as u
from "scott".dept;
-
+--------+-------+
| DEPTNO | U |
+--------+-------+
@@ -2590,7 +2580,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS NOT
NULL($t1)], DEPTNO=[$t0], U=
select deptno
from "scott".dept
where unique (select comm from "scott".emp);
-
+--------+
| DEPTNO |
+--------+
@@ -2617,7 +2606,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], $condi
# Previous, as scalar sub-query.
select deptno, unique (select comm from "scott".emp) as u
from "scott".dept;
-
+--------+------+
| DEPTNO | U |
+--------+------+
@@ -2645,7 +2633,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], U=[$t2
select deptno
from "scott".dept
where unique (select comm from "scott".emp where comm is null);
-
+--------+
| DEPTNO |
+--------+
@@ -2665,7 +2652,6 @@ EnumerableCalc(expr#0..2=[{inputs}], DEPTNO=[$t0])
# Previous, as scalar sub-query.
select deptno, unique (select comm from "scott".emp where comm is null) as u
from "scott".dept;
-
+--------+------+
| DEPTNO | U |
+--------+------+
@@ -2686,7 +2672,6 @@ EnumerableCalc(expr#0..2=[{inputs}], expr#3=[true],
DEPTNO=[$t0], U=[$t3])
select deptno
from "scott".dept
where unique (select comm, sal from "scott".emp where comm is not null);
-
+--------+
| DEPTNO |
+--------+
@@ -2713,7 +2698,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], $condi
# Previous, as scalar sub-query.
select deptno, unique (select comm, sal from "scott".emp where comm is not
null) as u
from "scott".dept;
-
+--------+------+
| DEPTNO | U |
+--------+------+
@@ -2743,7 +2727,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], U=[$t2
select deptno
from "scott".dept
where unique (select comm, sal from "scott".emp);
-
+--------+
| DEPTNO |
+--------+
@@ -2770,7 +2753,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], $condi
# Previous, as scalar sub-query.
select deptno, unique (select comm, sal from "scott".emp) as u
from "scott".dept;
-
+--------+------+
| DEPTNO | U |
+--------+------+
@@ -2820,7 +2802,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], $condi
# Previous, as scalar sub-query.
select deptno, unique (select deptno from "scott".emp) as u
from "scott".dept;
-
+--------+-------+
| DEPTNO | U |
+--------+-------+
@@ -2870,7 +2851,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], $condi
# Previous, as scalar sub-query.
select deptno, unique (select deptno, sal from "scott".emp where sal = 3000)
as u
from "scott".dept;
-
+--------+-------+
| DEPTNO | U |
+--------+-------+
@@ -2897,7 +2877,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], U=[$t2
# Previous, but NOT UNIQUE.
select deptno, not unique (select deptno, sal from "scott".emp where sal =
3000) as u
from "scott".dept;
-
+--------+------+
| DEPTNO | U |
+--------+------+
@@ -2925,7 +2904,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS NOT
NULL($t1)], DEPTNO=[$t0], U=
select deptno
from "scott".dept
where unique (select deptno from "scott".emp where deptno = 35);
-
+--------+
| DEPTNO |
+--------+
@@ -2952,7 +2930,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], $condi
# Previous, as scalar sub-query.
select deptno, unique (select deptno from "scott".emp where deptno = 35) as u
from "scott".dept;
-
+--------+------+
| DEPTNO | U |
+--------+------+
@@ -2980,7 +2957,6 @@ EnumerableCalc(expr#0..1=[{inputs}], expr#2=[IS
NULL($t1)], DEPTNO=[$t0], U=[$t2
select *
from "scott".dept
where unique (select deptno from "scott".dept);
-
+--------+------------+----------+
| DEPTNO | DNAME | LOC |
+--------+------------+----------+
@@ -3000,7 +2976,6 @@ EnumerableTableScan(table=[[scott, DEPT]])
select *
from "scott".dept
where unique (select deptno from "scott".emp limit 1);
-
+--------+------------+----------+
| DEPTNO | DNAME | LOC |
+--------+------------+----------+
@@ -3020,7 +2995,6 @@ EnumerableTableScan(table=[[scott, DEPT]])
select deptno
from "scott".dept
where unique (select distinct deptno, sal from "scott".emp where sal = 3000);
-
+--------+
| DEPTNO |
+--------+
@@ -3041,7 +3015,6 @@ EnumerableCalc(expr#0..2=[{inputs}], DEPTNO=[$t0])
select deptno
from "scott".dept
where unique (select job from "scott".emp group by job);
-
+--------+
| DEPTNO |
+--------+
@@ -3063,7 +3036,6 @@ select *
from "scott".dept
where unique (
select 1 from "scott".emp where dept.deptno = emp.deptno);
-
+--------+------------+--------+
| DEPTNO | DNAME | LOC |
+--------+------------+--------+
@@ -3086,7 +3058,6 @@ EnumerableCalc(expr#0..4=[{inputs}], expr#5=[IS
NULL($t3)], proj#0..2=[{exprs}],
# Previous, as scalar sub-query.
select *, unique (select 1 from "scott".emp where dept.deptno = emp.deptno) as
u
from "scott".dept;
-
+--------+------------+----------+-------+
| DEPTNO | DNAME | LOC | U |
+--------+------------+----------+-------+
@@ -3114,7 +3085,6 @@ select *
from "scott".dept
where not unique (
select 1 from "scott".emp where dept.deptno = emp.deptno);
-
+--------+------------+----------+
| DEPTNO | DNAME | LOC |
+--------+------------+----------+
@@ -3137,7 +3107,6 @@ EnumerableHashJoin(condition=[=($0, $3)], joinType=[semi])
# Previous, as scalar sub-query.
select *, not unique (select 1 from "scott".emp where dept.deptno =
emp.deptno) as u
from "scott".dept;
-
+--------+------------+----------+-------+
| DEPTNO | DNAME | LOC | U |
+--------+------------+----------+-------+
@@ -3165,7 +3134,6 @@ EnumerableCalc(expr#0..4=[{inputs}], expr#5=[IS NOT
NULL($t3)], proj#0..2=[{expr
# The IN-list contains partial null value.
select * from "scott".emp where comm in (300, 500, null);
-
+-------+-------+----------+------+------------+---------+--------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+----------+------+------------+---------+--------+--------+
@@ -3182,7 +3150,6 @@ EnumerableCalc(expr#0..7=[{inputs}],
expr#8=[Sarg[300:DECIMAL(7, 2), 500:DECIMAL
# Previous, as scalar sub-query.
select *, comm in (300, 500, null) as i from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| I |
+-------+--------+-----------+------+------------+---------+---------+--------+------+
@@ -3211,7 +3178,6 @@ EnumerableCalc(expr#0..7=[{inputs}],
expr#8=[Sarg[300:DECIMAL(7, 2), 500:DECIMAL
# As above, but NOT IN.
select * from "scott".emp where comm not in (300, 500, null);
-
+-------+-------+-----+-----+----------+-----+------+--------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
+-------+-------+-----+-----+----------+-----+------+--------+
@@ -3225,7 +3191,6 @@ EnumerableValues(tuples=[[]])
# Previous, as scalar sub-query.
select *, comm not in (300, 500, null) as i from "scott".emp;
-
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO
| I |
+-------+--------+-----------+------+------------+---------+---------+--------+-------+
@@ -3572,7 +3537,6 @@ SELECT ARRAY(SELECT s.x) FROM (SELECT 1 as x) s;
# Test case for [CALCITE-5310] JSON_OBJECT in scalar sub-query throws
AssertionError
SELECT (SELECT json_object('1': (a.attidentity = 'a'), '2': v) FROM
UNNEST(ARRAY[1]) as v) as options
FROM UNNEST(ARRAY['a', 'b']) AS a(attidentity);
-
+-------------------+
| OPTIONS |
+-------------------+
diff --git a/core/src/test/resources/sql/winagg.iq
b/core/src/test/resources/sql/winagg.iq
index 3187bf158e..da9786d817 100644
--- a/core/src/test/resources/sql/winagg.iq
+++ b/core/src/test/resources/sql/winagg.iq
@@ -83,7 +83,6 @@ from emp;
select gender,deptno,
count(*) over (partition by gender,deptno) as count1
from emp;
-
+--------+--------+--------+
| GENDER | DEPTNO | COUNT1 |
+--------+--------+--------+
@@ -106,7 +105,6 @@ from emp;
select gender,deptno,
count(*) over (partition by gender,gender) as count1
from emp;
-
+--------+--------+--------+
| GENDER | DEPTNO | COUNT1 |
+--------+--------+--------+
@@ -400,7 +398,6 @@ select min(deptno) as x, rank() over (order by ename) as y,
max(ename) over (partition by deptno) as z
from emp
group by deptno, ename;
-
+----+---+-------+
| X | Y | Z |
+----+---+-------+
@@ -447,7 +444,6 @@ select * from (
select "empid", count(*) over () c
from "hr"."emps"
) where "empid"=100;
-
+-------+---+
| empid | C |
+-------+---+
@@ -469,7 +465,6 @@ join (
window w as (partition by "deptno" order by "commission")) b
on a."deptno" = b."deptno"
order by "deptno", ar, br limit 5;
-
+--------+-----+-----+
| deptno | AR | BR |
+--------+-----+-----+
@@ -494,7 +489,6 @@ join (
window w as (partition by "deptno" order by "commission")) b
on a."empid" = b."empid"
limit 5;
-
+-------+--------+------------+-----+-----+
| empid | deptno | commission | AR | BR |
+-------+--------+------------+-----+-----+
@@ -526,7 +520,6 @@ from
from
unnest(map[2,2]) k
) t2 on (t1.l = t2.l and t1.key + 1 = t2.key);
-
+---+------+------+
| L | KEY1 | KEY2 |
+---+------+------+
diff --git a/gradle.properties b/gradle.properties
index 7ae2caa477..516dff1c73 100644
--- a/gradle.properties
+++ b/gradle.properties
@@ -146,7 +146,7 @@ pig.version=0.16.0
pigunit.version=0.16.0
postgresql.version=9.3-1102-jdbc41
protobuf.version=3.21.5
-quidem.version=0.10
+quidem.version=0.11
scala-library.version=2.10.3
scott-data-hsqldb.version=0.2
servlet.version=4.0.1
diff --git a/plus/src/test/resources/sql/basic.iq
b/plus/src/test/resources/sql/basic.iq
index da8a33fd7d..230419fb4d 100644
--- a/plus/src/test/resources/sql/basic.iq
+++ b/plus/src/test/resources/sql/basic.iq
@@ -32,7 +32,6 @@ FROM `chinook`.`Artist` AS ar
JOIN `chinook`.`Album` AS al ON ar.`ArtistId` = al.`ArtistId`
JOIN `chinook`.`Track` as tr ON al.`AlbumId` = tr.`AlbumId`
GROUP BY ar.`Name`;
-
+---------------------------------------------------------------------------------------+--------------+-----------+
| NAME
| TRACKS_COUNT | MS_TOTAL |
+---------------------------------------------------------------------------------------+--------------+-----------+
