commit 2aabf210dc1918c6ca20e63b39661ff445535eb8
author caicancai <2356672992@qq.com> Tue Jan 30 23:25:44 2024 +0800
committer Ruben Quesada Lopez <rubenql@gmail.com> Fri Feb 02 16:05:17 2024 +0000
tree d2d97cbd7fc07d9cf7eb7583f710bbf62d25ab36
parent 351ddeb47b8dfb5c196c563920290a79575e9864

[CALCITE-6234] Add tests on SqlOperatorTest for to_char function

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 a8b8d87..d4ee5b7 100644
--- a/testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java
+++ b/testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java
@@ -4423,6 +4423,33 @@
     f.checkString("to_char(timestamp '2022-06-03 12:15:48.678', 'YYYY-MM-DD HH24:MI:SS.MS TZ')",
         "2022-06-03 12:15:48.678",
         "VARCHAR(2000) NOT NULL");
+    f.checkString("to_char(timestamp '2022-06-03 12:15:48.678', 'Day')",
+        "Friday",
+        "VARCHAR(2000) NOT NULL");
+    f.checkString("to_char(timestamp '2022-06-03 12:15:48.678', 'CC')",
+        "21",
+        "VARCHAR(2000) NOT NULL");
+    f.checkString("to_char(timestamp '2022-06-03 13:15:48.678', 'HH12')",
+        "01",
+        "VARCHAR(2000) NOT NULL");
+    f.checkString("to_char(timestamp '2022-06-03 13:15:48.678', 'HH24')",
+        "13",
+        "VARCHAR(2000) NOT NULL");
+    f.checkString("to_char(timestamp '2022-06-03 13:15:48.678', 'MI')",
+        "15",
+        "VARCHAR(2000) NOT NULL");
+    f.checkString("to_char(timestamp '2022-06-03 13:15:48.678', 'MS')",
+        "678",
+        "VARCHAR(2000) NOT NULL");
+    f.checkString("to_char(timestamp '2022-06-03 13:15:48.678', 'Q')",
+        "2",
+        "VARCHAR(2000) NOT NULL");
+    f.checkString("to_char(timestamp '2022-06-03 13:15:48.678', 'IW')",
+        "23",
+        "VARCHAR(2000) NOT NULL");
+    f.checkNull("to_char(timestamp '2022-06-03 12:15:48.678', NULL)");
+    f.checkNull("to_char(cast(NULL as timestamp), NULL)");
+    f.checkNull("to_char(cast(NULL as timestamp), 'Day')");
   }
 
   @Test void testFromBase64() {