(calcite) branch main updated: Enable tests in unnest.iq about [CALCITE-5127]

[xiong]

This is an automated email from the ASF dual-hosted git repository.

xiong 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 6f86860a85 Enable tests in unnest.iq about [CALCITE-5127]
6f86860a85 is described below

commit 6f86860a85815ae6031fa9de79014c7b2a45017e
Author: Xiong Duan <nobigo...@gmail.com>
AuthorDate: Fri Jan 24 10:39:53 2025 +0800

    Enable tests in unnest.iq about [CALCITE-5127]
---
 .../org/apache/calcite/rel/metadata/RelMdPredicates.java    |  2 +-
 core/src/test/resources/sql/unnest.iq                       | 13 +++++--------
 2 files changed, 6 insertions(+), 9 deletions(-)

diff --git 
a/core/src/main/java/org/apache/calcite/rel/metadata/RelMdPredicates.java 
b/core/src/main/java/org/apache/calcite/rel/metadata/RelMdPredicates.java
index f162f27e83..f7d7692c10 100644
--- a/core/src/main/java/org/apache/calcite/rel/metadata/RelMdPredicates.java
+++ b/core/src/main/java/org/apache/calcite/rel/metadata/RelMdPredicates.java
@@ -114,7 +114,7 @@
  * select a from R1 where a &gt; 7
  *   &rarr; "a &gt; 7" is pulled up from the Projection.
  * select a + 1 from R1 where a + 1 &gt; 7
- *   &rarr; "a + 1 gt; 7" is not pulled up
+ *   &rarr; "a + 1 &gt; 7" is not pulled up
  * </pre>
  *
  * <li> There are several restrictions on Joins:
diff --git a/core/src/test/resources/sql/unnest.iq 
b/core/src/test/resources/sql/unnest.iq
index bf990ad463..88488141ad 100644
--- a/core/src/test/resources/sql/unnest.iq
+++ b/core/src/test/resources/sql/unnest.iq
@@ -116,19 +116,16 @@ from UNNEST(array(select 'banana')) as fruit;
 
 !ok
 
-#TODO: Remove if when [CALCITE-5127] will be fixed.
-!if (false) {
 SELECT ARRAY(SELECT y + 1 FROM UNNEST(s.x) y)
 FROM (SELECT ARRAY[1,2,3] as x) s;
-+--------+
-| FRUIT  |
-+--------+
-| banana |
-+--------+
++-----------+
+| EXPR$0    |
++-----------+
+| [2, 3, 4] |
++-----------+
 (1 row)
 
 !ok
-!}
 
 # If UNNEST is not the direct child of the AS, aliasing doesn't happen.
 SELECT fruit.*