commit c774c313a81d01c4e3e77cf296d04839c5ab04c0
author Mihai Budiu <mbudiu@feldera.com> Mon Feb 12 14:44:47 2024 -0800
committer Mihai Budiu <mbudiu@feldera.com> Tue Feb 13 13:17:06 2024 -0800
tree 796561ebf22ce7ef9501727fc4c9b7bbe6351f3e
parent e05b0473a00a7b7fdb386e3decb4bff42a2161ac

[CALCITE-6248] Illegal dates are accepted by casts

Signed-off-by: Mihai Budiu <mbudiu@feldera.com>

core/src/test/java/org/apache/calcite/test/JdbcTest.java

diff --git a/core/src/test/java/org/apache/calcite/test/JdbcTest.java b/core/src/test/java/org/apache/calcite/test/JdbcTest.java
index a547053..2edb52a 100644
--- a/core/src/test/java/org/apache/calcite/test/JdbcTest.java
+++ b/core/src/test/java/org/apache/calcite/test/JdbcTest.java
@@ -8203,7 +8203,7 @@
    * TIMESTAMP elements</a>. */
   @Test void testArrayOfDates() {
     CalciteAssert.that()
-        .query("select array[cast('1900-1-1' as date)]")
+        .query("select array[cast('1900-01-01' as date)]")
         .returns("EXPR$0=[1900-01-01]\n");
   }
 

testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java

diff --git a/testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java b/testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java
index 047232b..2ff72a1 100644
--- a/testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java
+++ b/testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java
@@ -1320,7 +1320,7 @@
     f.checkCastToString("DATE '1945-2-24'", null, "1945-02-24", castType);
 
     f.checkScalar("cast('1945-02-24' as DATE)", "1945-02-24", "DATE NOT NULL");
-    f.checkScalar("cast(' 1945-2-4 ' as DATE)", "1945-02-04", "DATE NOT NULL");
+    f.checkScalar("cast(' 1945-02-04 ' as DATE)", "1945-02-04", "DATE NOT NULL");
     f.checkScalar("cast('  1945-02-24  ' as DATE)",
         "1945-02-24", "DATE NOT NULL");
     if (castType == CastType.CAST) {