You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by mb...@apache.org on 2025/09/24 19:56:21 UTC
(calcite) branch main updated: Enable some disabled quidem tests
This is an automated email from the ASF dual-hosted git repository.
mbudiu 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 18f172a2ec Enable some disabled quidem tests
18f172a2ec is described below
commit 18f172a2ececf0b4bb3d3e85faa6096503af104a
Author: Mihai Budiu <mb...@feldera.com>
AuthorDate: Wed Sep 24 11:16:01 2025 -0700
Enable some disabled quidem tests
Signed-off-by: Mihai Budiu <mb...@feldera.com>
---
core/src/test/resources/sql/scalar.iq | 36 ++++++++++++++++-------------------
1 file changed, 16 insertions(+), 20 deletions(-)
diff --git a/core/src/test/resources/sql/scalar.iq b/core/src/test/resources/sql/scalar.iq
index e931882e5d..82a1eb9223 100644
--- a/core/src/test/resources/sql/scalar.iq
+++ b/core/src/test/resources/sql/scalar.iq
@@ -164,20 +164,18 @@ select deptno, (select sum(cast(empno as bigint)) from "scott".emp where deptno
!ok
# [CALCITE-709] Errors with LIMIT inside scalar sub-query
-!if (false) {
select deptno, (select sum(empno) from "scott".emp where deptno = dept.deptno limit 0) as x from "scott".dept;
-+--------+-------+
-| DEPTNO | X |
-+--------+-------+
-| 10 | 23555 |
-| 20 | 38501 |
-| 30 | 46116 |
-| 40 | |
-+--------+-------+
++--------+---+
+| DEPTNO | X |
++--------+---+
+| 10 | |
+| 20 | |
+| 30 | |
+| 40 | |
++--------+---+
(4 rows)
!ok
-!}
# [CALCITE-709] Errors with LIMIT inside scalar sub-query
select deptno, (select deptno from "scott".emp where deptno = dept.deptno limit 1) as x from "scott".dept;
@@ -207,20 +205,18 @@ select deptno, (select deptno from "scott".emp where deptno = dept.deptno limit
!ok
# [CALCITE-709] Errors with LIMIT inside scalar sub-query
-!if (false) {
select deptno, (select empno from "scott".emp where deptno = dept.deptno order by empno limit 1) as x from "scott".dept;
-+--------+--------+
-| DEPTNO | X |
-+--------+--------+
-| 10 | 7369 |
-| 20 | 7369 |
-| 30 | 7369 |
-| 40 | 7369 |
-+--------+--------+
++--------+------+
+| DEPTNO | X |
++--------+------+
+| 10 | 7782 |
+| 20 | 7369 |
+| 30 | 7499 |
+| 40 | |
++--------+------+
(4 rows)
!ok
-!}
select deptno, (select empno from "scott".emp order by empno limit 1) as x from "scott".dept;
+--------+------+