You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by tl...@apache.org on 2021/06/22 16:49:54 UTC
[ignite] branch ignite-14953 updated: wip
This is an automated email from the ASF dual-hosted git repository.
tledkov pushed a commit to branch ignite-14953
in repository https://gitbox.apache.org/repos/asf/ignite.git
The following commit(s) were added to refs/heads/ignite-14953 by this push:
new 995b108 wip
995b108 is described below
commit 995b108b5ddcf15d413a7384176ad5741d873348
Author: tledkov <tl...@gridgain.com>
AuthorDate: Tue Jun 22 19:49:33 2021 +0300
wip
---
.../query/calcite/logical/SqlScriptRunner.java | 2 +-
.../apache/ignite/testsuites/ScriptTestSuite.java | 2 +-
.../src/test/sql/function/date/test_extract.test | 47 +-
.../sql/function/date/test_extract.test_ignore | 113 ++++
.../sql/function/date/test_extract_edge_cases.test | 279 --------
...es.test => test_extract_edge_cases.test_ignore} | 2 +
.../test/sql/function/date/test_extract_month.test | 635 +----------------
.../function/date/test_extract_month.test_ignore | 753 +++++++++++++++++++++
.../test/sql/function/date/test_extract_year.test | 9 +-
.../src/test/sql/function/date/test_strftime.test | 101 ---
.../function/date/test_strftime_exhaustive.test | 354 ----------
11 files changed, 891 insertions(+), 1406 deletions(-)
diff --git a/modules/calcite/src/test/java/org/apache/ignite/internal/processors/query/calcite/logical/SqlScriptRunner.java b/modules/calcite/src/test/java/org/apache/ignite/internal/processors/query/calcite/logical/SqlScriptRunner.java
index 291c1ac..35101ce 100644
--- a/modules/calcite/src/test/java/org/apache/ignite/internal/processors/query/calcite/logical/SqlScriptRunner.java
+++ b/modules/calcite/src/test/java/org/apache/ignite/internal/processors/query/calcite/logical/SqlScriptRunner.java
@@ -530,7 +530,7 @@ public class SqlScriptRunner {
private void checkResultTuples(List<List<?>> res) {
if (expectedRes.size() != res.size()) {
throw new AssertionError("Invalid results rows count at: " + posDesc +
- ". [expected=" + expectedRes + ", actual=" + res + ']');
+ ". [expectedRows=" + expectedRes.size() + ", actualRows=" + res.size() + " expected=" + expectedRes + ", actual=" + res + ']');
}
for (int i = 0; i < expectedRes.size(); ++i) {
diff --git a/modules/calcite/src/test/java/org/apache/ignite/testsuites/ScriptTestSuite.java b/modules/calcite/src/test/java/org/apache/ignite/testsuites/ScriptTestSuite.java
index a5c3de4..7692a21 100644
--- a/modules/calcite/src/test/java/org/apache/ignite/testsuites/ScriptTestSuite.java
+++ b/modules/calcite/src/test/java/org/apache/ignite/testsuites/ScriptTestSuite.java
@@ -35,7 +35,7 @@ import org.junit.runner.RunWith;
* Use other properties of the {@link ScriptRunnerTestsEnvironment} to setup cluster and test environment.
*/
@RunWith(ScriptTestRunner.class)
-@ScriptRunnerTestsEnvironment(scriptsRoot = "src/test/sql", regex = "test_date_trunc.test_ignore$")
+@ScriptRunnerTestsEnvironment(scriptsRoot = "src/test/sql", regex = "generic/test_between.test")
@Ignore
public class ScriptTestSuite {
}
diff --git a/modules/calcite/src/test/sql/function/date/test_extract.test b/modules/calcite/src/test/sql/function/date/test_extract.test
index bd814a4..bce0759 100644
--- a/modules/calcite/src/test/sql/function/date/test_extract.test
+++ b/modules/calcite/src/test/sql/function/date/test_extract.test
@@ -3,112 +3,91 @@
# group: [date]
statement ok
-PRAGMA enable_verification
-
-statement ok
CREATE TABLE dates(i DATE)
statement ok
-INSERT INTO dates VALUES ('1993-08-14'), (NULL)
+INSERT INTO dates VALUES (DATE '1993-08-14'), (NULL)
# extract various parts of the date
# year
query I
-SELECT EXTRACT(year FROM i) FROM dates
+SELECT EXTRACT(year FROM i) FROM dates ORDER BY i
----
1993
NULL
# month
query I
-SELECT EXTRACT(month FROM i) FROM dates
+SELECT EXTRACT(month FROM i) FROM dates ORDER BY i
----
8
NULL
# day
query I
-SELECT EXTRACT(day FROM i) FROM dates
+SELECT EXTRACT(day FROM i) FROM dates ORDER BY i
----
14
NULL
# decade
query I
-SELECT EXTRACT(decade FROM i) FROM dates
+SELECT EXTRACT(decade FROM i) FROM dates ORDER BY i
----
199
NULL
# century
query I
-SELECT EXTRACT(century FROM i) FROM dates
+SELECT EXTRACT(century FROM i) FROM dates ORDER BY i
----
20
NULL
-# day of the week (Sunday = 0, Saturday = 6)
-query I
-SELECT EXTRACT(DOW FROM i) FROM dates
-----
-6
-NULL
-
# day of the year (1 - 365/366)
query I
-SELECT EXTRACT(DOY FROM i) FROM dates
+SELECT EXTRACT(DOY FROM i) FROM dates ORDER BY i
----
226
NULL
# epoch
query I
-SELECT EXTRACT(epoch FROM i) FROM dates
+SELECT EXTRACT(epoch FROM i) FROM dates ORDER BY i
----
745286400
NULL
# isodow (Monday = 1, Sunday = 7)
query I
-SELECT EXTRACT(ISODOW FROM i) FROM dates
+SELECT EXTRACT(ISODOW FROM i) FROM dates ORDER BY i
----
6
NULL
# millenium (change of millenium is January 1, X001)
query I
-SELECT EXTRACT(millennium FROM i) FROM dates
+SELECT EXTRACT(millennium FROM i) FROM dates ORDER BY i
----
2
NULL
# timestamp variants all give 0 for date
query I
-SELECT EXTRACT(second FROM i) FROM dates
-----
-0
-NULL
-
-query I
-SELECT EXTRACT(minute FROM i) FROM dates
+SELECT EXTRACT(second FROM i) FROM dates ORDER BY i
----
0
NULL
query I
-SELECT EXTRACT(hour FROM i) FROM dates
+SELECT EXTRACT(minute FROM i) FROM dates ORDER BY i
----
0
NULL
query I
-SELECT EXTRACT(milliseconds FROM i) FROM dates
+SELECT EXTRACT(hour FROM i) FROM dates ORDER BY i
----
0
NULL
-query I
-SELECT EXTRACT(microsecond FROM i) FROM dates
-----
-0
-NULL
diff --git a/modules/calcite/src/test/sql/function/date/test_extract.test_ignore b/modules/calcite/src/test/sql/function/date/test_extract.test_ignore
new file mode 100644
index 0000000..5987614
--- /dev/null
+++ b/modules/calcite/src/test/sql/function/date/test_extract.test_ignore
@@ -0,0 +1,113 @@
+# name: test/sql/function/date/test_extract.test
+# description: Extract function
+# group: [date]
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-14960
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-14955
+
+statement ok
+CREATE TABLE dates(i DATE)
+
+statement ok
+INSERT INTO dates VALUES (DATE '1993-08-14'), (NULL)
+
+# extract various parts of the date
+# year
+query I
+SELECT EXTRACT(year FROM i) FROM dates ORDER BY i
+----
+1993
+NULL
+
+# month
+query I
+SELECT EXTRACT(month FROM i) FROM dates ORDER BY i
+----
+8
+NULL
+
+# day
+query I
+SELECT EXTRACT(day FROM i) FROM dates ORDER BY i
+----
+14
+NULL
+
+# decade
+query I
+SELECT EXTRACT(decade FROM i) FROM dates ORDER BY i
+----
+199
+NULL
+
+# century
+query I
+SELECT EXTRACT(century FROM i) FROM dates ORDER BY i
+----
+20
+NULL
+
+# day of the week (Sunday = 0, Saturday = 6)
+query I
+SELECT EXTRACT(DOW FROM i) FROM dates ORDER BY i
+----
+6
+NULL
+
+# day of the year (1 - 365/366)
+query I
+SELECT EXTRACT(DOY FROM i) FROM dates ORDER BY i
+----
+226
+NULL
+
+# epoch
+query I
+SELECT EXTRACT(epoch FROM i) FROM dates ORDER BY i
+----
+745286400
+NULL
+
+# isodow (Monday = 1, Sunday = 7)
+query I
+SELECT EXTRACT(ISODOW FROM i) FROM dates ORDER BY i
+----
+6
+NULL
+
+# millenium (change of millenium is January 1, X001)
+query I
+SELECT EXTRACT(millennium FROM i) FROM dates ORDER BY i
+----
+2
+NULL
+
+# timestamp variants all give 0 for date
+query I
+SELECT EXTRACT(second FROM i) FROM dates ORDER BY i
+----
+0
+NULL
+
+query I
+SELECT EXTRACT(minute FROM i) FROM dates ORDER BY i
+----
+0
+NULL
+
+query I
+SELECT EXTRACT(hour FROM i) FROM dates ORDER BY i
+----
+0
+NULL
+
+query I
+SELECT EXTRACT(milliseconds FROM i) FROM dates ORDER BY i
+----
+0
+NULL
+
+query I
+SELECT EXTRACT(microsecond FROM i) FROM dates ORDER BY i
+----
+0
+NULL
diff --git a/modules/calcite/src/test/sql/function/date/test_extract_edge_cases.test b/modules/calcite/src/test/sql/function/date/test_extract_edge_cases.test
index 1db3179..52211a7 100644
--- a/modules/calcite/src/test/sql/function/date/test_extract_edge_cases.test
+++ b/modules/calcite/src/test/sql/function/date/test_extract_edge_cases.test
@@ -24,84 +24,6 @@ SELECT EXTRACT(millennium FROM cast('2001-10-10' AS DATE));
----
3
-# check DOW
-# start from the epoch and go up/down, every time the day should go up/down
-# one as well
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) + 0);
-----
-4
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) - 0);
-----
-4
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) + 1);
-----
-5
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) - 1);
-----
-3
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) + 2);
-----
-6
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) - 2);
-----
-2
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) + 3);
-----
-0
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) - 3);
-----
-1
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) + 4);
-----
-1
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) - 4);
-----
-0
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) + 5);
-----
-2
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) - 5);
-----
-6
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) + 6);
-----
-3
-
-query I
-SELECT EXTRACT(dow FROM cast('1970-01-01' AS DATE) - 6);
-----
-5
-
-query I
-SELECT EXTRACT(dow FROM cast('1793-05-26' AS DATE));
-----
-0
-
query I
SELECT EXTRACT(isodow FROM cast('1793-05-26' AS DATE));
----
@@ -138,204 +60,3 @@ SELECT EXTRACT(week FROM cast('2010-01-01' AS DATE));
----
53
-# every 7 days the week number should go up by 7
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 0);
-----
-1
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 7);
-----
-2
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 14);
-----
-3
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 21);
-----
-4
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 28);
-----
-5
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 35);
-----
-6
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 42);
-----
-7
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 49);
-----
-8
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 56);
-----
-9
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 63);
-----
-10
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 70);
-----
-11
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 77);
-----
-12
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 84);
-----
-13
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 91);
-----
-14
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 98);
-----
-15
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 105);
-----
-16
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 112);
-----
-17
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 119);
-----
-18
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 126);
-----
-19
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 133);
-----
-20
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 140);
-----
-21
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 147);
-----
-22
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 154);
-----
-23
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 161);
-----
-24
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 168);
-----
-25
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 175);
-----
-26
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 182);
-----
-27
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 189);
-----
-28
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 196);
-----
-29
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 203);
-----
-30
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 210);
-----
-31
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 217);
-----
-32
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 224);
-----
-33
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 231);
-----
-34
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 238);
-----
-35
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 245);
-----
-36
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 252);
-----
-37
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 259);
-----
-38
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 266);
-----
-39
-
-query I
-SELECT EXTRACT(week FROM cast('2007-01-01' AS DATE) + 273);
-----
-40
-
diff --git a/modules/calcite/src/test/sql/function/date/test_extract_edge_cases.test b/modules/calcite/src/test/sql/function/date/test_extract_edge_cases.test_ignore
similarity index 97%
copy from modules/calcite/src/test/sql/function/date/test_extract_edge_cases.test
copy to modules/calcite/src/test/sql/function/date/test_extract_edge_cases.test_ignore
index 1db3179..e424159 100644
--- a/modules/calcite/src/test/sql/function/date/test_extract_edge_cases.test
+++ b/modules/calcite/src/test/sql/function/date/test_extract_edge_cases.test_ignore
@@ -1,6 +1,8 @@
# name: test/sql/function/date/test_extract_edge_cases.test
# description: Extract function edge cases
# group: [date]
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-14961
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-14960
# century changes in the year 1
query I
diff --git a/modules/calcite/src/test/sql/function/date/test_extract_month.test b/modules/calcite/src/test/sql/function/date/test_extract_month.test
index fe2ed87..fe88fa8 100644
--- a/modules/calcite/src/test/sql/function/date/test_extract_month.test
+++ b/modules/calcite/src/test/sql/function/date/test_extract_month.test
@@ -2,11 +2,8 @@
# description: Extract month function
# group: [date]
-statement ok
-PRAGMA enable_verification
-
query II
-select date '1992-01-01' + interval (i) days, month(date '1992-01-01' + interval (i) days) from range(0, 366) tbl(i);
+select date '1992-01-01' + interval (x) days, month(date '1992-01-01' + interval (x) days) from table(system_range(0, 17));
----
1992-01-01 1
1992-01-02 1
@@ -26,357 +23,9 @@ select date '1992-01-01' + interval (i) days, month(date '1992-01-01' + interval
1992-01-16 1
1992-01-17 1
1992-01-18 1
-1992-01-19 1
-1992-01-20 1
-1992-01-21 1
-1992-01-22 1
-1992-01-23 1
-1992-01-24 1
-1992-01-25 1
-1992-01-26 1
-1992-01-27 1
-1992-01-28 1
-1992-01-29 1
-1992-01-30 1
-1992-01-31 1
-1992-02-01 2
-1992-02-02 2
-1992-02-03 2
-1992-02-04 2
-1992-02-05 2
-1992-02-06 2
-1992-02-07 2
-1992-02-08 2
-1992-02-09 2
-1992-02-10 2
-1992-02-11 2
-1992-02-12 2
-1992-02-13 2
-1992-02-14 2
-1992-02-15 2
-1992-02-16 2
-1992-02-17 2
-1992-02-18 2
-1992-02-19 2
-1992-02-20 2
-1992-02-21 2
-1992-02-22 2
-1992-02-23 2
-1992-02-24 2
-1992-02-25 2
-1992-02-26 2
-1992-02-27 2
-1992-02-28 2
-1992-02-29 2
-1992-03-01 3
-1992-03-02 3
-1992-03-03 3
-1992-03-04 3
-1992-03-05 3
-1992-03-06 3
-1992-03-07 3
-1992-03-08 3
-1992-03-09 3
-1992-03-10 3
-1992-03-11 3
-1992-03-12 3
-1992-03-13 3
-1992-03-14 3
-1992-03-15 3
-1992-03-16 3
-1992-03-17 3
-1992-03-18 3
-1992-03-19 3
-1992-03-20 3
-1992-03-21 3
-1992-03-22 3
-1992-03-23 3
-1992-03-24 3
-1992-03-25 3
-1992-03-26 3
-1992-03-27 3
-1992-03-28 3
-1992-03-29 3
-1992-03-30 3
-1992-03-31 3
-1992-04-01 4
-1992-04-02 4
-1992-04-03 4
-1992-04-04 4
-1992-04-05 4
-1992-04-06 4
-1992-04-07 4
-1992-04-08 4
-1992-04-09 4
-1992-04-10 4
-1992-04-11 4
-1992-04-12 4
-1992-04-13 4
-1992-04-14 4
-1992-04-15 4
-1992-04-16 4
-1992-04-17 4
-1992-04-18 4
-1992-04-19 4
-1992-04-20 4
-1992-04-21 4
-1992-04-22 4
-1992-04-23 4
-1992-04-24 4
-1992-04-25 4
-1992-04-26 4
-1992-04-27 4
-1992-04-28 4
-1992-04-29 4
-1992-04-30 4
-1992-05-01 5
-1992-05-02 5
-1992-05-03 5
-1992-05-04 5
-1992-05-05 5
-1992-05-06 5
-1992-05-07 5
-1992-05-08 5
-1992-05-09 5
-1992-05-10 5
-1992-05-11 5
-1992-05-12 5
-1992-05-13 5
-1992-05-14 5
-1992-05-15 5
-1992-05-16 5
-1992-05-17 5
-1992-05-18 5
-1992-05-19 5
-1992-05-20 5
-1992-05-21 5
-1992-05-22 5
-1992-05-23 5
-1992-05-24 5
-1992-05-25 5
-1992-05-26 5
-1992-05-27 5
-1992-05-28 5
-1992-05-29 5
-1992-05-30 5
-1992-05-31 5
-1992-06-01 6
-1992-06-02 6
-1992-06-03 6
-1992-06-04 6
-1992-06-05 6
-1992-06-06 6
-1992-06-07 6
-1992-06-08 6
-1992-06-09 6
-1992-06-10 6
-1992-06-11 6
-1992-06-12 6
-1992-06-13 6
-1992-06-14 6
-1992-06-15 6
-1992-06-16 6
-1992-06-17 6
-1992-06-18 6
-1992-06-19 6
-1992-06-20 6
-1992-06-21 6
-1992-06-22 6
-1992-06-23 6
-1992-06-24 6
-1992-06-25 6
-1992-06-26 6
-1992-06-27 6
-1992-06-28 6
-1992-06-29 6
-1992-06-30 6
-1992-07-01 7
-1992-07-02 7
-1992-07-03 7
-1992-07-04 7
-1992-07-05 7
-1992-07-06 7
-1992-07-07 7
-1992-07-08 7
-1992-07-09 7
-1992-07-10 7
-1992-07-11 7
-1992-07-12 7
-1992-07-13 7
-1992-07-14 7
-1992-07-15 7
-1992-07-16 7
-1992-07-17 7
-1992-07-18 7
-1992-07-19 7
-1992-07-20 7
-1992-07-21 7
-1992-07-22 7
-1992-07-23 7
-1992-07-24 7
-1992-07-25 7
-1992-07-26 7
-1992-07-27 7
-1992-07-28 7
-1992-07-29 7
-1992-07-30 7
-1992-07-31 7
-1992-08-01 8
-1992-08-02 8
-1992-08-03 8
-1992-08-04 8
-1992-08-05 8
-1992-08-06 8
-1992-08-07 8
-1992-08-08 8
-1992-08-09 8
-1992-08-10 8
-1992-08-11 8
-1992-08-12 8
-1992-08-13 8
-1992-08-14 8
-1992-08-15 8
-1992-08-16 8
-1992-08-17 8
-1992-08-18 8
-1992-08-19 8
-1992-08-20 8
-1992-08-21 8
-1992-08-22 8
-1992-08-23 8
-1992-08-24 8
-1992-08-25 8
-1992-08-26 8
-1992-08-27 8
-1992-08-28 8
-1992-08-29 8
-1992-08-30 8
-1992-08-31 8
-1992-09-01 9
-1992-09-02 9
-1992-09-03 9
-1992-09-04 9
-1992-09-05 9
-1992-09-06 9
-1992-09-07 9
-1992-09-08 9
-1992-09-09 9
-1992-09-10 9
-1992-09-11 9
-1992-09-12 9
-1992-09-13 9
-1992-09-14 9
-1992-09-15 9
-1992-09-16 9
-1992-09-17 9
-1992-09-18 9
-1992-09-19 9
-1992-09-20 9
-1992-09-21 9
-1992-09-22 9
-1992-09-23 9
-1992-09-24 9
-1992-09-25 9
-1992-09-26 9
-1992-09-27 9
-1992-09-28 9
-1992-09-29 9
-1992-09-30 9
-1992-10-01 10
-1992-10-02 10
-1992-10-03 10
-1992-10-04 10
-1992-10-05 10
-1992-10-06 10
-1992-10-07 10
-1992-10-08 10
-1992-10-09 10
-1992-10-10 10
-1992-10-11 10
-1992-10-12 10
-1992-10-13 10
-1992-10-14 10
-1992-10-15 10
-1992-10-16 10
-1992-10-17 10
-1992-10-18 10
-1992-10-19 10
-1992-10-20 10
-1992-10-21 10
-1992-10-22 10
-1992-10-23 10
-1992-10-24 10
-1992-10-25 10
-1992-10-26 10
-1992-10-27 10
-1992-10-28 10
-1992-10-29 10
-1992-10-30 10
-1992-10-31 10
-1992-11-01 11
-1992-11-02 11
-1992-11-03 11
-1992-11-04 11
-1992-11-05 11
-1992-11-06 11
-1992-11-07 11
-1992-11-08 11
-1992-11-09 11
-1992-11-10 11
-1992-11-11 11
-1992-11-12 11
-1992-11-13 11
-1992-11-14 11
-1992-11-15 11
-1992-11-16 11
-1992-11-17 11
-1992-11-18 11
-1992-11-19 11
-1992-11-20 11
-1992-11-21 11
-1992-11-22 11
-1992-11-23 11
-1992-11-24 11
-1992-11-25 11
-1992-11-26 11
-1992-11-27 11
-1992-11-28 11
-1992-11-29 11
-1992-11-30 11
-1992-12-01 12
-1992-12-02 12
-1992-12-03 12
-1992-12-04 12
-1992-12-05 12
-1992-12-06 12
-1992-12-07 12
-1992-12-08 12
-1992-12-09 12
-1992-12-10 12
-1992-12-11 12
-1992-12-12 12
-1992-12-13 12
-1992-12-14 12
-1992-12-15 12
-1992-12-16 12
-1992-12-17 12
-1992-12-18 12
-1992-12-19 12
-1992-12-20 12
-1992-12-21 12
-1992-12-22 12
-1992-12-23 12
-1992-12-24 12
-1992-12-25 12
-1992-12-26 12
-1992-12-27 12
-1992-12-28 12
-1992-12-29 12
-1992-12-30 12
-1992-12-31 12
query II
-select date '1993-01-01' + interval (i) days, month(date '1993-01-01' + interval (i) days) from range(0, 366) tbl(i);
+select date '1993-01-01' + interval (x) days, month(date '1993-01-01' + interval (x) days) from table(system_range(0, 85));
----
1993-01-01 1
1993-01-02 1
@@ -464,283 +113,3 @@ select date '1993-01-01' + interval (i) days, month(date '1993-01-01' + interval
1993-03-25 3
1993-03-26 3
1993-03-27 3
-1993-03-28 3
-1993-03-29 3
-1993-03-30 3
-1993-03-31 3
-1993-04-01 4
-1993-04-02 4
-1993-04-03 4
-1993-04-04 4
-1993-04-05 4
-1993-04-06 4
-1993-04-07 4
-1993-04-08 4
-1993-04-09 4
-1993-04-10 4
-1993-04-11 4
-1993-04-12 4
-1993-04-13 4
-1993-04-14 4
-1993-04-15 4
-1993-04-16 4
-1993-04-17 4
-1993-04-18 4
-1993-04-19 4
-1993-04-20 4
-1993-04-21 4
-1993-04-22 4
-1993-04-23 4
-1993-04-24 4
-1993-04-25 4
-1993-04-26 4
-1993-04-27 4
-1993-04-28 4
-1993-04-29 4
-1993-04-30 4
-1993-05-01 5
-1993-05-02 5
-1993-05-03 5
-1993-05-04 5
-1993-05-05 5
-1993-05-06 5
-1993-05-07 5
-1993-05-08 5
-1993-05-09 5
-1993-05-10 5
-1993-05-11 5
-1993-05-12 5
-1993-05-13 5
-1993-05-14 5
-1993-05-15 5
-1993-05-16 5
-1993-05-17 5
-1993-05-18 5
-1993-05-19 5
-1993-05-20 5
-1993-05-21 5
-1993-05-22 5
-1993-05-23 5
-1993-05-24 5
-1993-05-25 5
-1993-05-26 5
-1993-05-27 5
-1993-05-28 5
-1993-05-29 5
-1993-05-30 5
-1993-05-31 5
-1993-06-01 6
-1993-06-02 6
-1993-06-03 6
-1993-06-04 6
-1993-06-05 6
-1993-06-06 6
-1993-06-07 6
-1993-06-08 6
-1993-06-09 6
-1993-06-10 6
-1993-06-11 6
-1993-06-12 6
-1993-06-13 6
-1993-06-14 6
-1993-06-15 6
-1993-06-16 6
-1993-06-17 6
-1993-06-18 6
-1993-06-19 6
-1993-06-20 6
-1993-06-21 6
-1993-06-22 6
-1993-06-23 6
-1993-06-24 6
-1993-06-25 6
-1993-06-26 6
-1993-06-27 6
-1993-06-28 6
-1993-06-29 6
-1993-06-30 6
-1993-07-01 7
-1993-07-02 7
-1993-07-03 7
-1993-07-04 7
-1993-07-05 7
-1993-07-06 7
-1993-07-07 7
-1993-07-08 7
-1993-07-09 7
-1993-07-10 7
-1993-07-11 7
-1993-07-12 7
-1993-07-13 7
-1993-07-14 7
-1993-07-15 7
-1993-07-16 7
-1993-07-17 7
-1993-07-18 7
-1993-07-19 7
-1993-07-20 7
-1993-07-21 7
-1993-07-22 7
-1993-07-23 7
-1993-07-24 7
-1993-07-25 7
-1993-07-26 7
-1993-07-27 7
-1993-07-28 7
-1993-07-29 7
-1993-07-30 7
-1993-07-31 7
-1993-08-01 8
-1993-08-02 8
-1993-08-03 8
-1993-08-04 8
-1993-08-05 8
-1993-08-06 8
-1993-08-07 8
-1993-08-08 8
-1993-08-09 8
-1993-08-10 8
-1993-08-11 8
-1993-08-12 8
-1993-08-13 8
-1993-08-14 8
-1993-08-15 8
-1993-08-16 8
-1993-08-17 8
-1993-08-18 8
-1993-08-19 8
-1993-08-20 8
-1993-08-21 8
-1993-08-22 8
-1993-08-23 8
-1993-08-24 8
-1993-08-25 8
-1993-08-26 8
-1993-08-27 8
-1993-08-28 8
-1993-08-29 8
-1993-08-30 8
-1993-08-31 8
-1993-09-01 9
-1993-09-02 9
-1993-09-03 9
-1993-09-04 9
-1993-09-05 9
-1993-09-06 9
-1993-09-07 9
-1993-09-08 9
-1993-09-09 9
-1993-09-10 9
-1993-09-11 9
-1993-09-12 9
-1993-09-13 9
-1993-09-14 9
-1993-09-15 9
-1993-09-16 9
-1993-09-17 9
-1993-09-18 9
-1993-09-19 9
-1993-09-20 9
-1993-09-21 9
-1993-09-22 9
-1993-09-23 9
-1993-09-24 9
-1993-09-25 9
-1993-09-26 9
-1993-09-27 9
-1993-09-28 9
-1993-09-29 9
-1993-09-30 9
-1993-10-01 10
-1993-10-02 10
-1993-10-03 10
-1993-10-04 10
-1993-10-05 10
-1993-10-06 10
-1993-10-07 10
-1993-10-08 10
-1993-10-09 10
-1993-10-10 10
-1993-10-11 10
-1993-10-12 10
-1993-10-13 10
-1993-10-14 10
-1993-10-15 10
-1993-10-16 10
-1993-10-17 10
-1993-10-18 10
-1993-10-19 10
-1993-10-20 10
-1993-10-21 10
-1993-10-22 10
-1993-10-23 10
-1993-10-24 10
-1993-10-25 10
-1993-10-26 10
-1993-10-27 10
-1993-10-28 10
-1993-10-29 10
-1993-10-30 10
-1993-10-31 10
-1993-11-01 11
-1993-11-02 11
-1993-11-03 11
-1993-11-04 11
-1993-11-05 11
-1993-11-06 11
-1993-11-07 11
-1993-11-08 11
-1993-11-09 11
-1993-11-10 11
-1993-11-11 11
-1993-11-12 11
-1993-11-13 11
-1993-11-14 11
-1993-11-15 11
-1993-11-16 11
-1993-11-17 11
-1993-11-18 11
-1993-11-19 11
-1993-11-20 11
-1993-11-21 11
-1993-11-22 11
-1993-11-23 11
-1993-11-24 11
-1993-11-25 11
-1993-11-26 11
-1993-11-27 11
-1993-11-28 11
-1993-11-29 11
-1993-11-30 11
-1993-12-01 12
-1993-12-02 12
-1993-12-03 12
-1993-12-04 12
-1993-12-05 12
-1993-12-06 12
-1993-12-07 12
-1993-12-08 12
-1993-12-09 12
-1993-12-10 12
-1993-12-11 12
-1993-12-12 12
-1993-12-13 12
-1993-12-14 12
-1993-12-15 12
-1993-12-16 12
-1993-12-17 12
-1993-12-18 12
-1993-12-19 12
-1993-12-20 12
-1993-12-21 12
-1993-12-22 12
-1993-12-23 12
-1993-12-24 12
-1993-12-25 12
-1993-12-26 12
-1993-12-27 12
-1993-12-28 12
-1993-12-29 12
-1993-12-30 12
-1993-12-31 12
-1994-01-01 1
diff --git a/modules/calcite/src/test/sql/function/date/test_extract_month.test_ignore b/modules/calcite/src/test/sql/function/date/test_extract_month.test_ignore
new file mode 100644
index 0000000..43afddd
--- /dev/null
+++ b/modules/calcite/src/test/sql/function/date/test_extract_month.test_ignore
@@ -0,0 +1,753 @@
+# name: test/sql/function/date/test_extract_month.test
+# description: Extract month function
+# group: [date]
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-14963
+
+query II
+select date '1992-01-01' + interval (18) days, month(date '1992-01-01' + interval (18) days);
+----
+1992-01-18 1
+
+query II
+select date '1992-01-01' + interval (x) days, month(date '1992-01-01' + interval (x) days) from table(system_range(0, 365));
+----
+1992-01-01 1
+1992-01-02 1
+1992-01-03 1
+1992-01-04 1
+1992-01-05 1
+1992-01-06 1
+1992-01-07 1
+1992-01-08 1
+1992-01-09 1
+1992-01-10 1
+1992-01-11 1
+1992-01-12 1
+1992-01-13 1
+1992-01-14 1
+1992-01-15 1
+1992-01-16 1
+1992-01-17 1
+1992-01-18 1
+1992-01-19 1
+1992-01-20 1
+1992-01-21 1
+1992-01-22 1
+1992-01-23 1
+1992-01-24 1
+1992-01-25 1
+1992-01-26 1
+1992-01-27 1
+1992-01-28 1
+1992-01-29 1
+1992-01-30 1
+1992-01-31 1
+1992-02-01 2
+1992-02-02 2
+1992-02-03 2
+1992-02-04 2
+1992-02-05 2
+1992-02-06 2
+1992-02-07 2
+1992-02-08 2
+1992-02-09 2
+1992-02-10 2
+1992-02-11 2
+1992-02-12 2
+1992-02-13 2
+1992-02-14 2
+1992-02-15 2
+1992-02-16 2
+1992-02-17 2
+1992-02-18 2
+1992-02-19 2
+1992-02-20 2
+1992-02-21 2
+1992-02-22 2
+1992-02-23 2
+1992-02-24 2
+1992-02-25 2
+1992-02-26 2
+1992-02-27 2
+1992-02-28 2
+1992-02-29 2
+1992-03-01 3
+1992-03-02 3
+1992-03-03 3
+1992-03-04 3
+1992-03-05 3
+1992-03-06 3
+1992-03-07 3
+1992-03-08 3
+1992-03-09 3
+1992-03-10 3
+1992-03-11 3
+1992-03-12 3
+1992-03-13 3
+1992-03-14 3
+1992-03-15 3
+1992-03-16 3
+1992-03-17 3
+1992-03-18 3
+1992-03-19 3
+1992-03-20 3
+1992-03-21 3
+1992-03-22 3
+1992-03-23 3
+1992-03-24 3
+1992-03-25 3
+1992-03-26 3
+1992-03-27 3
+1992-03-28 3
+1992-03-29 3
+1992-03-30 3
+1992-03-31 3
+1992-04-01 4
+1992-04-02 4
+1992-04-03 4
+1992-04-04 4
+1992-04-05 4
+1992-04-06 4
+1992-04-07 4
+1992-04-08 4
+1992-04-09 4
+1992-04-10 4
+1992-04-11 4
+1992-04-12 4
+1992-04-13 4
+1992-04-14 4
+1992-04-15 4
+1992-04-16 4
+1992-04-17 4
+1992-04-18 4
+1992-04-19 4
+1992-04-20 4
+1992-04-21 4
+1992-04-22 4
+1992-04-23 4
+1992-04-24 4
+1992-04-25 4
+1992-04-26 4
+1992-04-27 4
+1992-04-28 4
+1992-04-29 4
+1992-04-30 4
+1992-05-01 5
+1992-05-02 5
+1992-05-03 5
+1992-05-04 5
+1992-05-05 5
+1992-05-06 5
+1992-05-07 5
+1992-05-08 5
+1992-05-09 5
+1992-05-10 5
+1992-05-11 5
+1992-05-12 5
+1992-05-13 5
+1992-05-14 5
+1992-05-15 5
+1992-05-16 5
+1992-05-17 5
+1992-05-18 5
+1992-05-19 5
+1992-05-20 5
+1992-05-21 5
+1992-05-22 5
+1992-05-23 5
+1992-05-24 5
+1992-05-25 5
+1992-05-26 5
+1992-05-27 5
+1992-05-28 5
+1992-05-29 5
+1992-05-30 5
+1992-05-31 5
+1992-06-01 6
+1992-06-02 6
+1992-06-03 6
+1992-06-04 6
+1992-06-05 6
+1992-06-06 6
+1992-06-07 6
+1992-06-08 6
+1992-06-09 6
+1992-06-10 6
+1992-06-11 6
+1992-06-12 6
+1992-06-13 6
+1992-06-14 6
+1992-06-15 6
+1992-06-16 6
+1992-06-17 6
+1992-06-18 6
+1992-06-19 6
+1992-06-20 6
+1992-06-21 6
+1992-06-22 6
+1992-06-23 6
+1992-06-24 6
+1992-06-25 6
+1992-06-26 6
+1992-06-27 6
+1992-06-28 6
+1992-06-29 6
+1992-06-30 6
+1992-07-01 7
+1992-07-02 7
+1992-07-03 7
+1992-07-04 7
+1992-07-05 7
+1992-07-06 7
+1992-07-07 7
+1992-07-08 7
+1992-07-09 7
+1992-07-10 7
+1992-07-11 7
+1992-07-12 7
+1992-07-13 7
+1992-07-14 7
+1992-07-15 7
+1992-07-16 7
+1992-07-17 7
+1992-07-18 7
+1992-07-19 7
+1992-07-20 7
+1992-07-21 7
+1992-07-22 7
+1992-07-23 7
+1992-07-24 7
+1992-07-25 7
+1992-07-26 7
+1992-07-27 7
+1992-07-28 7
+1992-07-29 7
+1992-07-30 7
+1992-07-31 7
+1992-08-01 8
+1992-08-02 8
+1992-08-03 8
+1992-08-04 8
+1992-08-05 8
+1992-08-06 8
+1992-08-07 8
+1992-08-08 8
+1992-08-09 8
+1992-08-10 8
+1992-08-11 8
+1992-08-12 8
+1992-08-13 8
+1992-08-14 8
+1992-08-15 8
+1992-08-16 8
+1992-08-17 8
+1992-08-18 8
+1992-08-19 8
+1992-08-20 8
+1992-08-21 8
+1992-08-22 8
+1992-08-23 8
+1992-08-24 8
+1992-08-25 8
+1992-08-26 8
+1992-08-27 8
+1992-08-28 8
+1992-08-29 8
+1992-08-30 8
+1992-08-31 8
+1992-09-01 9
+1992-09-02 9
+1992-09-03 9
+1992-09-04 9
+1992-09-05 9
+1992-09-06 9
+1992-09-07 9
+1992-09-08 9
+1992-09-09 9
+1992-09-10 9
+1992-09-11 9
+1992-09-12 9
+1992-09-13 9
+1992-09-14 9
+1992-09-15 9
+1992-09-16 9
+1992-09-17 9
+1992-09-18 9
+1992-09-19 9
+1992-09-20 9
+1992-09-21 9
+1992-09-22 9
+1992-09-23 9
+1992-09-24 9
+1992-09-25 9
+1992-09-26 9
+1992-09-27 9
+1992-09-28 9
+1992-09-29 9
+1992-09-30 9
+1992-10-01 10
+1992-10-02 10
+1992-10-03 10
+1992-10-04 10
+1992-10-05 10
+1992-10-06 10
+1992-10-07 10
+1992-10-08 10
+1992-10-09 10
+1992-10-10 10
+1992-10-11 10
+1992-10-12 10
+1992-10-13 10
+1992-10-14 10
+1992-10-15 10
+1992-10-16 10
+1992-10-17 10
+1992-10-18 10
+1992-10-19 10
+1992-10-20 10
+1992-10-21 10
+1992-10-22 10
+1992-10-23 10
+1992-10-24 10
+1992-10-25 10
+1992-10-26 10
+1992-10-27 10
+1992-10-28 10
+1992-10-29 10
+1992-10-30 10
+1992-10-31 10
+1992-11-01 11
+1992-11-02 11
+1992-11-03 11
+1992-11-04 11
+1992-11-05 11
+1992-11-06 11
+1992-11-07 11
+1992-11-08 11
+1992-11-09 11
+1992-11-10 11
+1992-11-11 11
+1992-11-12 11
+1992-11-13 11
+1992-11-14 11
+1992-11-15 11
+1992-11-16 11
+1992-11-17 11
+1992-11-18 11
+1992-11-19 11
+1992-11-20 11
+1992-11-21 11
+1992-11-22 11
+1992-11-23 11
+1992-11-24 11
+1992-11-25 11
+1992-11-26 11
+1992-11-27 11
+1992-11-28 11
+1992-11-29 11
+1992-11-30 11
+1992-12-01 12
+1992-12-02 12
+1992-12-03 12
+1992-12-04 12
+1992-12-05 12
+1992-12-06 12
+1992-12-07 12
+1992-12-08 12
+1992-12-09 12
+1992-12-10 12
+1992-12-11 12
+1992-12-12 12
+1992-12-13 12
+1992-12-14 12
+1992-12-15 12
+1992-12-16 12
+1992-12-17 12
+1992-12-18 12
+1992-12-19 12
+1992-12-20 12
+1992-12-21 12
+1992-12-22 12
+1992-12-23 12
+1992-12-24 12
+1992-12-25 12
+1992-12-26 12
+1992-12-27 12
+1992-12-28 12
+1992-12-29 12
+1992-12-30 12
+1992-12-31 12
+
+query II
+select date '1993-01-01' + interval (i) days, month(date '1993-01-01' + interval (i) days) from range(0, 366) tbl(i);
+----
+1993-01-01 1
+1993-01-02 1
+1993-01-03 1
+1993-01-04 1
+1993-01-05 1
+1993-01-06 1
+1993-01-07 1
+1993-01-08 1
+1993-01-09 1
+1993-01-10 1
+1993-01-11 1
+1993-01-12 1
+1993-01-13 1
+1993-01-14 1
+1993-01-15 1
+1993-01-16 1
+1993-01-17 1
+1993-01-18 1
+1993-01-19 1
+1993-01-20 1
+1993-01-21 1
+1993-01-22 1
+1993-01-23 1
+1993-01-24 1
+1993-01-25 1
+1993-01-26 1
+1993-01-27 1
+1993-01-28 1
+1993-01-29 1
+1993-01-30 1
+1993-01-31 1
+1993-02-01 2
+1993-02-02 2
+1993-02-03 2
+1993-02-04 2
+1993-02-05 2
+1993-02-06 2
+1993-02-07 2
+1993-02-08 2
+1993-02-09 2
+1993-02-10 2
+1993-02-11 2
+1993-02-12 2
+1993-02-13 2
+1993-02-14 2
+1993-02-15 2
+1993-02-16 2
+1993-02-17 2
+1993-02-18 2
+1993-02-19 2
+1993-02-20 2
+1993-02-21 2
+1993-02-22 2
+1993-02-23 2
+1993-02-24 2
+1993-02-25 2
+1993-02-26 2
+1993-02-27 2
+1993-02-28 2
+1993-03-01 3
+1993-03-02 3
+1993-03-03 3
+1993-03-04 3
+1993-03-05 3
+1993-03-06 3
+1993-03-07 3
+1993-03-08 3
+1993-03-09 3
+1993-03-10 3
+1993-03-11 3
+1993-03-12 3
+1993-03-13 3
+1993-03-14 3
+1993-03-15 3
+1993-03-16 3
+1993-03-17 3
+1993-03-18 3
+1993-03-19 3
+1993-03-20 3
+1993-03-21 3
+1993-03-22 3
+1993-03-23 3
+1993-03-24 3
+1993-03-25 3
+1993-03-26 3
+1993-03-27 3
+1993-03-28 3
+1993-03-29 3
+1993-03-30 3
+1993-03-31 3
+1993-04-01 4
+1993-04-02 4
+1993-04-03 4
+1993-04-04 4
+1993-04-05 4
+1993-04-06 4
+1993-04-07 4
+1993-04-08 4
+1993-04-09 4
+1993-04-10 4
+1993-04-11 4
+1993-04-12 4
+1993-04-13 4
+1993-04-14 4
+1993-04-15 4
+1993-04-16 4
+1993-04-17 4
+1993-04-18 4
+1993-04-19 4
+1993-04-20 4
+1993-04-21 4
+1993-04-22 4
+1993-04-23 4
+1993-04-24 4
+1993-04-25 4
+1993-04-26 4
+1993-04-27 4
+1993-04-28 4
+1993-04-29 4
+1993-04-30 4
+1993-05-01 5
+1993-05-02 5
+1993-05-03 5
+1993-05-04 5
+1993-05-05 5
+1993-05-06 5
+1993-05-07 5
+1993-05-08 5
+1993-05-09 5
+1993-05-10 5
+1993-05-11 5
+1993-05-12 5
+1993-05-13 5
+1993-05-14 5
+1993-05-15 5
+1993-05-16 5
+1993-05-17 5
+1993-05-18 5
+1993-05-19 5
+1993-05-20 5
+1993-05-21 5
+1993-05-22 5
+1993-05-23 5
+1993-05-24 5
+1993-05-25 5
+1993-05-26 5
+1993-05-27 5
+1993-05-28 5
+1993-05-29 5
+1993-05-30 5
+1993-05-31 5
+1993-06-01 6
+1993-06-02 6
+1993-06-03 6
+1993-06-04 6
+1993-06-05 6
+1993-06-06 6
+1993-06-07 6
+1993-06-08 6
+1993-06-09 6
+1993-06-10 6
+1993-06-11 6
+1993-06-12 6
+1993-06-13 6
+1993-06-14 6
+1993-06-15 6
+1993-06-16 6
+1993-06-17 6
+1993-06-18 6
+1993-06-19 6
+1993-06-20 6
+1993-06-21 6
+1993-06-22 6
+1993-06-23 6
+1993-06-24 6
+1993-06-25 6
+1993-06-26 6
+1993-06-27 6
+1993-06-28 6
+1993-06-29 6
+1993-06-30 6
+1993-07-01 7
+1993-07-02 7
+1993-07-03 7
+1993-07-04 7
+1993-07-05 7
+1993-07-06 7
+1993-07-07 7
+1993-07-08 7
+1993-07-09 7
+1993-07-10 7
+1993-07-11 7
+1993-07-12 7
+1993-07-13 7
+1993-07-14 7
+1993-07-15 7
+1993-07-16 7
+1993-07-17 7
+1993-07-18 7
+1993-07-19 7
+1993-07-20 7
+1993-07-21 7
+1993-07-22 7
+1993-07-23 7
+1993-07-24 7
+1993-07-25 7
+1993-07-26 7
+1993-07-27 7
+1993-07-28 7
+1993-07-29 7
+1993-07-30 7
+1993-07-31 7
+1993-08-01 8
+1993-08-02 8
+1993-08-03 8
+1993-08-04 8
+1993-08-05 8
+1993-08-06 8
+1993-08-07 8
+1993-08-08 8
+1993-08-09 8
+1993-08-10 8
+1993-08-11 8
+1993-08-12 8
+1993-08-13 8
+1993-08-14 8
+1993-08-15 8
+1993-08-16 8
+1993-08-17 8
+1993-08-18 8
+1993-08-19 8
+1993-08-20 8
+1993-08-21 8
+1993-08-22 8
+1993-08-23 8
+1993-08-24 8
+1993-08-25 8
+1993-08-26 8
+1993-08-27 8
+1993-08-28 8
+1993-08-29 8
+1993-08-30 8
+1993-08-31 8
+1993-09-01 9
+1993-09-02 9
+1993-09-03 9
+1993-09-04 9
+1993-09-05 9
+1993-09-06 9
+1993-09-07 9
+1993-09-08 9
+1993-09-09 9
+1993-09-10 9
+1993-09-11 9
+1993-09-12 9
+1993-09-13 9
+1993-09-14 9
+1993-09-15 9
+1993-09-16 9
+1993-09-17 9
+1993-09-18 9
+1993-09-19 9
+1993-09-20 9
+1993-09-21 9
+1993-09-22 9
+1993-09-23 9
+1993-09-24 9
+1993-09-25 9
+1993-09-26 9
+1993-09-27 9
+1993-09-28 9
+1993-09-29 9
+1993-09-30 9
+1993-10-01 10
+1993-10-02 10
+1993-10-03 10
+1993-10-04 10
+1993-10-05 10
+1993-10-06 10
+1993-10-07 10
+1993-10-08 10
+1993-10-09 10
+1993-10-10 10
+1993-10-11 10
+1993-10-12 10
+1993-10-13 10
+1993-10-14 10
+1993-10-15 10
+1993-10-16 10
+1993-10-17 10
+1993-10-18 10
+1993-10-19 10
+1993-10-20 10
+1993-10-21 10
+1993-10-22 10
+1993-10-23 10
+1993-10-24 10
+1993-10-25 10
+1993-10-26 10
+1993-10-27 10
+1993-10-28 10
+1993-10-29 10
+1993-10-30 10
+1993-10-31 10
+1993-11-01 11
+1993-11-02 11
+1993-11-03 11
+1993-11-04 11
+1993-11-05 11
+1993-11-06 11
+1993-11-07 11
+1993-11-08 11
+1993-11-09 11
+1993-11-10 11
+1993-11-11 11
+1993-11-12 11
+1993-11-13 11
+1993-11-14 11
+1993-11-15 11
+1993-11-16 11
+1993-11-17 11
+1993-11-18 11
+1993-11-19 11
+1993-11-20 11
+1993-11-21 11
+1993-11-22 11
+1993-11-23 11
+1993-11-24 11
+1993-11-25 11
+1993-11-26 11
+1993-11-27 11
+1993-11-28 11
+1993-11-29 11
+1993-11-30 11
+1993-12-01 12
+1993-12-02 12
+1993-12-03 12
+1993-12-04 12
+1993-12-05 12
+1993-12-06 12
+1993-12-07 12
+1993-12-08 12
+1993-12-09 12
+1993-12-10 12
+1993-12-11 12
+1993-12-12 12
+1993-12-13 12
+1993-12-14 12
+1993-12-15 12
+1993-12-16 12
+1993-12-17 12
+1993-12-18 12
+1993-12-19 12
+1993-12-20 12
+1993-12-21 12
+1993-12-22 12
+1993-12-23 12
+1993-12-24 12
+1993-12-25 12
+1993-12-26 12
+1993-12-27 12
+1993-12-28 12
+1993-12-29 12
+1993-12-30 12
+1993-12-31 12
+1994-01-01 1
+
+
+[expected=[[1992-01-01, 1], [1992-01-02, 1], [1992-01-03, 1], [1992-01-04, 1], [1992-01-05, 1], [1992-01-06, 1], [1992-01-07, 1], [1992-01-08, 1], [1992-01-09, 1], [1992-01-10, 1], [1992-01-11, 1], [1992-01-12, 1], [1992-01-13, 1], [1992-01-14, 1], [1992-01-15, 1], [1992-01-16, 1], [1992-01-17, 1], [1992-01-18, 1], [1992-01-19, 1], [1992-01-20, 1], [1992-01-21, 1], [1992-01-22, 1], [1992-01-23, 1], [1992-01-24, 1], [1992-01-25, 1], [1992-01-26, 1], [1992-01-27, 1], [1992-01-28, 1], [1992 [...]
+actual=[[1992-01-01, 1], [1992-01-02, 1], [1992-01-03, 1], [1992-01-04, 1], [1992-01-05, 1], [1992-01-06, 1], [1992-01-07, 1], [1992-01-08, 1], [1992-01-09, 1], [1992-01-10, 1], [1992-01-11, 1], [1992-01-12, 1], [1992-01-13, 1], [1992-01-14, 1], [1992-01-15, 1], [1992-01-16, 1], [1992-01-17, 1], [1992-01-18, 1], [1992-01-18, 1], [1992-01-20, 1], [1992-01-21, 1], [1992-01-22, 1], [1992-01-23, 1], [1992-01-24, 1], [1992-01-25, 1], [1992-01-26, 1], [1992-01-27, 1], [1992-01-28, 1], [1992-01 [...]
\ No newline at end of file
diff --git a/modules/calcite/src/test/sql/function/date/test_extract_year.test b/modules/calcite/src/test/sql/function/date/test_extract_year.test
index c2b48e9..40bc363 100644
--- a/modules/calcite/src/test/sql/function/date/test_extract_year.test
+++ b/modules/calcite/src/test/sql/function/date/test_extract_year.test
@@ -3,13 +3,16 @@
# group: [date]
statement ok
-PRAGMA enable_verification
+CREATE TABLE dates (d DATE);
statement ok
-CREATE TABLE dates AS SELECT date '1970-01-01' + concat(i, ' years')::interval AS d from range(0, 430) tbl(i);
+CREATE TABLE dates2 (d DATE);
statement ok
-CREATE TABLE dates2 AS SELECT date '1970-01-01' + concat(i * 6, ' months')::interval AS d from range(0, 200) tbl(i);
+INSERT INTO dates SELECT date '1970-01-01' + INTERVAL(x) years AS d from table(system_range(0, 429));
+
+statement ok
+INSERT INTO dates2 SELECT date '1970-01-01' + INTERVAL(x * 6) months AS d from table(system_range(0, 199));
query I
SELECT EXTRACT(year FROM d) FROM dates ORDER BY 1
diff --git a/modules/calcite/src/test/sql/function/date/test_strftime.test b/modules/calcite/src/test/sql/function/date/test_strftime.test
deleted file mode 100644
index 9d6977e..0000000
--- a/modules/calcite/src/test/sql/function/date/test_strftime.test
+++ /dev/null
@@ -1,101 +0,0 @@
-# name: test/sql/function/date/test_strftime.test
-# description: Test strftime function
-# group: [date]
-
-statement ok
-PRAGMA enable_verification
-
-# simple single specifier
-query I
-SELECT strftime(DATE '1992-01-01', '%Y');
-----
-1992
-
-# some literals
-query I
-SELECT strftime(DATE '1992-01-01', '(%Y)');
-----
-(1992)
-
-# escapes
-query I
-SELECT strftime(DATE '1992-01-01', '%% %Y %%');
-----
-% 1992 %
-
-# many consecutive escapes
-query I
-SELECT strftime(DATE '1992-01-01', '%%%%%% %Y %%%%%%');
-----
-%%% 1992 %%%
-
-# multiple specifiers
-query I
-SELECT strftime(DATE '1992-02-01', '%d/%m/%Y');
-----
-01/02/1992
-
-# we can repeat the same specifier many times
-query I
-SELECT strftime(DATE '1992-02-01', '%Y %Y %Y %Y');
-----
-1992 1992 1992 1992
-
-# test on a table
-statement ok
-CREATE TABLE dates(d DATE);
-INSERT INTO dates VALUES ('1992-01-01'), ('1993-03-20'), (NULL);
-
-query I
-SELECT strftime(d, '%d/%m/%Y') FROM dates ORDER BY d;
-----
-NULL
-01/01/1992
-20/03/1993
-
-# null date
-query I
-SELECT strftime(NULL::DATE, '%d/%m/%Y') FROM dates ORDER BY d;
-----
-NULL
-NULL
-NULL
-
-# null format
-query I
-SELECT strftime(d, NULL) FROM dates ORDER BY d;
-----
-NULL
-NULL
-NULL
-
-# no specifiers, only constant
-query I
-SELECT strftime(DATE '1992-01-01', 'hello world');
-----
-hello world
-
-# non-constant format not supported
-statement error
-SELECT strftime(d, d::VARCHAR) FROM dates ORDER BY d;
-
-# unterminated escape
-statement error
-SELECT strftime(DATE '1992-01-01', '%');
-
-# unrecognized code
-statement error
-SELECT strftime(DATE '1992-01-01', '%R');
-
-# millisecond specifier %g
-query IIII
-select strftime(strptime('023', '%g'), '%g'), strftime(strptime('0', '%g'), '%g'), strftime(strptime('000', '%g'), '%g'), strftime(strptime('999', '%g'), '%g');
-----
-023
-000
-000
-999
-
-statement error
-SELECT strptime('-1', '%g');
-SELECT strptime('1000', '%g');
\ No newline at end of file
diff --git a/modules/calcite/src/test/sql/function/date/test_strftime_exhaustive.test b/modules/calcite/src/test/sql/function/date/test_strftime_exhaustive.test
deleted file mode 100644
index ed09172..0000000
--- a/modules/calcite/src/test/sql/function/date/test_strftime_exhaustive.test
+++ /dev/null
@@ -1,354 +0,0 @@
-# name: test/sql/function/date/test_strftime_exhaustive.test
-# description: Test all strftime % codes with the date type
-# group: [date]
-
-statement ok
-PRAGMA enable_verification
-
-statement ok
-CREATE TABLE dates(d DATE);
-INSERT INTO dates VALUES ('1992-01-01'), ('1993-03-20'), ('2020-08-09'), ('2020-08-10'), (NULL);
-
-# %a: Abbreviated weekday name
-query I
-SELECT strftime(d, '%a') FROM dates ORDER BY d;
-----
-NULL
-Wed
-Sat
-Sun
-Mon
-
-# %A: Full weekday name
-query I
-SELECT strftime(d, '%A') FROM dates ORDER BY d;
-----
-NULL
-Wednesday
-Saturday
-Sunday
-Monday
-
-# %w - Weekday as a decimal number.
-query I
-SELECT strftime(d, '%w') FROM dates ORDER BY d;
-----
-NULL
-3
-6
-0
-1
-
-# %d - Day of the month as a zero-padded decimal.
-query I
-SELECT strftime(d, '%d') FROM dates ORDER BY d;
-----
-NULL
-01
-20
-09
-10
-
-# %-d - Day of the month as a decimal number.
-query I
-SELECT strftime(d, '%-d') FROM dates ORDER BY d;
-----
-NULL
-1
-20
-9
-10
-
-# %b - Abbreviated month name.
-query I
-SELECT strftime(d, '%b') FROM dates ORDER BY d;
-----
-NULL
-Jan
-Mar
-Aug
-Aug
-
-# %h - alias for %b
-query I
-SELECT strftime(d, '%h') FROM dates ORDER BY d;
-----
-NULL
-Jan
-Mar
-Aug
-Aug
-
-# %B - Full month name
-query I
-SELECT strftime(d, '%B') FROM dates ORDER BY d;
-----
-NULL
-January
-March
-August
-August
-
-# %m - Month as a zero-padded decimal number
-query I
-SELECT strftime(d, '%m') FROM dates ORDER BY d;
-----
-NULL
-01
-03
-08
-08
-
-# %-m - Month as a decimal number. (1, 2, ..., 12)
-query I
-SELECT strftime(d, '%-m') FROM dates ORDER BY d;
-----
-NULL
-1
-3
-8
-8
-
-# %y - Year without century as a zero-padded decimal number.
-query I
-SELECT strftime(d, '%y') FROM dates ORDER BY d;
-----
-NULL
-92
-93
-20
-20
-
-# %-y - Year without century as a decimal number.
-query I
-SELECT strftime(d, '%-y') FROM dates ORDER BY d;
-----
-NULL
-92
-93
-20
-20
-
-query I
-SELECT strftime(DATE '2001-01-01', '%-y')
-----
-1
-
-# %Y - Year with century as a decimal number.
-query I
-SELECT strftime(d, '%Y') FROM dates ORDER BY d;
-----
-NULL
-1992
-1993
-2020
-2020
-
-# %H - Hour (24-hour clock) as a zero-padded decimal number.
-query I
-SELECT strftime(d, '%H') FROM dates ORDER BY d;
-----
-NULL
-00
-00
-00
-00
-
-# %-H - Hour (24-hour clock) as a decimal number. (0, 1, ..., 23)
-query I
-SELECT strftime(d, '%-H') FROM dates ORDER BY d;
-----
-NULL
-0
-0
-0
-0
-
-# %I - Hour (12-hour clock) as a zero-padded decimal number.
-query I
-SELECT strftime(d, '%I') FROM dates ORDER BY d;
-----
-NULL
-12
-12
-12
-12
-
-# %-I - Hour (12-hour clock) as a decimal number. (1, 2, ... 12)
-query I
-SELECT strftime(d, '%-I') FROM dates ORDER BY d;
-----
-NULL
-12
-12
-12
-12
-
-# %p - Locale’s AM or PM.
-query I
-SELECT strftime(d, '%p') FROM dates ORDER BY d;
-----
-NULL
-AM
-AM
-AM
-AM
-
-# %M - Minute as a zero-padded decimal number.
-query I
-SELECT strftime(d, '%M') FROM dates ORDER BY d;
-----
-NULL
-00
-00
-00
-00
-
-# %-M - Minute as a decimal number. (0, 1, ..., 59)
-query I
-SELECT strftime(d, '%-M') FROM dates ORDER BY d;
-----
-NULL
-0
-0
-0
-0
-
-# %S - Second as a zero-padded decimal number.
-query I
-SELECT strftime(d, '%S') FROM dates ORDER BY d;
-----
-NULL
-00
-00
-00
-00
-
-# %-S - Second as a decimal number. (0, 1, ..., 59)
-query I
-SELECT strftime(d, '%-S') FROM dates ORDER BY d;
-----
-NULL
-0
-0
-0
-0
-
-# %f - Microsecond as a decimal number, zero-padded on the left.
-query I
-SELECT strftime(d, '%f') FROM dates ORDER BY d;
-----
-NULL
-000000
-000000
-000000
-000000
-
-# %z - UTC offset in the form +HHMM or -HHMM.
-query I
-SELECT strftime(d, '%z') FROM dates ORDER BY d;
-----
-NULL
-(empty)
-(empty)
-(empty)
-(empty)
-
-# %Z - Time zone name.
-query I
-SELECT strftime(d, '%Z') FROM dates ORDER BY d;
-----
-NULL
-(empty)
-(empty)
-(empty)
-(empty)
-
-# %j - Day of the year as a zero-padded decimal number.
-query I
-SELECT strftime(d, '%j') FROM dates ORDER BY d;
-----
-NULL
-001
-079
-222
-223
-
-# %-j - Day of the year as a decimal number. (1, 2, ..., 366)
-query I
-SELECT strftime(d, '%-j') FROM dates ORDER BY d;
-----
-NULL
-1
-79
-222
-223
-
-# %U - Week number of the year (Sunday as the first day of the week).
-query I
-SELECT strftime(d, '%U') FROM dates ORDER BY d;
-----
-NULL
-00
-11
-32
-32
-
-# %W - Week number of the year (Monday as the first day of the week).
-query I
-SELECT strftime(d, '%W') FROM dates ORDER BY d;
-----
-NULL
-00
-11
-31
-32
-
-# %c - Locale’s appropriate date and time representation.
-query I
-SELECT strftime(d, '%c') FROM dates ORDER BY d;
-----
-NULL
-1992-01-01 00:00:00
-1993-03-20 00:00:00
-2020-08-09 00:00:00
-2020-08-10 00:00:00
-
-query I
-SELECT strftime(d, 'XX%cXX') FROM dates ORDER BY d;
-----
-NULL
-XX1992-01-01 00:00:00XX
-XX1993-03-20 00:00:00XX
-XX2020-08-09 00:00:00XX
-XX2020-08-10 00:00:00XX
-
-# %x - Locale’s appropriate date representation.
-query I
-SELECT strftime(d, '%x') FROM dates ORDER BY d;
-----
-NULL
-1992-01-01
-1993-03-20
-2020-08-09
-2020-08-10
-
-# X - Locale’s appropriate time representation.
-query I
-SELECT strftime(d, '%X') FROM dates ORDER BY d;
-----
-NULL
-00:00:00
-00:00:00
-00:00:00
-00:00:00
-
-
-query I
-SELECT strftime(d, 'XX%cXX%xXX%XXX') FROM dates ORDER BY d;
-----
-NULL
-XX1992-01-01 00:00:00XX1992-01-01XX00:00:00XX
-XX1993-03-20 00:00:00XX1993-03-20XX00:00:00XX
-XX2020-08-09 00:00:00XX2020-08-09XX00:00:00XX
-XX2020-08-10 00:00:00XX2020-08-10XX00:00:00XX