This is an automated email from the ASF dual-hosted git repository. rubenql 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 2aabf210dc [CALCITE-6234] Add tests on SqlOperatorTest for to_char function 2aabf210dc is described below commit 2aabf210dc1918c6ca20e63b39661ff445535eb8 Author: caicancai <2356672...@qq.com> AuthorDate: Tue Jan 30 23:25:44 2024 +0800 [CALCITE-6234] Add tests on SqlOperatorTest for to_char function --- .../org/apache/calcite/test/SqlOperatorTest.java | 27 ++++++++++++++++++++++ 1 file changed, 27 insertions(+) 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 a8b8d876e5..d4ee5b75f6 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 @@ public class SqlOperatorTest { 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() {