This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 91ef75352cf [regression-test](functions) Add some date functions cases
of docs (#55839)
91ef75352cf is described below
commit 91ef75352cfcba183fc28352eb096a5a9980951b
Author: dwdwqfwe <[email protected]>
AuthorDate: Tue Sep 16 19:12:28 2025 +0800
[regression-test](functions) Add some date functions cases of docs (#55839)
---
.../sql-manual/sql-functions/date_functions.out | Bin 0 -> 17973 bytes
.../sql-manual/sql-functions/date_functions.groovy | 1584 ++++++++++++++++++++
2 files changed, 1584 insertions(+)
diff --git
a/regression-test/data/doc/sql-manual/sql-functions/date_functions.out
b/regression-test/data/doc/sql-manual/sql-functions/date_functions.out
new file mode 100644
index 00000000000..a0cdb47aaae
Binary files /dev/null and
b/regression-test/data/doc/sql-manual/sql-functions/date_functions.out differ
diff --git
a/regression-test/suites/doc/sql-manual/sql-functions/date_functions.groovy
b/regression-test/suites/doc/sql-manual/sql-functions/date_functions.groovy
new file mode 100644
index 00000000000..60876b3c05e
--- /dev/null
+++ b/regression-test/suites/doc/sql-manual/sql-functions/date_functions.groovy
@@ -0,0 +1,1584 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("doc_date_functions_test") {
+
+ // Test Group 1: Basic Date Functions (序号 1-12)
+
+ // 1. CONVERT_TZ function tests
+ // 中国上海时间转换到美国洛杉矶
+ qt_convert_tz_1 """select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS
DATETIME), 'Asia/Shanghai', 'America/Los_Angeles')"""
+
+ // 将东八区（+08:00）的时间转换为美国洛杉矶
+ qt_convert_tz_2 """select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS
DATETIME), '+08:00', 'America/Los_Angeles')"""
+
+ // 输入为date类型，时间部分自动转换为 00:00:00
+ qt_convert_tz_3 """select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATE),
'Asia/Shanghai', 'America/Los_Angeles')"""
+
+ // 转换时间为NULL,输出NULL
+ qt_convert_tz_4 """select CONVERT_TZ(NULL, 'Asia/Shanghai',
'America/New_York')"""
+
+ // 任一时区为NULL，返回NULL
+ qt_convert_tz_5 """select CONVERT_TZ('2019-08-01 13:21:03', NULL,
'America/Los_Angeles')"""
+ qt_convert_tz_6 """select CONVERT_TZ('2019-08-01 13:21:03', '+08:00',
NULL)"""
+
+ // 任一时区无效，返回NULL
+ qt_convert_tz_7 """SELECT CONVERT_TZ('2038-01-19
03:14:07','GMTaa','MET')"""
+
+ // 带有 scale 的时间
+ qt_convert_tz_8 """select CONVERT_TZ('2019-08-01 13:21:03.636', '+08:00',
'America/Los_Angeles')"""
+
+ // 时区范围为 [-12:00,14:00],超出此范围返回 NULL
+ qt_convert_tz_9 """select CONVERT_TZ('2019-08-01 13:21:03', '+08:00',
'+15:00')"""
+
+
+ // 5. DATE_ADD function tests
+ // 添加天数
+ qt_date_add_1 """select date_add(cast('2010-11-30 23:59:59' as datetime),
INTERVAL 2 DAY)"""
+
+ // 添加季度
+ qt_date_add_2 """select DATE_ADD(cast('2023-01-01' as date), INTERVAL 1
QUARTER)"""
+
+ // 添加周数
+ qt_date_add_3 """select DATE_ADD('2023-01-01', INTERVAL 1 WEEK)"""
+
+ // 添加月数,因为2023年2月只有28天，所以1月31加一个月返回2月28
+ qt_date_add_4 """select DATE_ADD('2023-01-31', INTERVAL 1 MONTH)"""
+
+ // 负数测试
+ qt_date_add_5 """select DATE_ADD('2019-01-01', INTERVAL -3 DAY)"""
+
+ // 跨年的小时增加
+ qt_date_add_6 """select DATE_ADD('2023-12-31 23:00:00', INTERVAL 2 HOUR)"""
+
+ // 参数为NULL,返回NULL
+ qt_date_add_7 """select DATE_ADD(NULL, INTERVAL 1 MONTH)"""
+
+ // 6. DATE_CEIL function tests
+ // 秒数按五秒向上取整
+ qt_date_ceil_1 """select date_ceil(cast('2023-07-13 22:28:18' as
datetime),interval 5 second)"""
+
+ // 带有 scale 的日期时间参数
+ qt_date_ceil_2 """select date_ceil(cast('2023-07-13 22:28:18.123' as
datetime(3)),interval 5 second)"""
+
+ // 按五分钟向上取整
+ qt_date_ceil_3 """select date_ceil('2023-07-13 22:28:18',interval 5
minute)"""
+
+ // 按五周向上取整
+ qt_date_ceil_4 """select date_ceil('2023-07-13 22:28:18',interval 5
WEEK)"""
+
+ // 按五小时向上取整
+ qt_date_ceil_5 """select date_ceil('2023-07-13 22:28:18',interval 5
hour)"""
+
+ // 按五天向上取整
+ qt_date_ceil_6 """select date_ceil('2023-07-13 22:28:18',interval 5 day)"""
+
+ // 按五个月向上取整
+ qt_date_ceil_7 """select date_ceil('2023-07-13 22:28:18',interval 5
month)"""
+
+ // 按五年向上取整
+ qt_date_ceil_8 """select date_ceil('2023-07-13 22:28:18',interval 5
year)"""
+
+ // 任一参数为 NULL
+ qt_date_ceil_9 """select date_ceil('9900-07-13',interval NULL year)"""
+ qt_date_ceil_10 """select date_ceil(NULL,interval 5 year)"""
+
+ // 7. DATEDIFF function tests
+ // 两个日期相差1天（忽略时间部分）
+ qt_datediff_1 """select datediff(CAST('2007-12-31 23:59:59' AS DATETIME),
CAST('2007-12-30' AS DATETIME))"""
+
+ // 前一个日期早于后一个日期，返回负数
+ qt_datediff_2 """select datediff(CAST('2010-11-30 23:59:59' AS DATETIME),
CAST('2010-12-31' AS DATETIME))"""
+
+ // 任一参数为 NULL
+ qt_datediff_3 """select datediff('2023-01-01', NULL)"""
+
+ // 若输入 datetime 类型，会忽略时间部分
+ qt_datediff_4 """select datediff('2023-01-02 13:00:00', '2023-01-01
12:00:00')"""
+ qt_datediff_5 """select datediff('2023-01-02 12:00:00', '2023-01-01
13:00:00')"""
+
+ // 8. DATE_FLOOR function tests
+ // 按 5 秒向下取整
+ qt_date_floor_1 """select date_floor(cast('0001-01-01 00:00:18' as
datetime), INTERVAL 5 SECOND)"""
+
+ // 带有 scale 的日期时间，返回值也会带有 scale
+ qt_date_floor_2 """select date_floor(cast('0001-01-01 00:00:18.123' as
datetime), INTERVAL 5 SECOND)"""
+
+ // 输入时间恰好是 5 天周期的起点
+ qt_date_floor_3 """select date_floor('2023-07-10 00:00:00', INTERVAL 5
DAY)"""
+
+ // date 类型的向下取整
+ qt_date_floor_4 """select date_floor('2023-07-13', INTERVAL 5 YEAR)"""
+
+ // 任一参数为 NULL
+ qt_date_floor_5 """select date_floor(NULL, INTERVAL 5 HOUR)"""
+
+ // 9. DATE_FORMAT function tests
+ // 基本格式化测试
+ qt_date_format_1 """SELECT DATE_FORMAT('2009-10-04 22:23:00', '%W %M
%Y')"""
+ qt_date_format_2 """SELECT DATE_FORMAT('2007-10-04 22:23:00',
'%H:%i:%s')"""
+ qt_date_format_3 """SELECT DATE_FORMAT('1999-01-01', '%Y-%m-%d')"""
+ qt_date_format_4 """SELECT DATE_FORMAT('1999-01-01 00:00:00', '%d/%m/%Y
%H:%i:%s')"""
+
+ // 特殊格式符测试
+ qt_date_format_5 """SELECT DATE_FORMAT('2009-10-04', '%a %b %c')"""
+ qt_date_format_6 """SELECT DATE_FORMAT('2009-10-04', '%D %e %f')"""
+
+ // 任一参数为 NULL
+ qt_date_format_7 """SELECT DATE_FORMAT(NULL, '%Y-%m-%d')"""
+ qt_date_format_8 """SELECT DATE_FORMAT('2009-10-04', NULL)"""
+
+ // 10. DATE function tests
+ // 从datetime中提取日期部分
+ qt_date_1 """SELECT DATE('2003-12-31 01:02:03')"""
+ qt_date_2 """SELECT DATE('2003-12-31')"""
+
+ // 参数为 NULL
+ qt_date_3 """SELECT DATE(NULL)"""
+
+ // 11. DATE_SUB function tests
+ // 减去天数
+ qt_date_sub_1 """SELECT DATE_SUB('2018-05-01', INTERVAL 1 DAY)"""
+
+ // 减去月数
+ qt_date_sub_2 """SELECT DATE_SUB('2018-05-01', INTERVAL 1 MONTH)"""
+
+ // 减去年数
+ qt_date_sub_3 """SELECT DATE_SUB('2018-05-01', INTERVAL 1 YEAR)"""
+
+ // 减去小时
+ qt_date_sub_4 """SELECT DATE_SUB('2018-05-01 12:00:00', INTERVAL 2 HOUR)"""
+
+ // 参数为 NULL
+ qt_date_sub_5 """SELECT DATE_SUB(NULL, INTERVAL 1 DAY)"""
+
+ // 12. DATE_TRUNC function tests
+ // 截断到年
+ qt_date_trunc_1 """SELECT DATE_TRUNC('2019-05-09', 'year')"""
+
+ // 截断到月
+ qt_date_trunc_2 """SELECT DATE_TRUNC('2019-05-09', 'month')"""
+
+ // 截断到日
+ qt_date_trunc_3 """SELECT DATE_TRUNC('2019-05-09 12:30:45', 'day')"""
+
+ // 截断到小时
+ qt_date_trunc_4 """SELECT DATE_TRUNC('2019-05-09 12:30:45', 'hour')"""
+
+ // 参数为 NULL
+ qt_date_trunc_5 """SELECT DATE_TRUNC(NULL, 'year')"""
+
+ // Group 2: Day functions and related date extraction functions
+
+ // 13. DAY_CEIL function tests
+ qt_day_ceil_1 """select day_ceil( cast('2023-07-13 22:28:18' as datetime),
5)"""
+ qt_day_ceil_2 """select day_ceil( '2023-07-13 22:28:18.123', 5)"""
+ qt_day_ceil_3 """select day_ceil('2023-07-13 22:28:18')"""
+ qt_day_ceil_4 """select day_ceil('2023-07-13 22:28:18', 7, '2023-01-01
00:00:00')"""
+ qt_day_ceil_5 """select day_ceil('2023-07-16 00:00:00', 7, '2023-01-01
00:00:00')"""
+ qt_day_ceil_6 """select day_ceil(cast('2023-07-13' as date), 3)"""
+ qt_day_ceil_7 """select day_ceil(cast('2023-07-13' as date), 0)"""
+ qt_day_ceil_8 """select day_ceil(NULL, 5, '2023-01-01')"""
+
+ // 14. DAY_FLOOR function tests
+ qt_day_floor_1 """select day_floor('2023-07-13 22:28:18', 5)"""
+ qt_day_floor_2 """select day_floor('2023-07-13 22:28:18.123', 5)"""
+ qt_day_floor_3 """select day_floor('2023-07-13 22:28:18')"""
+ qt_day_floor_4 """select day_floor('2023-07-13 22:28:18', 7, '2023-01-01
00:00:00')"""
+ qt_day_floor_5 """select day_floor('2023-07-09 00:00:00', 7, '2023-01-01
00:00:00')"""
+ qt_day_floor_6 """select day_floor(cast('2023-07-13' as date), 3)"""
+ qt_day_floor_7 """select day_floor(NULL, 5, '2023-01-01')"""
+
+ // 15. DAY function tests
+ qt_day_1 """select day('1987-01-31')"""
+ qt_day_2 """select day('2023-07-13 22:28:18')"""
+ qt_day_3 """select day(NULL)"""
+
+ // 16. DAYNAME function tests
+ qt_dayname_1 """select dayname('2007-02-03 00:00:00')"""
+ qt_dayname_2 """select dayname('2023-10-01')"""
+ qt_dayname_3 """select dayname(NULL)"""
+
+ // 17. DAYOFWEEK function tests
+ qt_dayofweek_1 """select dayofweek('2019-06-25')"""
+ qt_dayofweek_2 """select dayofweek('2019-06-25 15:30:45')"""
+ qt_dayofweek_3 """select dayofweek('2024-02-18')"""
+ qt_dayofweek_4 """select dayofweek(NULL)"""
+
+ // 18. DAYOFYEAR function tests
+ qt_dayofyear_1 """select dayofyear('2007-02-03 00:00:00')"""
+ qt_dayofyear_2 """select dayofyear('2023-12-31')"""
+ qt_dayofyear_3 """select dayofyear('2024-12-31')"""
+ qt_dayofyear_4 """select dayofyear(NULL)"""
+
+ // 19. EXTRACT function tests
+ qt_extract_1 """select extract(year from '2022-09-22 17:01:30') as year,
extract(month from '2022-09-22 17:01:30') as month, extract(day from
'2022-09-22 17:01:30') as day, extract(hour from '2022-09-22 17:01:30') as
hour, extract(minute from '2022-09-22 17:01:30') as minute, extract(second from
'2022-09-22 17:01:30') as second, extract(microsecond from cast('2022-09-22
17:01:30.000123' as datetime(6))) as microsecond"""
+ qt_extract_2 """select extract(quarter from '2023-05-15') as quarter"""
+ qt_extract_3 """select extract(week from '2024-01-06') as week"""
+ qt_extract_4 """select extract(week from '2024-01-07') as week"""
+ qt_extract_5 """select extract(week from '2024-12-31') as week"""
+
+ // 20. FROM_DAYS function tests
+ qt_from_days_1 """select from_days(730669),from_days(5),from_days(59),
from_days(60)"""
+ qt_from_days_2 """select from_days(-60)"""
+ qt_from_days_3 """select from_days(NULL)"""
+
+ // 21. FROM_ISO8601_DATE function tests
+ qt_from_iso8601_date_1 """select from_iso8601_date('2023') as year_only,
from_iso8601_date('2023-10') as year_month, from_iso8601_date('2023-10-05') as
full_date"""
+ qt_from_iso8601_date_2 """select from_iso8601_date('2021-001') as day_1,
from_iso8601_date('2021-059') as day_59, from_iso8601_date('2021-060') as
day_60, from_iso8601_date('2024-366') as day_366"""
+ qt_from_iso8601_date_3 """select from_iso8601_date('0522-W01-1') as
week_1"""
+ qt_from_iso8601_date_4 """select from_iso8601_date('0522-W01-4') as
week_4"""
+ qt_from_iso8601_date_5 """select from_iso8601_date('0522-W01') as week_1"""
+ qt_from_iso8601_date_6 """select
from_iso8601_date('2023-10-01T12:34:10')"""
+ qt_from_iso8601_date_7 """select from_iso8601_date('0522-W61') as
week_61"""
+ qt_from_iso8601_date_8 """select from_iso8601_date('0522-661') as
day_661"""
+ qt_from_iso8601_date_9 """select from_iso8601_date(NULL)"""
+
+ // 22. FROM_MICROSECOND function tests
+ qt_from_microsecond_1 """SELECT FROM_MICROSECOND(0)"""
+ qt_from_microsecond_2 """SELECT FROM_MICROSECOND(1700000000000000)"""
+ qt_from_microsecond_3 """select from_microsecond(1700000000123456) as
dt_with_micro"""
+ qt_from_microsecond_4 """select from_microsecond(NULL)"""
+
+ // 23. FROM_MILLISECOND function tests
+ qt_from_millisecond_1 """SELECT FROM_MILLISECOND(0)"""
+ qt_from_millisecond_2 """SELECT FROM_MILLISECOND(1700000000000)"""
+ qt_from_millisecond_3 """select from_millisecond(1700000000123) as
dt_with_milli"""
+ qt_from_millisecond_4 """select from_millisecond(NULL)"""
+
+ // 24. FROM_SECOND function tests
+ qt_from_second_1 """SELECT FROM_SECOND(0)"""
+ qt_from_second_2 """SELECT FROM_SECOND(1700000000)"""
+ qt_from_second_3 """select from_second(NULL)"""
+
+ // 25. FROM_UNIXTIME function tests
+ qt_from_unixtime_1 """select from_unixtime(0)"""
+ qt_from_unixtime_2 """select from_unixtime(1196440219)"""
+ qt_from_unixtime_3 """select from_unixtime(1196440219, 'yyyy-MM-dd
HH:mm:ss')"""
+ qt_from_unixtime_4 """select from_unixtime(1196440219, '%Y-%m-%d')"""
+ qt_from_unixtime_5 """select from_unixtime(1196440219, '%Y-%m-%d
%H:%i:%s')"""
+ qt_from_unixtime_6 """select from_unixtime(32536799,'gdaskpdp')"""
+ qt_from_unixtime_7 """select from_unixtime(NULL)"""
+
+ // Group 3: Hour and time manipulation functions (序号 26-43)
+
+ // 26. HOUR_CEIL function tests
+ qt_hour_ceil_1 """select hour_ceil("2023-07-13 22:28:18", 5)"""
+ qt_hour_ceil_2 """select hour_ceil('2023-07-13 19:30:00', 4, '2023-07-13
08:00:00')"""
+ qt_hour_ceil_3 """select hour_ceil('2023-07-13 00:30:00', 6,
'2023-07-13')"""
+ qt_hour_ceil_4 """select hour_ceil('2023-07-13 01:00:00')"""
+ qt_hour_ceil_5 """select hour_ceil('2023-07-13 19:30:00', 4, '2023-07-13
08:00:00.123')"""
+ qt_hour_ceil_6 """select hour_ceil('2023-07-13 19:30:00.123', 4,
'2023-07-13 08:00:00')"""
+ qt_hour_ceil_7 """select hour_ceil(null, 3)"""
+ qt_hour_ceil_8 """select hour_ceil("2023-07-13 22:28:18", NULL)"""
+ qt_hour_ceil_9 """select hour_ceil("2023-07-13 22:28:18", 5, NULL)"""
+
+ // 27. HOUR_FLOOR function tests
+ qt_hour_floor_1 """select hour_floor("2023-07-13 22:28:18", 5)"""
+ qt_hour_floor_2 """select hour_floor('2023-07-13 19:30:00', 4, '2023-07-13
08:00:00')"""
+ qt_hour_floor_3 """select hour_floor("2023-07-13 18:00:00", 5)"""
+ qt_hour_floor_4 """select hour_floor('2023-07-13 20:30:00', 4,
'2023-07-13')"""
+ qt_hour_floor_5 """select hour_floor('2023-07-13 19:30:00.123', 4,
'2023-07-03 08:00:00')"""
+ qt_hour_floor_6 """select hour_floor('2023-07-13 19:30:00', 4, '2023-07-03
08:00:00.123')"""
+ qt_hour_floor_7 """select hour_floor(null, 6)"""
+
+ // 28. HOUR function tests
+ qt_hour_1 """select hour('2018-12-31 23:59:59'), hour('2023-01-01
00:00:00'), hour('2023-10-01 12:30:45')"""
+ qt_hour_2 """select hour(cast('14:30:00' as time)), hour(cast('25:00:00'
as time)), hour(cast('456:26:32' as time))"""
+ qt_hour_3 """select hour(cast('-12:30:00' as time)), hour(cast('838:59:59'
as time)), hour(cast('-838:59:59' as time))"""
+ qt_hour_4 """select hour('2023-10-01')"""
+ qt_hour_5 """select hour(NULL)"""
+
+ // 29. HOURS_ADD function tests
+ qt_hours_add_1 """SELECT HOURS_ADD('2020-02-02 02:02:02', 1)"""
+ qt_hours_add_2 """SELECT HOURS_ADD('2020-02-02', 51)"""
+ qt_hours_add_3 """select hours_add('2023-10-01 10:00:00', -3)"""
+ qt_hours_add_4 """select hours_add(null, 5)"""
+ qt_hours_add_5 """select hours_add('2023-10-01 10:00:00', NULL)"""
+
+ // 30. HOURS_DIFF function tests
+ qt_hours_diff_1 """select hours_diff('2020-12-25 22:00:00', '2020-12-25
08:00:00')"""
+ qt_hours_diff_2 """select hours_diff('2023-06-15 10:30:00', '2023-06-15
14:45:00')"""
+ qt_hours_diff_3 """select hours_diff('2020-03-01', '2020-02-28')"""
+ qt_hours_diff_4 """select hours_diff('2024-02-29', '2024-02-28')"""
+ qt_hours_diff_5 """select hours_diff('2023-10-01 10:00:00', NULL)"""
+ qt_hours_diff_6 """select hours_diff(NULL, '2023-10-01 10:00:00')"""
+
+ // 31. HOURS_SUB function tests
+ qt_hours_sub_1 """select hours_sub('2020-02-02 02:02:02', 1)"""
+ qt_hours_sub_2 """select hours_sub('2020-02-02', 10)"""
+ qt_hours_sub_3 """select hours_sub('2023-10-01 10:00:00', -5)"""
+ qt_hours_sub_4 """select hours_sub(null, 3)"""
+ qt_hours_sub_5 """select hours_sub('2023-10-01 10:00:00', NULL)"""
+
+ // 32. LAST_DAY function tests
+ qt_last_day_1 """SELECT LAST_DAY('2000-02-03')"""
+ qt_last_day_2 """SELECT LAST_DAY('2023-04-15 12:34:56')"""
+ qt_last_day_3 """SELECT LAST_DAY('2023-02-28')"""
+ qt_last_day_4 """SELECT LAST_DAY('2024-02-15')"""
+ qt_last_day_5 """SELECT LAST_DAY('2023-12-25')"""
+ qt_last_day_6 """SELECT LAST_DAY('2023-01-01')"""
+ qt_last_day_7 """SELECT LAST_DAY(NULL)"""
+
+
+ // 34. MAKEDATE function tests
+ qt_makedate_1 """select makedate(2021, 1), makedate(2021, 32),
makedate(2021, 365)"""
+ qt_makedate_2 """select makedate(2024, 1), makedate(2024, 60),
makedate(2024, 366)"""
+ qt_makedate_3 """select makedate(2021, 0)"""
+ qt_makedate_4 """select makedate(2021, 400)"""
+ qt_makedate_5 """select makedate(NULL, 100)"""
+ qt_makedate_6 """select makedate(2021, NULL)"""
+
+ // 35. MICROSECOND function tests
+ qt_microsecond_1 """select microsecond('2019-01-01 00:00:00.123456')"""
+ qt_microsecond_2 """select microsecond(cast('14:30:25.123456' as time))"""
+ qt_microsecond_3 """select microsecond('2019-01-01 00:00:00')"""
+ qt_microsecond_4 """select microsecond('2019-01-01')"""
+ qt_microsecond_5 """select microsecond(NULL)"""
+
+ // 36. MICROSECONDS_ADD function tests
+ qt_microseconds_add_1 """select microseconds_add('2020-02-02 02:02:02',
1000000)"""
+ qt_microseconds_add_2 """select microseconds_add('2023-10-01
12:30:45.123456', 500000)"""
+ qt_microseconds_add_3 """select microseconds_add('2020-02-02', 2000000)"""
+ qt_microseconds_add_4 """select microseconds_add('2023-10-01 10:00:00',
-1000000)"""
+ qt_microseconds_add_5 """select microseconds_add(null, 1000000)"""
+ qt_microseconds_add_6 """select microseconds_add('2023-10-01 10:00:00',
NULL)"""
+
+ // 37. MICROSECONDS_DIFF function tests
+ qt_microseconds_diff_1 """select microseconds_diff('2020-12-25
22:00:00.123456', '2020-12-25 22:00:00.000000')"""
+ qt_microseconds_diff_2 """select microseconds_diff('2023-06-15 10:30:00',
'2023-06-15 10:29:59')"""
+ qt_microseconds_diff_3 """select microseconds_diff('2020-03-01
00:00:00.500000', '2020-02-29 23:59:59.000000')"""
+ qt_microseconds_diff_4 """select microseconds_diff('2023-10-01 10:00:00',
NULL)"""
+ qt_microseconds_diff_5 """select microseconds_diff(NULL, '2023-10-01
10:00:00')"""
+
+ // 38. MICROSECONDS_SUB function tests
+ qt_microseconds_sub_1 """select microseconds_sub('2020-02-02
02:02:02.123456', 500000)"""
+ qt_microseconds_sub_2 """select microseconds_sub('2023-10-01 12:30:45',
1000000)"""
+ qt_microseconds_sub_3 """select microseconds_sub('2020-02-02', 1000000)"""
+ qt_microseconds_sub_4 """select microseconds_sub('2023-10-01 10:00:00',
-500000)"""
+ qt_microseconds_sub_5 """select microseconds_sub(null, 1000000)"""
+ qt_microseconds_sub_6 """select microseconds_sub('2023-10-01 10:00:00',
NULL)"""
+
+ // 39. MICROSECOND_TIMESTAMP function tests
+ qt_microsecond_timestamp_1 """SELECT MICROSECOND_TIMESTAMP('2025-01-23
12:34:56.123456')"""
+ qt_microsecond_timestamp_2 """SELECT MICROSECOND_TIMESTAMP('2025-01-23
12:34:56.123456 UTC')"""
+ qt_microsecond_timestamp_3 """SELECT MICROSECOND_TIMESTAMP('1970-01-01')"""
+ qt_microsecond_timestamp_4 """SELECT MICROSECOND_TIMESTAMP('1960-01-01
00:00:00 UTC')"""
+ qt_microsecond_timestamp_5 """SELECT MICROSECOND_TIMESTAMP(NULL)"""
+
+ // 40. MILLISECONDS_ADD function tests
+ qt_milliseconds_add_1 """select milliseconds_add('2020-02-02 02:02:02',
1000)"""
+ qt_milliseconds_add_2 """select milliseconds_add('2023-10-01
12:30:45.123', 500)"""
+ qt_milliseconds_add_3 """select milliseconds_add('2020-02-02', 2000)"""
+ qt_milliseconds_add_4 """select milliseconds_add('2023-10-01 10:00:00',
-1000)"""
+ qt_milliseconds_add_5 """select milliseconds_add(null, 1000)"""
+ qt_milliseconds_add_6 """select milliseconds_add('2023-10-01 10:00:00',
NULL)"""
+
+ // 41. MILLISECONDS_DIFF function tests
+ qt_milliseconds_diff_1 """select milliseconds_diff('2020-12-25
22:00:00.123', '2020-12-25 22:00:00.000')"""
+ qt_milliseconds_diff_2 """select milliseconds_diff('2023-06-15 10:30:00',
'2023-06-15 10:29:59')"""
+ qt_milliseconds_diff_3 """select milliseconds_diff('2020-03-01
00:00:00.500', '2020-02-29 23:59:59.000')"""
+ qt_milliseconds_diff_4 """select milliseconds_diff('2023-10-01 10:00:00',
NULL)"""
+ qt_milliseconds_diff_5 """select milliseconds_diff(NULL, '2023-10-01
10:00:00')"""
+
+ // 42. MILLISECONDS_SUB function tests
+ qt_milliseconds_sub_1 """select milliseconds_sub('2020-02-02
02:02:02.123', 500)"""
+ qt_milliseconds_sub_2 """select milliseconds_sub('2023-10-01 12:30:45',
1000)"""
+ qt_milliseconds_sub_3 """select milliseconds_sub('2020-02-02', 1000)"""
+ qt_milliseconds_sub_4 """select milliseconds_sub('2023-10-01 10:00:00',
-500)"""
+ qt_milliseconds_sub_5 """select milliseconds_sub(null, 1000)"""
+ qt_milliseconds_sub_6 """select milliseconds_sub('2023-10-01 10:00:00',
NULL)"""
+
+ // 43. MILLISECOND_TIMESTAMP function tests
+ qt_millisecond_timestamp_1 """SELECT MILLISECOND_TIMESTAMP('2025-01-23
12:34:56.123')"""
+ qt_millisecond_timestamp_2 """SELECT MILLISECOND_TIMESTAMP('2025-01-23
12:34:56.123 UTC')"""
+ qt_millisecond_timestamp_3 """SELECT MILLISECOND_TIMESTAMP('2024-01-01
00:00:00.123456')"""
+ qt_millisecond_timestamp_4 """SELECT MILLISECOND_TIMESTAMP('1960-01-01
00:00:00 UTC')"""
+ qt_millisecond_timestamp_5 """SELECT MILLISECOND_TIMESTAMP('1970-01-01')"""
+ qt_millisecond_timestamp_6 """SELECT MILLISECOND_TIMESTAMP(NULL)"""
+
+ // Group 4: Minute and Month functions (序号 44-62)
+
+ // 44. MINUTE_CEIL function tests
+ qt_minute_ceil_1 """SELECT MINUTE_CEIL('2023-07-13 22:28:18')"""
+ qt_minute_ceil_2 """SELECT MINUTE_CEIL('2023-07-13 22:28:18.123',5)"""
+ qt_minute_ceil_3 """SELECT MINUTE_CEIL('2023-07-13 22:30:00',5)"""
+ qt_minute_ceil_4 """SELECT MINUTE_CEIL('2023-07-13 22:28:18', 5,
'2023-07-13 22:20:00')"""
+ qt_minute_ceil_5 """SELECT MINUTE_CEIL('2023-07-13 22:28:18.456789', 5)"""
+ qt_minute_ceil_6 """SELECT MINUTE_CEIL('2023-07-13', 30)"""
+ qt_minute_ceil_7 """SELECT MINUTE_CEIL(NULL, 5), MINUTE_CEIL('2023-07-13
22:28:18', NULL)"""
+
+ // 45. MINUTE_FLOOR function tests
+ qt_minute_floor_1 """SELECT MINUTE_FLOOR('2023-07-13 22:28:18')"""
+ qt_minute_floor_2 """SELECT MINUTE_FLOOR('2023-07-13 22:28:18.123', 5)"""
+ qt_minute_floor_3 """SELECT MINUTE_FLOOR('2023-07-13 22:25:00', 5)"""
+ qt_minute_floor_4 """SELECT MINUTE_FLOOR('2023-07-13 22:28:18', 5,
'2023-07-13 22:20:00')"""
+ qt_minute_floor_5 """SELECT MINUTE_FLOOR('2023-07-13 22:28:18.456789',
5)"""
+ qt_minute_floor_6 """SELECT MINUTE_FLOOR('2023-07-13', 30)"""
+ qt_minute_floor_7 """SELECT MINUTE_FLOOR(NULL, 5),
MINUTE_FLOOR('2023-07-13 22:28:18', NULL)"""
+
+ // 46. MINUTE function tests
+ qt_minute_1 """SELECT MINUTE('2018-12-31 23:59:59')"""
+ qt_minute_2 """SELECT MINUTE('2023-05-01 10:05:30.123456')"""
+ qt_minute_3 """SELECT MINUTE('14:25:45')"""
+ qt_minute_4 """SELECT MINUTE('2023-07-13')"""
+ qt_minute_5 """SELECT MINUTE(NULL)"""
+
+ // 47. MINUTES_ADD function tests
+ qt_minutes_add_1 """SELECT MINUTES_ADD('2020-02-02', 1)"""
+ qt_minutes_add_2 """SELECT MINUTES_ADD('2023-07-13 22:28:18', 5)"""
+ qt_minutes_add_3 """SELECT MINUTES_ADD('2023-07-13 22:28:18.456789', 10)"""
+ qt_minutes_add_4 """SELECT MINUTES_ADD('2023-07-13 22:28:18', -5)"""
+ qt_minutes_add_5 """SELECT MINUTES_ADD(NULL, 10), MINUTES_ADD('2023-07-13
22:28:18', NULL)"""
+ qt_minutes_add_6 """SELECT MINUTES_ADD('2023-07-13 22:28:18',
2147483648)"""
+
+ // 48. MINUTES_DIFF function tests
+ qt_minutes_diff_1 """SELECT MINUTES_DIFF('2020-12-25 22:00:00',
'2020-12-25 21:00:00')"""
+ qt_minutes_diff_2 """SELECT MINUTES_DIFF('2020-12-25 21:00:00.999',
'2020-12-25 22:00:00.923')"""
+ qt_minutes_diff_3 """SELECT MINUTES_DIFF('2023-07-13 21:50:00',
'2023-07-13 22:00:00')"""
+ qt_minutes_diff_4 """SELECT MINUTES_DIFF('2023-07-14', '2023-07-13')"""
+ qt_minutes_diff_5 """SELECT MINUTES_DIFF('2023-07-13 22:30:59',
'2023-07-13 22:31:01')"""
+ qt_minutes_diff_6 """SELECT MINUTES_DIFF(NULL, '2023-07-13 22:00:00'),
MINUTES_DIFF('2023-07-13 22:00:00', NULL)"""
+
+ // 49. MINUTES_SUB function tests
+ qt_minutes_sub_1 """SELECT MINUTES_SUB('2020-02-02 02:02:02', 1)"""
+ qt_minutes_sub_2 """SELECT MINUTES_SUB('2023-07-13 22:38:18.456789', 10)"""
+ qt_minutes_sub_3 """SELECT MINUTES_SUB('2023-07-13 22:23:18', -5)"""
+ qt_minutes_sub_4 """SELECT MINUTES_SUB('2023-07-13', 30)"""
+ qt_minutes_sub_5 """SELECT MINUTES_SUB(NULL, 10), MINUTES_SUB('2023-07-13
22:28:18', NULL)"""
+
+ // 50. MONTH_CEIL function tests
+ qt_month_ceil_1 """SELECT MONTH_CEIL('2023-07-13 22:28:18')"""
+ qt_month_ceil_2 """SELECT MONTH_CEIL('2023-07-13 22:28:18', 5)"""
+ qt_month_ceil_3 """SELECT MONTH_CEIL('2023-12-01 00:00:00', 5)"""
+ qt_month_ceil_4 """SELECT MONTH_CEIL('2023-07-13 22:28:18', 5, '2023-01-01
00:00:00')"""
+ qt_month_ceil_5 """SELECT MONTH_CEIL('2023-07-13 22:28:18.456789', 5)"""
+ qt_month_ceil_6 """SELECT MONTH_CEIL('2023-07-13', 3)"""
+ qt_month_ceil_7 """SELECT MONTH_CEIL(NULL, 5), MONTH_CEIL('2023-07-13
22:28:18', NULL)"""
+
+ // 51. MONTH_FLOOR function tests
+ qt_month_floor_1 """SELECT MONTH_FLOOR('2023-07-13 22:28:18')"""
+ qt_month_floor_2 """SELECT MONTH_FLOOR('2023-07-13 22:28:18', 5)"""
+ qt_month_floor_3 """SELECT MONTH_FLOOR('2023-06-01 00:00:00', 5)"""
+ qt_month_floor_4 """SELECT MONTH_FLOOR('2023-07-13 22:28:18', 5,
'2023-01-01 00:00:00')"""
+ qt_month_floor_5 """SELECT MONTH_FLOOR('2023-07-13 22:28:18.456789', 5)"""
+ qt_month_floor_6 """SELECT MONTH_FLOOR('2023-07-13', 3)"""
+ qt_month_floor_7 """SELECT MONTH_FLOOR(NULL, 5), MONTH_FLOOR('2023-07-13
22:28:18', NULL)"""
+
+ // 52. MONTH function tests
+ qt_month_1 """SELECT MONTH('1987-01-01')"""
+ qt_month_2 """SELECT MONTH('2023-07-13 22:28:18')"""
+ qt_month_3 """SELECT MONTH('2023-12-05 10:15:30.456789')"""
+ qt_month_4 """SELECT MONTH(NULL)"""
+
+ // 53. MONTHNAME function tests
+ qt_monthname_1 """SELECT MONTHNAME('2008-02-03')"""
+ qt_monthname_2 """SELECT MONTHNAME('2023-07-13 22:28:18')"""
+ qt_monthname_3 """SELECT MONTHNAME(NULL)"""
+
+ // 54. MONTHS_ADD function tests
+ qt_months_add_1 """SELECT MONTHS_ADD('2020-01-31', 1)"""
+ qt_months_add_2 """SELECT MONTHS_ADD('2020-01-31 02:02:02', 1)"""
+ qt_months_add_3 """SELECT MONTHS_ADD('2020-01-31', -1)"""
+ qt_months_add_4 """SELECT MONTHS_ADD('2023-07-13 22:28:18', 5)"""
+ qt_months_add_5 """SELECT MONTHS_ADD('2023-07-13 22:28:18.456789', 3)"""
+ qt_months_add_6 """SELECT MONTHS_ADD(NULL, 5), MONTHS_ADD('2023-07-13',
NULL)"""
+
+ // 55. MONTHS_BETWEEN function tests
+ qt_months_between_1 """SELECT MONTHS_BETWEEN('2020-12-26', '2020-10-25')"""
+ qt_months_between_2 """SELECT MONTHS_BETWEEN('2020-12-26 15:30:00',
'2020-10-25 08:15:00')"""
+ qt_months_between_3 """SELECT MONTHS_BETWEEN('2020-10-25', '2020-12-26',
false)"""
+ qt_months_between_4 """SELECT MONTHS_BETWEEN('2024-02-29', '2024-01-31')"""
+ qt_months_between_5 """SELECT MONTHS_BETWEEN('2024-03-15', '2024-01-15')"""
+ qt_months_between_6 """SELECT MONTHS_BETWEEN('2024-02-29', '2024-01-30')"""
+ qt_months_between_7 """SELECT MONTHS_BETWEEN(NULL, '2024-01-01')"""
+
+ // 56. MONTHS_DIFF function tests
+ qt_months_diff_1 """SELECT MONTHS_DIFF('2020-03-28', '2020-02-29')"""
+ qt_months_diff_2 """SELECT MONTHS_DIFF('2020-03-29', '2020-02-29')"""
+ qt_months_diff_3 """SELECT MONTHS_DIFF('2020-03-30', '2020-02-29')"""
+ qt_months_diff_4 """SELECT MONTHS_DIFF('2020-02-29', '2020-03-28')"""
+ qt_months_diff_5 """SELECT MONTHS_DIFF('2020-02-29', '2020-03-29')"""
+ qt_months_diff_6 """SELECT MONTHS_DIFF('2023-07-15', '2023-07-30')"""
+ qt_months_diff_7 """SELECT MONTHS_DIFF(NULL, '2023-01-01')"""
+
+ // 57. MONTHS_SUB function tests
+ qt_months_sub_1 """SELECT MONTHS_SUB('2020-01-31', 1)"""
+ qt_months_sub_2 """SELECT MONTHS_SUB('2020-01-31 02:02:02', 1)"""
+ qt_months_sub_3 """SELECT MONTHS_SUB('2020-01-31', -1)"""
+ qt_months_sub_4 """SELECT MONTHS_SUB('2023-07-13 22:28:18', 5)"""
+ qt_months_sub_5 """SELECT MONTHS_SUB('2023-10-13 22:28:18.456789', 3)"""
+ qt_months_sub_6 """SELECT MONTHS_SUB(NULL, 5), MONTHS_SUB('2023-07-13',
NULL)"""
+
+ // 58. NEXT_DAY function tests
+ qt_next_day_1 """SELECT NEXT_DAY('2020-01-31', 'MONDAY')"""
+ qt_next_day_2 """SELECT NEXT_DAY('2020-01-31 02:02:02', 'MON')"""
+ qt_next_day_3 """SELECT NEXT_DAY('2023-07-17', 'MON')"""
+ qt_next_day_4 """SELECT NEXT_DAY('2023-07-13', 'FR')"""
+ qt_next_day_5 """SELECT NEXT_DAY(NULL, 'SUN')"""
+ qt_next_day_6 """SELECT NEXT_DAY('9999-12-31 12:00:00', 'SUNDAY')"""
+
+
+ // 60. QUARTER function tests
+ qt_quarter_1 """SELECT QUARTER('2025-01-16')"""
+ qt_quarter_2 """SELECT QUARTER('2025-01-16 01:11:10')"""
+ qt_quarter_3 """SELECT QUARTER('2023-05-20')"""
+ qt_quarter_4 """SELECT QUARTER('2024-09-30 23:59:59')"""
+ qt_quarter_5 """SELECT QUARTER('2022-12-01')"""
+ qt_quarter_6 """SELECT QUARTER(NULL)"""
+
+ // 61. QUARTERS_ADD function tests
+ qt_quarters_add_1 """SELECT QUARTERS_ADD('2020-01-31', 1)"""
+ qt_quarters_add_2 """SELECT QUARTERS_ADD('2020-01-31 02:02:02', 1)"""
+ qt_quarters_add_3 """SELECT QUARTERS_ADD('2020-04-30', -1)"""
+ qt_quarters_add_4 """SELECT QUARTERS_ADD('2023-07-13 22:28:18', 2)"""
+ qt_quarters_add_5 """SELECT QUARTERS_ADD('2023-07-13 22:28:18.456789',
1)"""
+ qt_quarters_add_6 """SELECT QUARTERS_ADD('2023-10-01', 2)"""
+ qt_quarters_add_7 """SELECT QUARTERS_ADD(NULL, 1),
QUARTERS_ADD('2023-07-13', NULL)"""
+
+ // 62. QUARTERS_SUB function tests
+ qt_quarters_sub_1 """SELECT QUARTERS_SUB('2020-01-31', 1)"""
+ qt_quarters_sub_2 """SELECT QUARTERS_SUB('2020-01-31 02:02:02', 1)"""
+ qt_quarters_sub_3 """SELECT QUARTERS_SUB('2019-10-31', -1)"""
+ qt_quarters_sub_4 """SELECT QUARTERS_SUB('2023-07-13 22:28:18', 2)"""
+ qt_quarters_sub_5 """SELECT QUARTERS_SUB('2023-10-13 22:28:18.456789',
1)"""
+ qt_quarters_sub_6 """SELECT QUARTERS_SUB('2024-04-01', 2)"""
+ qt_quarters_sub_7 """SELECT QUARTERS_SUB(NULL, 1),
QUARTERS_SUB('2023-07-13', NULL)"""
+
+ // Group 5: Second and time manipulation functions (序号 63-77)
+
+ // 63. SECOND_CEIL function tests
+ qt_second_ceil_1 """SELECT SECOND_CEIL('2025-01-23 12:34:56')"""
+ qt_second_ceil_2 """SELECT SECOND_CEIL('2025-01-23 12:34:56', 5)"""
+ qt_second_ceil_3 """SELECT SECOND_CEIL('2025-01-23 12:34:56', 10,
'2025-01-23 12:00:00')"""
+ qt_second_ceil_4 """SELECT SECOND_CEIL('2025-01-23 12:34:56.789', 5)"""
+ qt_second_ceil_5 """SELECT SECOND_CEIL('2025-01-23', 30)"""
+ qt_second_ceil_6 """SELECT SECOND_CEIL(NULL, 5), SECOND_CEIL('2025-01-23
12:34:56', NULL)"""
+
+ // 64. SECOND_FLOOR function tests
+ qt_second_floor_1 """SELECT SECOND_FLOOR('2025-01-23 12:34:56')"""
+ qt_second_floor_2 """SELECT SECOND_FLOOR('2025-01-23 12:34:56', 5)"""
+ qt_second_floor_3 """SELECT SECOND_FLOOR('2025-01-23 12:34:56', 10,
'2025-01-23 12:00:00')"""
+ qt_second_floor_4 """SELECT SECOND_FLOOR('2025-01-23 12:34:56.789', 5)"""
+ qt_second_floor_5 """SELECT SECOND_FLOOR('2025-01-23', 30)"""
+ qt_second_floor_6 """SELECT SECOND_FLOOR(NULL, 5),
SECOND_FLOOR('2025-01-23 12:34:56', NULL)"""
+
+ // 65. SECOND function tests
+ qt_second_1 """SELECT SECOND('2018-12-31 23:59:59')"""
+ qt_second_2 """SELECT SECOND(cast('15:42:33' as time))"""
+ qt_second_3 """SELECT SECOND('2023-07-13')"""
+ qt_second_4 """SELECT SECOND('2023-07-13 10:30:25.123456')"""
+ qt_second_5 """SELECT SECOND('2024-01-01 00:00:00')"""
+ qt_second_6 """SELECT SECOND(NULL)"""
+
+ // 66. SECONDS_ADD function tests
+ qt_seconds_add_1 """SELECT SECONDS_ADD('2025-01-23 12:34:56', 30)"""
+ qt_seconds_add_2 """SELECT SECONDS_ADD('2025-01-23 12:34:56', -30)"""
+ qt_seconds_add_3 """SELECT SECONDS_ADD('2023-07-13 23:59:50', 15)"""
+ qt_seconds_add_4 """SELECT SECONDS_ADD('2023-01-01', 3600)"""
+ qt_seconds_add_5 """SELECT SECONDS_ADD('2023-07-13 10:30:25.123456', 2)"""
+ qt_seconds_add_6 """SELECT SECONDS_ADD(NULL, 30), SECONDS_ADD('2025-01-23
12:34:56', NULL)"""
+
+ // 67. SECONDS_DIFF function tests
+ qt_seconds_diff_1 """SELECT SECONDS_DIFF('2025-01-23 12:35:56',
'2025-01-23 12:34:56')"""
+ qt_seconds_diff_2 """SELECT SECONDS_DIFF('2023-01-01 00:00:00',
'2023-01-01 00:01:00')"""
+ qt_seconds_diff_3 """SELECT SECONDS_DIFF('2023-01-02', '2023-01-01')"""
+ qt_seconds_diff_4 """SELECT SECONDS_DIFF('2023-07-13 12:00:00.123',
'2023-07-13 11:59:59')"""
+ qt_seconds_diff_5 """SELECT SECONDS_DIFF(NULL, '2023-07-13 10:30:25'),
SECONDS_DIFF('2023-07-13 10:30:25', NULL)"""
+
+ // 68. SECONDS_SUB function tests
+ qt_seconds_sub_1 """SELECT SECONDS_SUB('2025-01-23 12:34:56', 30)"""
+ qt_seconds_sub_2 """SELECT SECONDS_SUB('2025-01-23 12:34:56', -30)"""
+ qt_seconds_sub_3 """SELECT SECONDS_SUB('2023-07-14 00:00:10', 15)"""
+ qt_seconds_sub_4 """SELECT SECONDS_SUB('2023-01-01', 3600)"""
+ qt_seconds_sub_5 """SELECT SECONDS_SUB('2023-07-13 10:30:25.123456', 2)"""
+ qt_seconds_sub_6 """SELECT SECONDS_SUB(NULL, 30), SECONDS_SUB('2025-01-23
12:34:56', NULL)"""
+
+ // 69. SECOND_TIMESTAMP function tests
+ qt_second_timestamp_1 """SELECT SECOND_TIMESTAMP('1970-01-01 00:00:00
UTC')"""
+ qt_second_timestamp_2 """SELECT SECOND_TIMESTAMP('2025-01-23 12:34:56')"""
+ qt_second_timestamp_3 """SELECT SECOND_TIMESTAMP('2023-01-01')"""
+ qt_second_timestamp_4 """SELECT SECOND_TIMESTAMP('1964-10-31 23:59:59')"""
+ qt_second_timestamp_5 """SELECT SECOND_TIMESTAMP('2023-07-13
22:28:18.456789')"""
+ qt_second_timestamp_6 """SELECT SECOND_TIMESTAMP(NULL)"""
+
+ // 70. SEC_TO_TIME function tests
+ qt_sec_to_time_1 """SELECT SEC_TO_TIME(59738)"""
+ qt_sec_to_time_2 """SELECT SEC_TO_TIME(90061)"""
+ qt_sec_to_time_3 """SELECT SEC_TO_TIME(-3600)"""
+ qt_sec_to_time_4 """SELECT SEC_TO_TIME(0)"""
+ qt_sec_to_time_5 """SELECT SEC_TO_TIME(3661.9)"""
+ qt_sec_to_time_6 """SELECT SEC_TO_TIME(NULL)"""
+
+ // 71. STR_TO_DATE function tests
+ qt_str_to_date_1 """SELECT STR_TO_DATE('2025-01-23 12:34:56', '%Y-%m-%d
%H:%i:%s')"""
+ qt_str_to_date_2 """SELECT STR_TO_DATE('2025-01-23 12:34:56', 'yyyy-MM-dd
HH:mm:ss')"""
+ qt_str_to_date_3 """SELECT STR_TO_DATE('20230713', 'yyyyMMdd')"""
+ qt_str_to_date_4 """SELECT STR_TO_DATE('15:30:45', '%H:%i:%s')"""
+ qt_str_to_date_5 """SELECT STR_TO_DATE('200442 Monday', '%X%V %W')"""
+ qt_str_to_date_6 """SELECT STR_TO_DATE('Oct 5 2023 3:45:00 PM', '%b %d %Y
%h:%i:%s %p')"""
+ qt_str_to_date_7 """SELECT STR_TO_DATE('2023/01/01', '%Y-%m-%d')"""
+ qt_str_to_date_8 """SELECT STR_TO_DATE('2023-01-01 10:00:00 (GMT)',
'%Y-%m-%d %H:%i:%s')"""
+ qt_str_to_date_9 """SELECT STR_TO_DATE('2023-07-13 12:34:56.789',
'%Y-%m-%d %H:%i:%s.%f')"""
+ qt_str_to_date_10 """SELECT STR_TO_DATE(NULL, '%Y-%m-%d'),
STR_TO_DATE('2023-01-01', NULL)"""
+ qt_str_to_date_11 """SELECT STR_TO_DATE('2023-01-01', '')"""
+
+ // 72. TIMEDIFF function tests
+ qt_timediff_1 """SELECT TIMEDIFF('2024-07-20 16:59:30', '2024-07-11
16:35:21')"""
+ qt_timediff_2 """SELECT TIMEDIFF('2023-10-05 15:45:00', '2023-10-05')"""
+ qt_timediff_3 """SELECT TIMEDIFF('2023-01-01 09:00:00', '2023-01-01
10:30:00')"""
+ qt_timediff_4 """SELECT TIMEDIFF('2023-12-31 23:59:59', '2023-12-31
23:59:50')"""
+ qt_timediff_5 """SELECT TIMEDIFF('2024-01-01 00:00:01', '2023-12-31
23:59:59')"""
+ qt_timediff_6 """SELECT TIMEDIFF('2023-07-13 12:34:56.789', '2023-07-13
12:34:50.123')"""
+ qt_timediff_7 """SELECT TIMEDIFF(NULL, '2023-01-01 00:00:00'),
TIMEDIFF('2023-01-01 00:00:00', NULL)"""
+
+ // 73. TIME function tests
+ qt_time_1 """SELECT TIME('2025-1-1 12:12:12')"""
+
+ // 74. TIMESTAMPADD function tests
+ qt_timestampadd_1 """SELECT TIMESTAMPADD(MINUTE, 1, '2019-01-02')"""
+ qt_timestampadd_2 """SELECT TIMESTAMPADD(WEEK, 1, '2019-01-02')"""
+ qt_timestampadd_3 """SELECT TIMESTAMPADD(HOUR, -3, '2023-07-13
10:30:00')"""
+ qt_timestampadd_4 """SELECT TIMESTAMPADD(MONTH, 1, '2023-01-31')"""
+ qt_timestampadd_5 """SELECT TIMESTAMPADD(YEAR, 1, '2023-12-31 23:59:59')"""
+ qt_timestampadd_6 """SELECT TIMESTAMPADD(YEAR,NULL, '2023-12-31
23:59:59')"""
+
+ // 75. TIMESTAMPDIFF function tests
+ qt_timestampdiff_1 """SELECT TIMESTAMPDIFF(MONTH, '2003-02-01',
'2003-05-01')"""
+ qt_timestampdiff_2 """SELECT TIMESTAMPDIFF(YEAR, '2002-05-01',
'2001-01-01')"""
+ qt_timestampdiff_3 """SELECT TIMESTAMPDIFF(MINUTE, '2003-02-01',
'2003-05-01 12:05:55')"""
+ qt_timestampdiff_4 """SELECT TIMESTAMPDIFF(DAY, '2023-12-31 23:59:50',
'2024-01-01 00:00:05')"""
+ qt_timestampdiff_5 """SELECT TIMESTAMPDIFF(MONTH, '2023-01-31',
'2023-02-28')"""
+ qt_timestampdiff_6 """SELECT TIMESTAMPDIFF(MONTH, '2023-01-31',
'2023-02-27')"""
+ qt_timestampdiff_7 """SELECT TIMESTAMPDIFF(DAY, NULL, '2023-01-01'),
TIMESTAMPDIFF(DAY, '2023-01-01', NULL)"""
+ qt_timestampdiff_8 """SELECT TIMESTAMPDIFF(WEEK, '2023-01-01',
'2023-01-15')"""
+
+ // 76. TIMESTAMP function tests
+ qt_timestamp_1 """SELECT TIMESTAMP('2019-01-01 12:00:00')"""
+ qt_timestamp_2 """SELECT TIMESTAMP('2019-01-01')"""
+ qt_timestamp_3 """SELECT TIMESTAMP('2019-01-41 12:00:00')"""
+ qt_timestamp_4 """SELECT TIMESTAMP(NULL)"""
+
+ // 77. TIME_TO_SEC function tests
+ qt_time_to_sec_1 """SELECT TIME_TO_SEC('16:32:18')"""
+ qt_time_to_sec_2 """SELECT TIME_TO_SEC('2025-01-01 16:32:18')"""
+ qt_time_to_sec_3 """SELECT TIME_TO_SEC('-02:30:00')"""
+ qt_time_to_sec_4 """SELECT TIME_TO_SEC('-16:32:18.99')"""
+ qt_time_to_sec_5 """SELECT TIME_TO_SEC('10:15:30.123456')"""
+ qt_time_to_sec_6 """SELECT TIME_TO_SEC('12:60:00')"""
+ qt_time_to_sec_7 """SELECT TIME_TO_SEC('839:00:00')"""
+ qt_time_to_sec_8 """SELECT TIME_TO_SEC(NULL)"""
+
+ // Group 6: TO_DATE, TO_DAYS, TO_ISO8601, TO_MONDAY, UNIX_TIMESTAMP,
UTC_TIMESTAMP, WEEK_CEIL, WEEKDAY, WEEK_FLOOR, WEEK, WEEKOFYEAR, WEEKS_ADD,
WEEKS_DIFF, WEEKS_SUB (序号78-91)
+
+ // 78. TO_DATE function tests
+ qt_to_date_1 """select to_date("2020-02-02 00:00:00")"""
+ qt_to_date_2 """select to_date("2020-02-02")"""
+ qt_to_date_3 """SELECT TO_DATE('2023-02-30 23:23:56') AS result"""
+ qt_to_date_4 """SELECT TO_DATE(NULL) AS result"""
+
+ // 79. TO_DAYS function tests
+ qt_to_days_1 """select to_days('2007-10-07')"""
+ qt_to_days_2 """select to_days('2007-10-07 10:03:09')"""
+
+ // 80. TO_ISO8601 function tests
+ qt_to_iso8601_1 """SELECT TO_ISO8601(CAST('2023-10-05' AS DATE)) AS
date_result"""
+ qt_to_iso8601_2 """SELECT TO_ISO8601(CAST('2020-01-01 12:30:45' AS
DATETIME)) AS datetime_result"""
+ qt_to_iso8601_3 """SELECT TO_ISO8601(CAST('2020-01-01 12:30:45.956' AS
DATETIME)) AS datetime_result"""
+ qt_to_iso8601_4 """SELECT TO_ISO8601('2023-02-30') AS invalid_date"""
+ qt_to_iso8601_5 """SELECT TO_ISO8601(NULL) AS null_input"""
+
+ // 81. TO_MONDAY function tests
+ qt_to_monday_1 """SELECT TO_MONDAY('2022-09-10') AS result"""
+ qt_to_monday_2 """SELECT TO_MONDAY('1022-09-10') AS result"""
+ qt_to_monday_3 """SELECT TO_MONDAY('2023-10-09') AS result"""
+ qt_to_monday_4 """SELECT
TO_MONDAY('1970-01-02'),TO_MONDAY('1970-01-01'),TO_MONDAY('1970-01-03'),TO_MONDAY('1970-01-04')"""
+ qt_to_monday_5 """SELECT TO_MONDAY(NULL) AS result"""
+
+ // 82. UNIX_TIMESTAMP function tests
+ qt_unix_timestamp_1 """select unix_timestamp('1970-01-01 +08:00')"""
+ qt_unix_timestamp_3 """select unix_timestamp('2007-11-30 10:30:19')"""
+ qt_unix_timestamp_4 """select unix_timestamp('2007-11-30 10:30:19
+09:00')"""
+ qt_unix_timestamp_5 """select unix_timestamp('2007-11-30 10:30-19',
'%Y-%m-%d %H:%i-%s')"""
+ qt_unix_timestamp_6 """select unix_timestamp('2007-11-30 10:30%3A19',
'%Y-%m-%d')"""
+ qt_unix_timestamp_7 """select unix_timestamp('2007-11-30 10:30%3A19',
'%Y-%m-%d %H:%i%%3A%s')"""
+ qt_unix_timestamp_8 """SELECT UNIX_TIMESTAMP('2015-11-13 10:20:19.123')"""
+ qt_unix_timestamp_9 """select unix_timestamp('1007-11-30 10:30:19')"""
+ qt_unix_timestamp_10 """select unix_timestamp(NULL)"""
+ qt_unix_timestamp_11 """select unix_timestamp('2038-01-19
11:14:08',null)"""
+
+
+
+ // 84. WEEK_CEIL function tests
+ qt_week_ceil_1 """SELECT WEEK_CEIL(cast('2023-07-13 22:28:18' as
datetime)) AS result"""
+ qt_week_ceil_2 """SELECT WEEK_CEIL('2023-07-13 22:28:18', 2) AS result"""
+ qt_week_ceil_3 """SELECT WEEK_CEIL('2023-07-24 22:28:18', 2) AS result"""
+ qt_week_ceil_4 """SELECT WEEK_CEIL(cast('2023-07-13' as date))"""
+ qt_week_ceil_5 """SELECT WEEK_CEIL('2023-07-13', 1, '2023-07-03') AS
result"""
+ qt_week_ceil_6 """SELECT WEEK_CEIL('2023-07-10', 1, '2023-07-10 12:00:00')
AS result"""
+ qt_week_ceil_7 """SELECT WEEK_CEIL(NULL, 1) AS result"""
+
+ // 85. WEEKDAY function tests
+ qt_weekday_1 """SELECT WEEKDAY('2023-10-09')"""
+ qt_weekday_2 """SELECT WEEKDAY('2023-10-15 18:30:00')"""
+ qt_weekday_3 """SELECT WEEKDAY(NULL)"""
+
+ // 86. WEEK_FLOOR function tests
+ qt_week_floor_1 """SELECT WEEK_FLOOR(cast('2023-07-13 22:28:18' as
datetime)) AS result"""
+ qt_week_floor_2 """SELECT WEEK_FLOOR('2023-07-13 22:28:18', 2) AS result"""
+ qt_week_floor_3 """SELECT WEEK_FLOOR('2023-07-10 22:28:18', 2) AS result"""
+ qt_week_floor_4 """SELECT WEEK_FLOOR(cast('2023-07-13' as date)) AS
result"""
+ qt_week_floor_5 """SELECT WEEK_FLOOR('2023-07-13', 1, '2023-07-03') AS
result"""
+ qt_week_floor_6 """SELECT WEEK_FLOOR('2023-07-10', 1, '2023-07-10') AS
result"""
+ qt_week_floor_7 """SELECT WEEK_FLOOR('2023-07-10', 1, '2023-07-10
12:00:00') AS result"""
+ qt_week_floor_8 """SELECT WEEK_FLOOR('2023-07-13', 0) AS result"""
+ qt_week_floor_9 """SELECT WEEK_FLOOR(NULL, 1) AS result"""
+
+ // 87. WEEK function tests
+ qt_week_1 """SELECT WEEK('2020-01-01') AS week_result"""
+ qt_week_2 """SELECT WEEK('2020-07-01', 1) AS week_result"""
+ qt_week_3 """SELECT WEEK('2023-01-01', 0) AS mode_0, WEEK('2023-01-01', 3)
AS mode_3"""
+ qt_week_4 """SELECT WEEK('2023-01-01', 7) AS week_result"""
+ qt_week_5 """SELECT WEEK('2023-01-01', -1) AS week_result"""
+ qt_week_6 """SELECT WEEK('2023-12-31 23:59:59', 3) AS week_result"""
+ qt_week_7 """SELECT WEEK('2023-12-31 23:59:59', NULL),WEEK(NULL,3)"""
+
+ // 88. WEEKOFYEAR function tests
+ qt_weekofyear_1 """SELECT WEEKOFYEAR('2023-05-01') AS week_20230501"""
+ qt_weekofyear_2 """SELECT WEEKOFYEAR('2023-01-02') AS week_20230102"""
+ qt_weekofyear_3 """SELECT WEEKOFYEAR('2023-12-25') AS week_20231225"""
+ qt_weekofyear_4 """select weekofyear('1023-01-04')"""
+ qt_weekofyear_5 """SELECT WEEKOFYEAR('2024-01-01') AS week_20240101"""
+ qt_weekofyear_6 """SELECT WEEKOFYEAR(NULL) AS week_null_input"""
+
+ // 89. WEEKS_ADD function tests
+ qt_weeks_add_1 """SELECT WEEKS_ADD('2023-10-01 08:30:45', 1) AS
add_1_week_datetime"""
+ qt_weeks_add_2 """SELECT WEEKS_ADD('2023-10-01 14:20:10', -1) AS
subtract_1_week_datetime"""
+ qt_weeks_add_3 """SELECT WEEKS_ADD('2023-05-20', 2) AS add_2_week_date"""
+ qt_weeks_add_4 """SELECT WEEKS_ADD('2023-12-25', 1) AS cross_year_add"""
+ qt_weeks_add_5 """SELECT WEEKS_ADD(NULL, 5) AS null_input"""
+
+ // 90. WEEKS_DIFF function tests
+ qt_weeks_diff_1 """SELECT WEEKS_DIFF('2020-12-25', '2020-10-25') AS
diff_date"""
+ qt_weeks_diff_2 """SELECT WEEKS_DIFF('2020-12-25 10:10:02', '2020-10-25
12:10:02') AS diff_datetime"""
+ qt_weeks_diff_3 """SELECT WEEKS_DIFF('2020-12-25 10:10:02', '2020-10-25')
AS diff_mixed"""
+ qt_weeks_diff_4 """SELECT WEEKS_DIFF('2023-10-07', '2023-10-01') AS
diff_6_days"""
+ qt_weeks_diff_5 """SELECT WEEKS_DIFF('2023-10-09', '2023-10-01') AS
diff_8_days"""
+ qt_weeks_diff_6 """SELECT WEEKS_DIFF('2023-10-08 12:00:00', '2023-10-01
00:00:00') AS diff_7_5d, WEEKS_DIFF('2023-10-08 00:00:00', '2023-10-01
12:00:00') AS diff_6_5d"""
+ qt_weeks_diff_7 """SELECT WEEKS_DIFF('2023-10-01', '2023-10-08') AS
diff_negative"""
+ qt_weeks_diff_8 """SELECT WEEKS_DIFF('2024-01-01', '2023-12-25') AS
cross_year"""
+ qt_weeks_diff_9 """SELECT WEEKS_DIFF(NULL, '2023-10-01') AS null_input1,
WEEKS_DIFF('2023-10-01', NULL) AS null_input2"""
+
+ // 91. WEEKS_SUB function tests
+ qt_weeks_sub_1 """SELECT WEEKS_SUB('2023-10-01 08:30:45', 1) AS
sub_1_week_datetime"""
+ qt_weeks_sub_2 """SELECT WEEKS_SUB('2023-09-24 14:20:10', -1) AS
add_1_week_datetime"""
+ qt_weeks_sub_3 """SELECT WEEKS_SUB('2023-06-03', 2) AS sub_2_week_date"""
+ qt_weeks_sub_4 """SELECT WEEKS_SUB('2024-01-01', 1) AS cross_year_sub"""
+ qt_weeks_sub_5 """SELECT WEEKS_SUB(NULL, 5) AS null_input"""
+
+ // Group 7: YEAR_CEIL, YEAR_FLOOR, YEAR, YEAR_OF_WEEK, YEARS_ADD,
YEARS_DIFF, YEARS_SUB, YEARWEEK (序号92-99)
+
+ // 92. YEAR_CEIL function tests
+ qt_year_ceil_1 """SELECT YEAR_CEIL('2023-07-13 22:28:18') AS result"""
+ qt_year_ceil_2 """SELECT YEAR_CEIL('2023-07-13 22:28:18', 5) AS result"""
+ qt_year_ceil_3 """SELECT YEAR_CEIL(cast('2023-07-13' as date)) AS result"""
+ qt_year_ceil_4 """SELECT YEAR_CEIL('2023-07-13', 1, '2020-01-01') AS
result"""
+ qt_year_ceil_5 """SELECT YEAR_CEIL('2023-07-13', 1, '2020-01-01 08:30:00')
AS result"""
+ qt_year_ceil_6 """SELECT YEAR_CEIL('2023-01-01', 1, '2023-01-01') AS
result"""
+ qt_year_ceil_7 """SELECT YEAR_CEIL(NULL, 1) AS result"""
+
+ // 93. YEAR_FLOOR function tests
+ qt_year_floor_1 """SELECT YEAR_FLOOR('2023-07-13 22:28:18') AS result"""
+ qt_year_floor_2 """SELECT YEAR_FLOOR('2023-07-13 22:28:18', 5) AS result"""
+ qt_year_floor_3 """SELECT YEAR_FLOOR(cast('2023-07-13' as date)) AS
result"""
+ qt_year_floor_4 """SELECT YEAR_FLOOR('2023-07-13', 1, '2020-01-01') AS
result"""
+ qt_year_floor_5 """SELECT YEAR_FLOOR('2023-07-13', 1, '2020-01-01
08:30:00') AS result"""
+ qt_year_floor_6 """SELECT YEAR_FLOOR('2023-01-01', 1, '2023-01-01') AS
result"""
+ qt_year_floor_7 """SELECT YEAR_FLOOR('2019-07-13', 1, '2020-01-01') AS
result"""
+ qt_year_floor_8 """SELECT YEAR_FLOOR('2025-07-13', 3, '2020-01-01') AS
result"""
+ qt_year_floor_9 """SELECT YEAR_FLOOR('2023-07-13 06:00:00', 1, '2020-01-01
08:30:00') AS result"""
+ qt_year_floor_10 """SELECT YEAR_FLOOR('2023-07-13 10:00:00', 1,
'2020-01-01 08:30:00') AS result"""
+ qt_year_floor_11 """SELECT YEAR_FLOOR(NULL, 1) AS result"""
+
+ // 94. YEAR function tests
+ qt_year_1 """SELECT YEAR('1987-01-01') AS year_date"""
+ qt_year_2 """SELECT YEAR('2024-05-20 14:30:25') AS year_datetime"""
+ qt_year_3 """SELECT YEAR('2023-02-30') AS invalid_date"""
+ qt_year_4 """SELECT YEAR(NULL) AS null_input"""
+
+ // 95. YEAR_OF_WEEK function tests
+ qt_year_of_week_1 """SELECT YEAR_OF_WEEK('2005-01-01') AS yow_result"""
+ qt_year_of_week_2 """SELECT YOW('2005-01-01') AS yow_alias_result"""
+ qt_year_of_week_3 """SELECT YEAR_OF_WEEK('2005-01-03') AS yow_result"""
+ qt_year_of_week_4 """SELECT YEAR_OF_WEEK('2023-01-01') AS yow_result"""
+ qt_year_of_week_5 """SELECT YEAR_OF_WEEK('2023-01-02') AS yow_result"""
+ qt_year_of_week_6 """SELECT YEAR_OF_WEEK('2005-01-01 15:30:45') AS
yow_datetime"""
+ qt_year_of_week_7 """SELECT YEAR_OF_WEEK('2024-12-30') AS yow_result"""
+ qt_year_of_week_8 """SELECT YEAR_OF_WEEK(NULL) AS yow_null"""
+
+ // 96. YEARS_ADD function tests
+ qt_years_add_1 """SELECT YEARS_ADD('2020-01-31 02:02:02', 1) AS
add_1_year_datetime"""
+ qt_years_add_2 """SELECT YEARS_ADD('2023-05-10 15:40:20', -1) AS
subtract_1_year_datetime"""
+ qt_years_add_3 """SELECT YEARS_ADD('2019-12-25', 3) AS add_3_year_date"""
+ qt_years_add_4 """SELECT YEARS_ADD('2020-02-29', 1) AS leap_day_adjust"""
+ qt_years_add_5 """SELECT YEARS_ADD('2023-01-31', 1) AS month_day_adjust"""
+ qt_years_add_6 """SELECT YEARS_ADD(NULL, 5) AS null_input"""
+
+ // 97. YEARS_DIFF function tests
+ qt_years_diff_1 """SELECT YEARS_DIFF('2020-12-25', '2019-12-25') AS
diff_full_year"""
+ qt_years_diff_2 """SELECT YEARS_DIFF('2020-11-25', '2019-12-25') AS
diff_less_than_year"""
+ qt_years_diff_3 """SELECT YEARS_DIFF('2022-03-15 08:30:00', '2021-03-15
09:10:00') AS diff_datetime"""
+ qt_years_diff_4 """SELECT YEARS_DIFF('2024-05-20', '2020-05-20 12:00:00')
AS diff_mixed"""
+ qt_years_diff_5 """SELECT YEARS_DIFF('2018-06-10', '2020-06-10') AS
diff_negative"""
+ qt_years_diff_6 """SELECT YEARS_DIFF('2024-02-29', '2023-02-28') AS
leap_year_diff"""
+ qt_years_diff_7 """SELECT YEARS_DIFF(NULL, '2023-03-15') AS null_input1,
YEARS_DIFF('2023-03-15', NULL) AS null_input2"""
+
+ // 98. YEARS_SUB function tests
+ qt_years_sub_1 """SELECT YEARS_SUB('2020-02-02 02:02:02', 1) AS
sub_1_year_datetime"""
+ qt_years_sub_2 """SELECT YEARS_SUB('2022-05-10 15:40:20', -1) AS
add_1_year_datetime"""
+ qt_years_sub_3 """SELECT YEARS_SUB('2022-12-25', 3) AS sub_3_year_date"""
+ qt_years_sub_4 """SELECT YEARS_SUB('2020-02-29', 1) AS leap_day_adjust_1"""
+ qt_years_sub_5 """SELECT YEARS_SUB(NULL, 5) AS null_input"""
+
+ // 99. YEARWEEK function tests
+ qt_yearweek_1 """SELECT YEARWEEK('2021-01-01') AS yearweek_mode0"""
+ qt_yearweek_2 """SELECT YEARWEEK('2020-07-01', 1) AS yearweek_mode1"""
+ qt_yearweek_3 """SELECT YEARWEEK('2024-12-30', 1) AS cross_year_mode1"""
+ qt_yearweek_4 """SELECT YEARWEEK('2023-01-02', 5) AS yearweek_mode5"""
+ qt_yearweek_5 """SELECT YEARWEEK('2023-12-25', 1) AS date_type_mode1"""
+
+ // Test constant folding for YEARWEEK function
+ testFoldConst("SELECT YEARWEEK('2021-01-01') AS yearweek_mode0")
+ testFoldConst("SELECT YEARWEEK('2020-07-01', 1) AS yearweek_mode1")
+ testFoldConst("SELECT YEARWEEK('2024-12-30', 1) AS cross_year_mode1")
+ testFoldConst("SELECT YEARWEEK('2023-01-02', 5) AS yearweek_mode5")
+ testFoldConst("SELECT YEARWEEK('2023-12-25', 1) AS date_type_mode1")
+
+ // Test constant folding for Group 1 functions (基础日期函数)
+
+ // 1. CONVERT_TZ function constant folding tests
+ testFoldConst("SELECT CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATETIME),
'Asia/Shanghai', 'America/Los_Angeles')")
+ testFoldConst("SELECT CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATETIME),
'+08:00', 'America/Los_Angeles')")
+ testFoldConst("SELECT CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATE),
'Asia/Shanghai', 'America/Los_Angeles')")
+ testFoldConst("SELECT CONVERT_TZ('2038-01-19 03:14:07', 'GMTaa', 'MET')")
+ testFoldConst("SELECT CONVERT_TZ('2019-08-01 13:21:03.636', '+08:00',
'America/Los_Angeles')")
+ testFoldConst("SELECT CONVERT_TZ(NULL, 'Asia/Shanghai',
'America/Los_Angeles')")
+ testFoldConst("SELECT CONVERT_TZ('2019-08-01 13:21:03', NULL,
'America/Los_Angeles')")
+ testFoldConst("SELECT CONVERT_TZ('2019-08-01 13:21:03', 'Asia/Shanghai',
NULL)")
+ testFoldConst("SELECT CONVERT_TZ('2019-08-01 13:21:03',
'Invalid/Timezone', 'America/Los_Angeles')")
+ testFoldConst("SELECT CONVERT_TZ('2019-08-01 13:21:03', 'Asia/Shanghai',
'Invalid/Timezone')")
+
+ // 2. DATE_ADD function constant folding tests
+ testFoldConst("SELECT DATE_ADD(CAST('2010-11-30 23:59:59' AS DATETIME),
INTERVAL 2 DAY)")
+ testFoldConst("SELECT DATE_ADD(CAST('2023-01-01' AS DATE), INTERVAL 1
QUARTER)")
+ testFoldConst("SELECT DATE_ADD('2023-01-01', INTERVAL 1 WEEK)")
+ testFoldConst("SELECT DATE_ADD('2023-01-31', INTERVAL 1 MONTH)")
+ testFoldConst("SELECT DATE_ADD('2019-01-01', INTERVAL -3 DAY)")
+ testFoldConst("SELECT DATE_ADD('2023-12-31 23:00:00', INTERVAL 2 HOUR)")
+ testFoldConst("SELECT DATE_ADD(NULL, INTERVAL 1 DAY)")
+
+ // 3. DATE_CEIL function constant folding tests
+ testFoldConst("SELECT DATE_CEIL(CAST('2023-07-13 22:28:18' AS DATETIME),
INTERVAL 5 SECOND)")
+ testFoldConst("SELECT DATE_CEIL(CAST('2023-07-13 22:28:18.123' AS
DATETIME(3)), INTERVAL 5 SECOND)")
+ testFoldConst("SELECT DATE_CEIL('2023-07-13 22:28:18', INTERVAL 5 MINUTE)")
+ testFoldConst("SELECT DATE_CEIL('2023-07-13 22:28:18', INTERVAL 5 WEEK)")
+ testFoldConst("SELECT DATE_CEIL('2023-07-13 22:28:18', INTERVAL 5 HOUR)")
+ testFoldConst("SELECT DATE_CEIL('2023-07-13 22:28:18', INTERVAL 5 DAY)")
+ testFoldConst("SELECT DATE_CEIL('2023-07-13 22:28:18', INTERVAL 5 MONTH)")
+ testFoldConst("SELECT DATE_CEIL('2023-07-13 22:28:18', INTERVAL 5 YEAR)")
+ testFoldConst("SELECT DATE_CEIL(NULL, INTERVAL 5 SECOND)")
+ testFoldConst("SELECT DATE_CEIL('2023-07-13 22:28:18', INTERVAL -5
SECOND)")
+
+ // 4. DATEDIFF function constant folding tests
+ testFoldConst("SELECT DATEDIFF(CAST('2007-12-31 23:59:59' AS DATETIME),
CAST('2007-12-30' AS DATETIME))")
+ testFoldConst("SELECT DATEDIFF(CAST('2010-11-30 23:59:59' AS DATETIME),
CAST('2010-12-31' AS DATETIME))")
+ testFoldConst("SELECT DATEDIFF('2023-01-02 13:00:00', '2023-01-01
12:00:00')")
+ testFoldConst("SELECT DATEDIFF('2023-01-02 12:00:00', '2023-01-01
13:00:00')")
+ testFoldConst("SELECT DATEDIFF(NULL, '2023-01-01')")
+
+ // 5. DATE_FLOOR function constant folding tests
+ testFoldConst("SELECT DATE_FLOOR(CAST('0001-01-01 00:00:18' AS DATETIME),
INTERVAL 5 SECOND)")
+ testFoldConst("SELECT DATE_FLOOR(CAST('0001-01-01 00:00:18.123' AS
DATETIME), INTERVAL 5 SECOND)")
+ testFoldConst("SELECT DATE_FLOOR('2023-07-10 00:00:00', INTERVAL 5 DAY)")
+ testFoldConst("SELECT DATE_FLOOR('2023-07-13', INTERVAL 5 YEAR)")
+ testFoldConst("SELECT DATE_FLOOR(NULL, INTERVAL 5 DAY)")
+
+ // 6. DATE_FORMAT function constant folding tests
+ testFoldConst("SELECT DATE_FORMAT('2009-10-04 22:23:00', '%W %M %Y')")
+ testFoldConst("SELECT DATE_FORMAT('2007-10-04 22:23:00', '%H:%i:%s')")
+ testFoldConst("SELECT DATE_FORMAT('1999-01-01', '%Y-%m-%d')")
+ testFoldConst("SELECT DATE_FORMAT('1999-01-01 00:00:00', '%d/%m/%Y
%H:%i:%s')")
+ testFoldConst("SELECT DATE_FORMAT('2009-10-04', '%a %b %c')")
+ testFoldConst("SELECT DATE_FORMAT('2009-10-04', '%D %e %f')")
+ testFoldConst("SELECT DATE_FORMAT(NULL, '%Y-%m-%d')")
+ testFoldConst("SELECT DATE_FORMAT('2009-10-04', NULL)")
+
+ // 7. DATE function constant folding tests
+ testFoldConst("SELECT DATE('2003-12-31 01:02:03')")
+ testFoldConst("SELECT DATE('2003-12-31')")
+ testFoldConst("SELECT DATE(NULL)")
+
+ // 8. DATE_SUB function constant folding tests
+ testFoldConst("SELECT DATE_SUB('2018-05-01', INTERVAL 1 DAY)")
+ testFoldConst("SELECT DATE_SUB('2018-05-01', INTERVAL 1 MONTH)")
+ testFoldConst("SELECT DATE_SUB('2018-05-01', INTERVAL 1 YEAR)")
+ testFoldConst("SELECT DATE_SUB('2018-05-01 12:00:00', INTERVAL 2 HOUR)")
+ testFoldConst("SELECT DATE_SUB(NULL, INTERVAL 1 DAY)")
+
+ // 9. DATE_TRUNC function constant folding tests
+ testFoldConst("SELECT DATE_TRUNC('2019-05-09', 'year')")
+ testFoldConst("SELECT DATE_TRUNC('2019-05-09', 'month')")
+ testFoldConst("SELECT DATE_TRUNC('2019-05-09 12:30:45', 'day')")
+ testFoldConst("SELECT DATE_TRUNC('2019-05-09 12:30:45', 'hour')")
+ testFoldConst("SELECT DATE_TRUNC(NULL, 'day')")
+
+ // Test constant folding for Group 2 functions (Day functions and related)
+
+ // 13. DAY_CEIL function constant folding tests
+ testFoldConst("SELECT DAY_CEIL(CAST('2023-07-13 22:28:18' AS DATETIME),
5)")
+ testFoldConst("SELECT DAY_CEIL('2023-07-13 22:28:18.123', 5)")
+ testFoldConst("SELECT DAY_CEIL('2023-07-13 22:28:18')")
+ testFoldConst("SELECT DAY_CEIL('2023-07-13 22:28:18', 7, '2023-01-01
00:00:00')")
+ testFoldConst("SELECT DAY_CEIL(CAST('2023-07-13' AS DATE), 3)")
+ testFoldConst("SELECT DAY_CEIL('2023-07-13', 0)")
+ testFoldConst("SELECT DAY_CEIL(NULL, 5)")
+
+ // 14. DAY_FLOOR function constant folding tests
+ testFoldConst("SELECT DAY_FLOOR('2023-07-13 22:28:18', 5)")
+ testFoldConst("SELECT DAY_FLOOR('2023-07-13 22:28:18.123', 5)")
+ testFoldConst("SELECT DAY_FLOOR('2023-07-13 22:28:18')")
+ testFoldConst("SELECT DAY_FLOOR('2023-07-13 22:28:18', 7, '2023-01-01
00:00:00')")
+ testFoldConst("SELECT DAY_FLOOR(CAST('2023-07-13' AS DATE), 3)")
+ testFoldConst("SELECT DAY_FLOOR(NULL, 5)")
+
+ // 15. DAY function constant folding tests
+ testFoldConst("SELECT DAY('1987-01-31')")
+ testFoldConst("SELECT DAY('2023-07-13 22:28:18')")
+ testFoldConst("SELECT DAY(NULL)")
+
+ // 16. DAYNAME function constant folding tests
+ testFoldConst("SELECT DAYNAME('2007-02-03 00:00:00')")
+ testFoldConst("SELECT DAYNAME('2023-10-01')")
+ testFoldConst("SELECT DAYNAME(NULL)")
+
+ // 17. DAYOFWEEK function constant folding tests
+ testFoldConst("SELECT DAYOFWEEK('2019-06-25')")
+ testFoldConst("SELECT DAYOFWEEK('2019-06-25 15:30:45')")
+ testFoldConst("SELECT DAYOFWEEK('2024-02-18')")
+ testFoldConst("SELECT DAYOFWEEK(NULL)")
+
+ // 18. DAYOFYEAR function constant folding tests
+ testFoldConst("SELECT DAYOFYEAR('2007-02-03 00:00:00')")
+ testFoldConst("SELECT DAYOFYEAR('2023-12-31')")
+ testFoldConst("SELECT DAYOFYEAR('2024-12-31')")
+ testFoldConst("SELECT DAYOFYEAR(NULL)")
+
+ // 19. EXTRACT function constant folding tests
+ testFoldConst("SELECT EXTRACT(year from '2022-09-22 17:01:30') as year,
EXTRACT(month from '2022-09-22 17:01:30') as month, EXTRACT(day from
'2022-09-22 17:01:30') as day")
+ testFoldConst("SELECT EXTRACT(quarter from '2023-05-15') as quarter")
+ testFoldConst("SELECT EXTRACT(week from '2024-01-06') as week")
+ testFoldConst("SELECT EXTRACT(week from '2024-01-07') as week")
+ testFoldConst("SELECT EXTRACT(week from '2024-12-31') as week")
+
+ // 20. FROM_DAYS function constant folding tests
+ testFoldConst("SELECT FROM_DAYS(730669)")
+ testFoldConst("SELECT FROM_DAYS(365)")
+ testFoldConst("SELECT FROM_DAYS(-10)")
+ testFoldConst("SELECT FROM_DAYS(NULL)")
+
+ // 21. FROM_ISO8601_DATE function constant folding tests
+ testFoldConst("SELECT FROM_ISO8601_DATE('2023') as year_only")
+ testFoldConst("SELECT FROM_ISO8601_DATE('2023-10') as year_month")
+ testFoldConst("SELECT FROM_ISO8601_DATE('2023-10-05') as full_date")
+ testFoldConst("SELECT FROM_ISO8601_DATE('2021-001') as day_1")
+ testFoldConst("SELECT FROM_ISO8601_DATE('2021-060') as day_60")
+ testFoldConst("SELECT FROM_ISO8601_DATE('2024-366') as day_366")
+ testFoldConst("SELECT FROM_ISO8601_DATE('0522-W01-1') as week_1")
+ testFoldConst("SELECT FROM_ISO8601_DATE('2023-10-01T12:34:10')")
+ testFoldConst("SELECT FROM_ISO8601_DATE('0522-661') as day_661")
+ testFoldConst("SELECT FROM_ISO8601_DATE('invalid-date')")
+ testFoldConst("SELECT FROM_ISO8601_DATE(NULL)")
+
+ // 22. FROM_MILLISECOND function constant folding tests
+ testFoldConst("SELECT FROM_MILLISECOND(1618236845000)")
+ testFoldConst("SELECT FROM_MILLISECOND(0)")
+ testFoldConst("SELECT FROM_MILLISECOND(NULL)")
+
+ // 23. FROM_SECOND_TIMESTAMP function constant folding tests
+ testFoldConst("SELECT FROM_SECOND(1618236845)")
+ testFoldConst("SELECT FROM_SECOND(0)")
+ testFoldConst("SELECT FROM_SECOND(NULL)")
+
+ // 24. FROM_UNIXTIME function constant folding tests
+ testFoldConst("SELECT FROM_UNIXTIME(0)")
+ testFoldConst("SELECT FROM_UNIXTIME(1196440219)")
+ testFoldConst("SELECT FROM_UNIXTIME(1196440219, 'yyyy-MM-dd HH:mm:ss')")
+ testFoldConst("SELECT FROM_UNIXTIME(1196440219, '%Y-%m-%d')")
+ testFoldConst("SELECT FROM_UNIXTIME(1196440219, '%Y-%m-%d %H:%i:%s')")
+ testFoldConst("SELECT FROM_UNIXTIME(32536799, 'gdaskpdp')")
+ testFoldConst("SELECT FROM_UNIXTIME(NULL)")
+
+ // Group 3: Hour functions (序号24-29)
+
+ // 24. HOUR_CEIL function constant folding tests
+ testFoldConst("SELECT HOUR_CEIL('2023-07-13 22:28:18')")
+ testFoldConst("SELECT HOUR_CEIL('2023-07-13 22:28:18', 5)")
+ testFoldConst("SELECT HOUR_CEIL('2023-07-13 22:28:18', 5, '2023-07-13
20:00:00')")
+ testFoldConst("SELECT HOUR_CEIL(CAST('2023-07-13' AS DATE), 3)")
+ testFoldConst("SELECT HOUR_CEIL('2023-07-13 22:28:18', 0)")
+ testFoldConst("SELECT HOUR_CEIL(NULL, 5)")
+ testFoldConst("SELECT HOUR_CEIL('2023-07-13 22:28:18', NULL)")
+
+ // 25. HOUR_FLOOR function constant folding tests
+ testFoldConst("SELECT HOUR_FLOOR('2023-07-13 22:28:18')")
+ testFoldConst("SELECT HOUR_FLOOR('2023-07-13 22:28:18', 5)")
+ testFoldConst("SELECT HOUR_FLOOR('2023-07-13 22:28:18', 5, '2023-07-13
20:00:00')")
+ testFoldConst("SELECT HOUR_FLOOR(CAST('2023-07-13' AS DATE), 3)")
+ testFoldConst("SELECT HOUR_FLOOR(NULL, 5)")
+
+ // 26. HOUR function constant folding tests
+ testFoldConst("SELECT HOUR('2018-12-31 23:59:59')")
+ testFoldConst("SELECT HOUR('2023-01-01 00:00:00')")
+ testFoldConst("SELECT HOUR('2023-10-01 12:30:45')")
+ testFoldConst("SELECT HOUR('14:25:30')")
+ testFoldConst("SELECT HOUR('2023-07-13')")
+ testFoldConst("SELECT HOUR(NULL)")
+
+ // 27. HOURS_ADD function constant folding tests
+ testFoldConst("SELECT HOURS_ADD('2020-02-02 02:02:02', 1)")
+ testFoldConst("SELECT HOURS_ADD('2023-07-13 22:28:18', 5)")
+ testFoldConst("SELECT HOURS_ADD('2023-07-13 22:28:18', -3)")
+ testFoldConst("SELECT HOURS_ADD(NULL, 1)")
+ testFoldConst("SELECT HOURS_ADD('2023-07-13 22:28:18', NULL)")
+
+ // 28. HOURS_DIFF function constant folding tests
+ testFoldConst("SELECT HOURS_DIFF('2020-12-25 22:00:00', '2020-12-25
21:00:00')")
+ testFoldConst("SELECT HOURS_DIFF('2023-07-14', '2023-07-13')")
+ testFoldConst("SELECT HOURS_DIFF('2023-07-13 12:30:59', '2023-07-13
13:30:01')")
+ testFoldConst("SELECT HOURS_DIFF(NULL, '2020-12-25 21:00:00')")
+ testFoldConst("SELECT HOURS_DIFF('2020-12-25 22:00:00', NULL)")
+
+ // 29. HOURS_SUB function constant folding tests
+ testFoldConst("SELECT HOURS_SUB('2020-02-02 02:02:02', 1)")
+ testFoldConst("SELECT HOURS_SUB('2023-07-13 22:28:18', 5)")
+ testFoldConst("SELECT HOURS_SUB('2023-07-13 22:28:18', -3)")
+ testFoldConst("SELECT HOURS_SUB(NULL, 1)")
+ testFoldConst("SELECT HOURS_SUB('2023-07-13 22:28:18', NULL)")
+
+ // Other functions in Group 2 (序号30-39)
+
+ // 30. MAKEDATE function constant folding tests
+ testFoldConst("SELECT MAKEDATE(2023, 100)")
+ testFoldConst("SELECT MAKEDATE(2021, 365)")
+ testFoldConst("SELECT MAKEDATE(NULL, 100)")
+ testFoldConst("SELECT MAKEDATE(2023, NULL)")
+
+ // 32. MICROSECONDS_ADD function constant folding tests
+ testFoldConst("SELECT MICROSECONDS_ADD('2020-02-02 02:02:02', 1000000)")
+ testFoldConst("SELECT MICROSECONDS_ADD('2023-10-01 12:30:45.123456',
500000)")
+ testFoldConst("SELECT MICROSECONDS_ADD('2023-10-01 10:00:00', -1000000)")
+
+ // 33. MICROSECONDS_DIFF function constant folding tests
+ testFoldConst("SELECT MICROSECONDS_DIFF('2020-12-25 22:00:00.123456',
'2020-12-25 22:00:00.000000')")
+ testFoldConst("SELECT MICROSECONDS_DIFF('2023-06-15 10:30:00', '2023-06-15
10:29:59')")
+
+ // 34. MICROSECONDS_SUB function constant folding tests
+ testFoldConst("SELECT MICROSECONDS_SUB('2020-02-02 02:02:02.123456',
500000)")
+ testFoldConst("SELECT MICROSECONDS_SUB('2023-10-01 12:30:45', 1000000)")
+ testFoldConst("SELECT MICROSECONDS_SUB('2023-10-01 10:00:00', -500000)")
+
+ // 35. MICROSECOND_TIMESTAMP function constant folding tests
+ testFoldConst("SELECT MICROSECOND_TIMESTAMP('2025-01-23 12:34:56.123456')")
+ testFoldConst("SELECT MICROSECOND_TIMESTAMP('1970-01-01')")
+
+ // 36. MICROSECOND function constant folding tests
+ testFoldConst("SELECT MICROSECOND('2019-01-01 00:00:00.123456')")
+ testFoldConst("SELECT MICROSECOND(CAST('14:30:25.123456' AS TIME))")
+ testFoldConst("SELECT MICROSECOND('2019-01-01 00:00:00')")
+ testFoldConst("SELECT MICROSECOND('2019-01-01')")
+ testFoldConst("SELECT MICROSECOND('2023-05-01 10:05:30.999999')")
+
+ // 38. MILLISECONDS_ADD function constant folding tests
+ testFoldConst("SELECT MILLISECONDS_ADD('2020-02-02 02:02:02', 1000)")
+ testFoldConst("SELECT MILLISECONDS_ADD('2023-10-01 12:30:45.123', 500)")
+ testFoldConst("SELECT MILLISECONDS_ADD('2023-10-01 10:00:00', -1000)")
+
+ // 39. MILLISECONDS_DIFF function constant folding tests
+ testFoldConst("SELECT MILLISECONDS_DIFF('2020-12-25 22:00:00.123',
'2020-12-25 22:00:00.000')")
+ testFoldConst("SELECT MILLISECONDS_DIFF('2023-06-15 10:30:00', '2023-06-15
10:29:59')")
+
+ // Test constant folding for Group 3 remaining functions
+
+ // 40. MILLISECONDS_SUB function constant folding tests
+ testFoldConst("SELECT MILLISECONDS_SUB('2020-02-02 02:02:02.123', 500)")
+ testFoldConst("SELECT MILLISECONDS_SUB('2023-10-01 12:30:45', 1000)")
+ testFoldConst("SELECT MILLISECONDS_SUB('2023-10-01 10:00:00', -500)")
+
+ // 41. MILLISECONDS_DIFF function constant folding tests (additional)
+ testFoldConst("SELECT MILLISECONDS_DIFF('2020-03-01 00:00:00.500',
'2020-02-29 23:59:59.000')")
+
+ // 43. MILLISECOND_TIMESTAMP function constant folding tests
+ testFoldConst("SELECT MILLISECOND_TIMESTAMP('2025-01-23 12:34:56.123')")
+ testFoldConst("SELECT MILLISECOND_TIMESTAMP('2024-01-01 00:00:00.123456')")
+ testFoldConst("SELECT MILLISECOND_TIMESTAMP('1970-01-01')")
+
+ // Test constant folding for Group 4 functions (Minute and Month functions)
+
+ // 44. MINUTE_CEIL function constant folding tests
+ testFoldConst("SELECT MINUTE_CEIL('2023-07-13 22:28:18')")
+ testFoldConst("SELECT MINUTE_CEIL('2023-07-13 22:28:18.123', 5)")
+ testFoldConst("SELECT MINUTE_CEIL('2023-07-13 22:28:18', 5, '2023-07-13
22:20:00')")
+ testFoldConst("SELECT MINUTE_CEIL(CAST('2023-07-13' AS DATE), 30)")
+
+ // 45. MINUTE_FLOOR function constant folding tests
+ testFoldConst("SELECT MINUTE_FLOOR('2023-07-13 22:28:18')")
+ testFoldConst("SELECT MINUTE_FLOOR('2023-07-13 22:28:18.123', 5)")
+ testFoldConst("SELECT MINUTE_FLOOR('2023-07-13 22:28:18', 5, '2023-07-13
22:20:00')")
+ testFoldConst("SELECT MINUTE_FLOOR(CAST('2023-07-13' AS DATE), 30)")
+
+ // 46. MINUTE function constant folding tests
+ testFoldConst("SELECT MINUTE('2018-12-31 23:59:59')")
+ testFoldConst("SELECT MINUTE('2023-05-01 10:05:30.123456')")
+ testFoldConst("SELECT MINUTE('14:25:45')")
+ testFoldConst("SELECT MINUTE('2023-07-13')")
+
+ // 47. MINUTES_ADD function constant folding tests
+ testFoldConst("SELECT MINUTES_ADD('2020-02-02', 1)")
+ testFoldConst("SELECT MINUTES_ADD('2023-07-13 22:28:18', 5)")
+ testFoldConst("SELECT MINUTES_ADD('2023-07-13 22:28:18', -5)")
+
+ // 48. MINUTES_DIFF function constant folding tests
+ testFoldConst("SELECT MINUTES_DIFF('2020-12-25 22:00:00', '2020-12-25
21:00:00')")
+ testFoldConst("SELECT MINUTES_DIFF('2023-07-13 21:50:00', '2023-07-13
22:00:00')")
+ testFoldConst("SELECT MINUTES_DIFF('2023-07-14', '2023-07-13')")
+
+ // 49. MINUTES_SUB function constant folding tests
+ testFoldConst("SELECT MINUTES_SUB('2020-02-02 02:02:02', 1)")
+ testFoldConst("SELECT MINUTES_SUB('2023-07-13 22:38:18.456789', 10)")
+ testFoldConst("SELECT MINUTES_SUB('2023-07-13 22:23:18', -5)")
+
+ // Month functions (序号50-57)
+
+ // 50. MONTH_CEIL function constant folding tests
+ testFoldConst("SELECT MONTH_CEIL('2023-07-13 22:28:18')")
+ testFoldConst("SELECT MONTH_CEIL('2023-07-13 22:28:18', 5)")
+ testFoldConst("SELECT MONTH_CEIL('2023-07-13 22:28:18', 5, '2023-01-01
00:00:00')")
+ testFoldConst("SELECT MONTH_CEIL(CAST('2023-07-13' AS DATE), 3)")
+
+ // 51. MONTH_FLOOR function constant folding tests
+ testFoldConst("SELECT MONTH_FLOOR('2023-07-13 22:28:18')")
+ testFoldConst("SELECT MONTH_FLOOR('2023-07-13 22:28:18', 5)")
+ testFoldConst("SELECT MONTH_FLOOR('2023-07-13 22:28:18', 5, '2023-01-01
00:00:00')")
+ testFoldConst("SELECT MONTH_FLOOR(CAST('2023-07-13' AS DATE), 3)")
+
+ // 52. MONTH function constant folding tests
+ testFoldConst("SELECT MONTH('1987-01-01')")
+ testFoldConst("SELECT MONTH('2023-07-13 22:28:18')")
+ testFoldConst("SELECT MONTH('2023-12-05 10:15:30.456789')")
+
+ // 53. MONTHNAME function constant folding tests
+ testFoldConst("SELECT MONTHNAME('2008-02-03')")
+ testFoldConst("SELECT MONTHNAME('2023-07-13 22:28:18')")
+
+ // 54. MONTHS_ADD function constant folding tests
+ testFoldConst("SELECT MONTHS_ADD('2020-01-31', 1)")
+ testFoldConst("SELECT MONTHS_ADD('2020-01-31 02:02:02', 1)")
+ testFoldConst("SELECT MONTHS_ADD('2020-01-31', -1)")
+ testFoldConst("SELECT MONTHS_ADD('2023-07-13 22:28:18', 5)")
+
+ // 55. MONTHS_BETWEEN function constant folding tests
+ testFoldConst("SELECT MONTHS_BETWEEN('2020-12-26', '2020-10-25')")
+ testFoldConst("SELECT MONTHS_BETWEEN('2020-12-26 15:30:00', '2020-10-25
08:15:00')")
+ testFoldConst("SELECT MONTHS_BETWEEN('2024-02-29', '2024-01-31')")
+ testFoldConst("SELECT MONTHS_BETWEEN('2024-03-15', '2024-01-15')")
+
+ // 56. MONTHS_DIFF function constant folding tests
+ testFoldConst("SELECT MONTHS_DIFF('2020-03-28', '2020-02-29')")
+ testFoldConst("SELECT MONTHS_DIFF('2020-03-29', '2020-02-29')")
+ testFoldConst("SELECT MONTHS_DIFF('2020-03-30', '2020-02-29')")
+ testFoldConst("SELECT MONTHS_DIFF('2023-07-15', '2023-07-30')")
+
+ // 57. MONTHS_SUB function constant folding tests
+ testFoldConst("SELECT MONTHS_SUB('2020-01-31', 1)")
+ testFoldConst("SELECT MONTHS_SUB('2020-01-31 02:02:02', 1)")
+ testFoldConst("SELECT MONTHS_SUB('2020-01-31', -1)")
+ testFoldConst("SELECT MONTHS_SUB('2023-07-13 22:28:18', 5)")
+
+ // Other Group 4 functions (序号58, 60-62)
+
+ // 58. NEXT_DAY function constant folding tests
+ testFoldConst("SELECT NEXT_DAY('2020-01-31', 'MONDAY')")
+ testFoldConst("SELECT NEXT_DAY('2020-01-31 02:02:02', 'MON')")
+ testFoldConst("SELECT NEXT_DAY('2023-07-17', 'MON')")
+ testFoldConst("SELECT NEXT_DAY('2023-07-13', 'FR')")
+
+ // 60. QUARTER function constant folding tests
+ testFoldConst("SELECT QUARTER('2025-01-16')")
+ testFoldConst("SELECT QUARTER('2025-01-16 01:11:10')")
+ testFoldConst("SELECT QUARTER('2023-05-20')")
+ testFoldConst("SELECT QUARTER('2024-09-30 23:59:59')")
+ testFoldConst("SELECT QUARTER('2022-12-01')")
+
+ // 61. QUARTERS_ADD function constant folding tests
+ testFoldConst("SELECT QUARTERS_ADD('2020-01-31', 1)")
+ testFoldConst("SELECT QUARTERS_ADD('2020-01-31 02:02:02', 1)")
+ testFoldConst("SELECT QUARTERS_ADD('2020-04-30', -1)")
+ testFoldConst("SELECT QUARTERS_ADD('2023-07-13 22:28:18', 2)")
+ testFoldConst("SELECT QUARTERS_ADD('2023-10-01', 2)")
+
+ // 62. QUARTERS_SUB function constant folding tests
+ testFoldConst("SELECT QUARTERS_SUB('2020-01-31', 1)")
+ testFoldConst("SELECT QUARTERS_SUB('2020-01-31 02:02:02', 1)")
+ testFoldConst("SELECT QUARTERS_SUB('2019-10-31', -1)")
+ testFoldConst("SELECT QUARTERS_SUB('2023-07-13 22:28:18', 2)")
+ testFoldConst("SELECT QUARTERS_SUB('2024-04-01', 2)")
+
+ // Test constant folding for Group 5 functions (Second and time
manipulation functions)
+
+ // 63. SECOND_CEIL function constant folding tests
+ testFoldConst("SELECT SECOND_CEIL('2025-01-23 12:34:56')")
+ testFoldConst("SELECT SECOND_CEIL('2025-01-23 12:34:56', 5)")
+ testFoldConst("SELECT SECOND_CEIL('2025-01-23 12:34:56', 10, '2025-01-23
12:00:00')")
+ testFoldConst("SELECT SECOND_CEIL('2025-01-23 12:34:56.789', 5)")
+
+ // 64. SECOND_FLOOR function constant folding tests
+ testFoldConst("SELECT SECOND_FLOOR('2025-01-23 12:34:56')")
+ testFoldConst("SELECT SECOND_FLOOR('2025-01-23 12:34:56', 5)")
+ testFoldConst("SELECT SECOND_FLOOR('2025-01-23 12:34:56', 10, '2025-01-23
12:00:00')")
+ testFoldConst("SELECT SECOND_FLOOR('2025-01-23 12:34:56.789', 5)")
+
+ // 65. SECOND function constant folding tests
+ testFoldConst("SELECT SECOND('2018-12-31 23:59:59')")
+ testFoldConst("SELECT SECOND(CAST('15:42:33' AS TIME))")
+ testFoldConst("SELECT SECOND('2023-07-13')")
+ testFoldConst("SELECT SECOND('2023-07-13 10:30:25.123456')")
+ testFoldConst("SELECT SECOND('2024-01-01 00:00:00')")
+
+ // 66. SECONDS_ADD function constant folding tests
+ testFoldConst("SELECT SECONDS_ADD('2025-01-23 12:34:56', 30)")
+ testFoldConst("SELECT SECONDS_ADD('2025-01-23 12:34:56', -30)")
+ testFoldConst("SELECT SECONDS_ADD('2023-07-13 23:59:50', 15)")
+ testFoldConst("SELECT SECONDS_ADD('2023-01-01', 3600)")
+
+ // 67. SECONDS_DIFF function constant folding tests
+ testFoldConst("SELECT SECONDS_DIFF('2025-01-23 12:35:56', '2025-01-23
12:34:56')")
+ testFoldConst("SELECT SECONDS_DIFF('2023-01-01 00:00:00', '2023-01-01
00:01:00')")
+ testFoldConst("SELECT SECONDS_DIFF('2023-01-02', '2023-01-01')")
+ testFoldConst("SELECT SECONDS_DIFF('2023-07-13 12:00:00.123', '2023-07-13
11:59:59')")
+
+ // 68. SECONDS_SUB function constant folding tests
+ testFoldConst("SELECT SECONDS_SUB('2025-01-23 12:34:56', 30)")
+ testFoldConst("SELECT SECONDS_SUB('2025-01-23 12:34:56', -30)")
+ testFoldConst("SELECT SECONDS_SUB('2023-07-14 00:00:10', 15)")
+ testFoldConst("SELECT SECONDS_SUB('2023-01-01', 3600)")
+
+ // 69. SECOND_TIMESTAMP function constant folding tests
+ testFoldConst("SELECT SECOND_TIMESTAMP('1970-01-01 00:00:00 UTC')")
+ testFoldConst("SELECT SECOND_TIMESTAMP('2025-01-23 12:34:56')")
+ testFoldConst("SELECT SECOND_TIMESTAMP('2023-01-01')")
+ testFoldConst("SELECT SECOND_TIMESTAMP('2023-07-13 22:28:18.456789')")
+
+ // 70. SEC_TO_TIME function constant folding tests
+ testFoldConst("SELECT SEC_TO_TIME(59738)")
+ testFoldConst("SELECT SEC_TO_TIME(90061)")
+ testFoldConst("SELECT SEC_TO_TIME(-3600)")
+ testFoldConst("SELECT SEC_TO_TIME(0)")
+ testFoldConst("SELECT SEC_TO_TIME(3661.9)")
+
+ // 71. STR_TO_DATE function constant folding tests
+ testFoldConst("SELECT STR_TO_DATE('2025-01-23 12:34:56', '%Y-%m-%d
%H:%i:%s')")
+ testFoldConst("SELECT STR_TO_DATE('2025-01-23 12:34:56', 'yyyy-MM-dd
HH:mm:ss')")
+ testFoldConst("SELECT STR_TO_DATE('20230713', 'yyyyMMdd')")
+ testFoldConst("SELECT STR_TO_DATE('15:30:45', '%H:%i:%s')")
+ testFoldConst("SELECT STR_TO_DATE('200442 Monday', '%X%V %W')")
+ testFoldConst("SELECT STR_TO_DATE('Oct 5 2023 3:45:00 PM', '%b %d %Y
%h:%i:%s %p')")
+ testFoldConst("SELECT STR_TO_DATE('2023-01-01 10:00:00 (GMT)', '%Y-%m-%d
%H:%i:%s')")
+ testFoldConst("SELECT STR_TO_DATE('2023-07-13 12:34:56.789', '%Y-%m-%d
%H:%i:%s.%f')")
+ testFoldConst("SELECT STR_TO_DATE('2023-01-01', '')")
+
+ // 72. TIMEDIFF function constant folding tests
+ testFoldConst("SELECT TIMEDIFF('2024-07-20 16:59:30', '2024-07-11
16:35:21')")
+ testFoldConst("SELECT TIMEDIFF('2023-10-05 15:45:00', '2023-10-05')")
+ testFoldConst("SELECT TIMEDIFF('2023-01-01 09:00:00', '2023-01-01
10:30:00')")
+ testFoldConst("SELECT TIMEDIFF('2023-12-31 23:59:59', '2023-12-31
23:59:50')")
+
+ // 73. TIME function constant folding tests
+ testFoldConst("SELECT TIME('2025-1-1 12:12:12')")
+
+ // 74. TIMESTAMPADD function constant folding tests
+ testFoldConst("SELECT TIMESTAMPADD(MINUTE, 1, '2019-01-02')")
+ testFoldConst("SELECT TIMESTAMPADD(WEEK, 1, '2019-01-02')")
+ testFoldConst("SELECT TIMESTAMPADD(HOUR, -3, '2023-07-13 10:30:00')")
+ testFoldConst("SELECT TIMESTAMPADD(MONTH, 1, '2023-01-31')")
+ testFoldConst("SELECT TIMESTAMPADD(YEAR, 1, '2023-12-31 23:59:59')")
+
+ // 75. TIMESTAMPDIFF function constant folding tests
+ testFoldConst("SELECT TIMESTAMPDIFF(MONTH, '2003-02-01', '2003-05-01')")
+ testFoldConst("SELECT TIMESTAMPDIFF(YEAR, '2002-05-01', '2001-01-01')")
+ testFoldConst("SELECT TIMESTAMPDIFF(MINUTE, '2003-02-01', '2003-05-01
12:05:55')")
+ testFoldConst("SELECT TIMESTAMPDIFF(DAY, '2023-12-31 23:59:50',
'2024-01-01 00:00:05')")
+ testFoldConst("SELECT TIMESTAMPDIFF(MONTH, '2023-01-31', '2023-02-28')")
+ testFoldConst("SELECT TIMESTAMPDIFF(MONTH, '2023-01-31', '2023-02-27')")
+ testFoldConst("SELECT TIMESTAMPDIFF(WEEK, '2023-01-01', '2023-01-15')")
+
+ // 76. TIMESTAMP function constant folding tests
+ testFoldConst("SELECT TIMESTAMP('2019-01-01 12:00:00')")
+ testFoldConst("SELECT TIMESTAMP('2019-01-01')")
+
+ // 77. TIME_TO_SEC function constant folding tests
+ testFoldConst("SELECT TIME_TO_SEC('16:32:18')")
+ testFoldConst("SELECT TIME_TO_SEC('2025-01-01 16:32:18')")
+ testFoldConst("SELECT TIME_TO_SEC('-02:30:00')")
+ testFoldConst("SELECT TIME_TO_SEC('-16:32:18.99')")
+ testFoldConst("SELECT TIME_TO_SEC('10:15:30.123456')")
+ testFoldConst("SELECT TIME_TO_SEC('12:60:00')")
+ testFoldConst("SELECT TIME_TO_SEC('839:00:00')")
+
+ // Test constant folding for Group 6 functions (TO_DATE, TO_DAYS,
TO_ISO8601, TO_MONDAY, UNIX_TIMESTAMP, UTC_TIMESTAMP, WEEK functions)
+
+ // 78. TO_DATE function constant folding tests
+ testFoldConst("SELECT TO_DATE('2020-02-02 00:00:00')")
+ testFoldConst("SELECT TO_DATE('2020-02-02')")
+
+ // 79. TO_DAYS function constant folding tests
+ testFoldConst("SELECT TO_DAYS('2007-10-07')")
+ testFoldConst("SELECT TO_DAYS('2007-10-07 10:03:09')")
+
+ // 80. TO_ISO8601 function constant folding tests
+ testFoldConst("SELECT TO_ISO8601(CAST('2023-10-05' AS DATE)) AS
date_result")
+ testFoldConst("SELECT TO_ISO8601(CAST('2020-01-01 12:30:45' AS DATETIME))
AS datetime_result")
+ testFoldConst("SELECT TO_ISO8601(CAST('2020-01-01 12:30:45.956' AS
DATETIME)) AS datetime_result")
+
+ // 81. TO_MONDAY function constant folding tests
+ testFoldConst("SELECT TO_MONDAY('2022-09-10') AS result")
+ testFoldConst("SELECT TO_MONDAY('1022-09-10') AS result")
+ testFoldConst("SELECT TO_MONDAY('2023-10-09') AS result")
+ testFoldConst("SELECT TO_MONDAY('1970-01-02'), TO_MONDAY('1970-01-01'),
TO_MONDAY('1970-01-03'), TO_MONDAY('1970-01-04')")
+
+ // 82. UNIX_TIMESTAMP function constant folding tests
+ testFoldConst("SELECT UNIX_TIMESTAMP('1970-01-01 +08:00')")
+ testFoldConst("SELECT UNIX_TIMESTAMP('2007-11-30 10:30:19')")
+ testFoldConst("SELECT UNIX_TIMESTAMP('2007-11-30 10:30:19 +09:00')")
+ testFoldConst("SELECT UNIX_TIMESTAMP('2007-11-30 10:30-19', '%Y-%m-%d
%H:%i-%s')")
+ testFoldConst("SELECT UNIX_TIMESTAMP('2007-11-30 10:30%3A19', '%Y-%m-%d')")
+ testFoldConst("SELECT UNIX_TIMESTAMP('2007-11-30 10:30%3A19', '%Y-%m-%d
%H:%i%%3A%s')")
+ testFoldConst("SELECT UNIX_TIMESTAMP('2015-11-13 10:20:19.123')")
+ testFoldConst("SELECT UNIX_TIMESTAMP('1007-11-30 10:30:19')")
+ testFoldConst("SELECT UNIX_TIMESTAMP('2038-01-19 11:14:08', NULL)")
+
+ // 84. WEEK_CEIL function constant folding tests
+ testFoldConst("SELECT WEEK_CEIL(CAST('2023-07-13 22:28:18' AS DATETIME))
AS result")
+ testFoldConst("SELECT WEEK_CEIL('2023-07-13 22:28:18', 2) AS result")
+ testFoldConst("SELECT WEEK_CEIL('2023-07-13', 1, '2023-07-03') AS result")
+ testFoldConst("SELECT WEEK_CEIL(CAST('2023-07-13' AS DATE))")
+
+ // 85. WEEKDAY function constant folding tests
+ testFoldConst("SELECT WEEKDAY('2023-10-09')")
+ testFoldConst("SELECT WEEKDAY('2023-10-15 18:30:00')")
+
+ // 86. WEEK_FLOOR function constant folding tests
+ testFoldConst("SELECT WEEK_FLOOR(CAST('2023-07-13 22:28:18' AS DATETIME))
AS result")
+ testFoldConst("SELECT WEEK_FLOOR('2023-07-13 22:28:18', 2) AS result")
+ testFoldConst("SELECT WEEK_FLOOR('2023-07-13', 1, '2023-07-03') AS result")
+ testFoldConst("SELECT WEEK_FLOOR(CAST('2023-07-13' AS DATE)) AS result")
+
+ // 87. WEEK function constant folding tests
+ testFoldConst("SELECT WEEK('2020-01-01') AS week_result")
+ testFoldConst("SELECT WEEK('2020-07-01', 1) AS week_result")
+ testFoldConst("SELECT WEEK('2023-01-01', 0) AS mode_0, WEEK('2023-01-01',
3) AS mode_3")
+ testFoldConst("SELECT WEEK('2023-01-01', 7) AS week_result")
+ testFoldConst("SELECT WEEK('2023-01-01', -1) AS week_result")
+ testFoldConst("SELECT WEEK('2023-12-31 23:59:59', 3) AS week_result")
+
+ // 88. WEEKOFYEAR function constant folding tests
+ testFoldConst("SELECT WEEKOFYEAR('2023-05-01') AS week_20230501")
+ testFoldConst("SELECT WEEKOFYEAR('2023-01-02') AS week_20230102")
+ testFoldConst("SELECT WEEKOFYEAR('2023-12-25') AS week_20231225")
+ testFoldConst("SELECT WEEKOFYEAR('1023-01-04')")
+ testFoldConst("SELECT WEEKOFYEAR('2024-01-01') AS week_20240101")
+
+ // 89. WEEKS_ADD function constant folding tests
+ testFoldConst("SELECT WEEKS_ADD('2023-10-01 08:30:45', 1) AS
add_1_week_datetime")
+ testFoldConst("SELECT WEEKS_ADD('2023-10-01 14:20:10', -1) AS
subtract_1_week_datetime")
+ testFoldConst("SELECT WEEKS_ADD('2023-05-20', 2) AS add_2_week_date")
+ testFoldConst("SELECT WEEKS_ADD('2023-12-25', 1) AS cross_year_add")
+
+ // 90. WEEKS_DIFF function constant folding tests
+ testFoldConst("SELECT WEEKS_DIFF('2020-12-25', '2020-10-25') AS diff_date")
+ testFoldConst("SELECT WEEKS_DIFF('2020-12-25 10:10:02', '2020-10-25
12:10:02') AS diff_datetime")
+ testFoldConst("SELECT WEEKS_DIFF('2023-10-07', '2023-10-01') AS
diff_6_days")
+ testFoldConst("SELECT WEEKS_DIFF('2023-10-09', '2023-10-01') AS
diff_8_days")
+ testFoldConst("SELECT WEEKS_DIFF('2024-01-01', '2023-12-25') AS
cross_year")
+
+ // 91. WEEKS_SUB function constant folding tests
+ testFoldConst("SELECT WEEKS_SUB('2023-10-01 08:30:45', 1) AS
sub_1_week_datetime")
+ testFoldConst("SELECT WEEKS_SUB('2023-09-24 14:20:10', -1) AS
add_1_week_datetime")
+ testFoldConst("SELECT WEEKS_SUB('2023-06-03', 2) AS sub_2_week_date")
+ testFoldConst("SELECT WEEKS_SUB('2024-01-01', 1) AS cross_year_sub")
+
+ // Test constant folding for Group 7 functions (Year functions)
+
+ // 92. YEAR_CEIL function constant folding tests
+ testFoldConst("SELECT YEAR_CEIL('2023-07-13 22:28:18') AS result")
+ testFoldConst("SELECT YEAR_CEIL('2023-07-13 22:28:18', 5) AS result")
+ testFoldConst("SELECT YEAR_CEIL(CAST('2023-07-13' AS DATE)) AS result")
+ testFoldConst("SELECT YEAR_CEIL('2023-07-13', 1, '2020-01-01') AS result")
+ testFoldConst("SELECT YEAR_CEIL('2023-01-01', 1, '2023-01-01') AS result")
+
+ // 93. YEAR_FLOOR function constant folding tests
+ testFoldConst("SELECT YEAR_FLOOR('2023-07-13 22:28:18') AS result")
+ testFoldConst("SELECT YEAR_FLOOR('2023-07-13 22:28:18', 5) AS result")
+ testFoldConst("SELECT YEAR_FLOOR(CAST('2023-07-13' AS DATE)) AS result")
+ testFoldConst("SELECT YEAR_FLOOR('2023-07-13', 1, '2020-01-01') AS result")
+ testFoldConst("SELECT YEAR_FLOOR('2025-07-13', 3, '2020-01-01') AS result")
+
+ // 94. YEAR function constant folding tests
+ testFoldConst("SELECT YEAR('1987-01-01') AS year_date")
+ testFoldConst("SELECT YEAR('2024-05-20 14:30:25') AS year_datetime")
+ testFoldConst("SELECT YEAR('2023-02-30') AS invalid_date")
+
+ // 95. YEAR_OF_WEEK function constant folding tests
+ testFoldConst("SELECT YEAR_OF_WEEK('2005-01-01') AS yow_result")
+ testFoldConst("SELECT YOW('2005-01-01') AS yow_alias_result")
+ testFoldConst("SELECT YEAR_OF_WEEK('2005-01-03') AS yow_result")
+ testFoldConst("SELECT YEAR_OF_WEEK('2023-01-01') AS yow_result")
+ testFoldConst("SELECT YEAR_OF_WEEK('2005-01-01 15:30:45') AS yow_datetime")
+ testFoldConst("SELECT YEAR_OF_WEEK('2024-12-30') AS yow_result")
+
+ // 96. YEARS_ADD function constant folding tests
+ testFoldConst("SELECT YEARS_ADD('2020-01-31 02:02:02', 1) AS
add_1_year_datetime")
+ testFoldConst("SELECT YEARS_ADD('2023-05-10 15:40:20', -1) AS
subtract_1_year_datetime")
+ testFoldConst("SELECT YEARS_ADD('2019-12-25', 3) AS add_3_year_date")
+ testFoldConst("SELECT YEARS_ADD('2020-02-29', 1) AS leap_day_adjust")
+
+ // 97. YEARS_DIFF function constant folding tests
+ testFoldConst("SELECT YEARS_DIFF('2020-12-25', '2019-12-25') AS
diff_full_year")
+ testFoldConst("SELECT YEARS_DIFF('2020-11-25', '2019-12-25') AS
diff_less_than_year")
+ testFoldConst("SELECT YEARS_DIFF('2022-03-15 08:30:00', '2021-03-15
09:10:00') AS diff_datetime")
+ testFoldConst("SELECT YEARS_DIFF('2024-05-20', '2020-05-20 12:00:00') AS
diff_mixed")
+ testFoldConst("SELECT YEARS_DIFF('2024-02-29', '2023-02-28') AS
leap_year_diff")
+
+ // 98. YEARS_SUB function constant folding tests
+ testFoldConst("SELECT YEARS_SUB('2020-02-02 02:02:02', 1) AS
sub_1_year_datetime")
+ testFoldConst("SELECT YEARS_SUB('2022-05-10 15:40:20', -1) AS
add_1_year_datetime")
+ testFoldConst("SELECT YEARS_SUB('2022-12-25', 3) AS sub_3_year_date")
+ testFoldConst("SELECT YEARS_SUB('2020-02-29', 1) AS leap_day_adjust_1")
+
+ // Additional NULL parameter tests for comprehensive coverage
+
+ // MINUTE functions NULL tests
+ testFoldConst("SELECT MINUTE_CEIL(NULL, 5)")
+ testFoldConst("SELECT MINUTE_CEIL('2023-07-13 22:28:18', NULL)")
+ testFoldConst("SELECT MINUTE_FLOOR(NULL, 5)")
+ testFoldConst("SELECT MINUTE_FLOOR('2023-07-13 22:28:18', NULL)")
+ testFoldConst("SELECT MINUTE(NULL)")
+ testFoldConst("SELECT MINUTES_ADD(NULL, 5)")
+ testFoldConst("SELECT MINUTES_ADD('2023-07-13 22:28:18', NULL)")
+ testFoldConst("SELECT MINUTES_DIFF(NULL, '2023-07-13')")
+ testFoldConst("SELECT MINUTES_DIFF('2023-07-13', NULL)")
+ testFoldConst("SELECT MINUTES_SUB(NULL, 5)")
+ testFoldConst("SELECT MINUTES_SUB('2023-07-13 22:28:18', NULL)")
+
+ // MONTH functions NULL tests
+ testFoldConst("SELECT MONTH_CEIL(NULL, 5)")
+ testFoldConst("SELECT MONTH_CEIL('2023-07-13 22:28:18', NULL)")
+ testFoldConst("SELECT MONTH_FLOOR(NULL, 5)")
+ testFoldConst("SELECT MONTH_FLOOR('2023-07-13 22:28:18', NULL)")
+ testFoldConst("SELECT MONTH(NULL)")
+ testFoldConst("SELECT MONTHNAME(NULL)")
+ testFoldConst("SELECT MONTHS_ADD(NULL, 1)")
+ testFoldConst("SELECT MONTHS_ADD('2020-01-31', NULL)")
+ testFoldConst("SELECT MONTHS_BETWEEN(NULL, '2020-10-25')")
+ testFoldConst("SELECT MONTHS_BETWEEN('2020-12-26', NULL)")
+ testFoldConst("SELECT MONTHS_DIFF(NULL, '2020-02-29')")
+ testFoldConst("SELECT MONTHS_DIFF('2020-03-28', NULL)")
+ testFoldConst("SELECT MONTHS_SUB(NULL, 1)")
+ testFoldConst("SELECT MONTHS_SUB('2020-01-31', NULL)")
+
+ // SECOND functions NULL tests
+ testFoldConst("SELECT SECOND_CEIL(NULL, 5)")
+ testFoldConst("SELECT SECOND_CEIL('2025-01-23 12:34:56', NULL)")
+ testFoldConst("SELECT SECOND_FLOOR(NULL, 5)")
+ testFoldConst("SELECT SECOND_FLOOR('2025-01-23 12:34:56', NULL)")
+ testFoldConst("SELECT SECOND(NULL)")
+ testFoldConst("SELECT SECONDS_ADD(NULL, 30)")
+ testFoldConst("SELECT SECONDS_ADD('2025-01-23 12:34:56', NULL)")
+ testFoldConst("SELECT SECONDS_DIFF(NULL, '2025-01-23 12:34:56')")
+ testFoldConst("SELECT SECONDS_DIFF('2025-01-23 12:35:56', NULL)")
+ testFoldConst("SELECT SECONDS_SUB(NULL, 30)")
+ testFoldConst("SELECT SECONDS_SUB('2025-01-23 12:34:56', NULL)")
+
+ // Other functions NULL tests
+ testFoldConst("SELECT TO_DATE(NULL)")
+ testFoldConst("SELECT TO_DAYS(NULL)")
+ testFoldConst("SELECT TO_ISO8601(NULL)")
+ testFoldConst("SELECT TO_MONDAY(NULL)")
+ testFoldConst("SELECT UNIX_TIMESTAMP(NULL)")
+ testFoldConst("SELECT WEEK_CEIL(NULL, 2)")
+ testFoldConst("SELECT WEEK_CEIL('2023-07-13 22:28:18', NULL)")
+ testFoldConst("SELECT WEEK_FLOOR(NULL, 2)")
+ testFoldConst("SELECT WEEK_FLOOR('2023-07-13 22:28:18', NULL)")
+ testFoldConst("SELECT WEEKDAY(NULL)")
+ testFoldConst("SELECT WEEKOFYEAR(NULL)")
+ testFoldConst("SELECT WEEKS_ADD(NULL, 1)")
+ testFoldConst("SELECT WEEKS_ADD('2023-10-01', NULL)")
+ testFoldConst("SELECT WEEKS_DIFF(NULL, '2020-10-25')")
+ testFoldConst("SELECT WEEKS_DIFF('2020-12-25', NULL)")
+ testFoldConst("SELECT WEEKS_SUB(NULL, 1)")
+ testFoldConst("SELECT WEEKS_SUB('2023-10-01', NULL)")
+
+ // YEAR functions NULL tests
+ testFoldConst("SELECT YEAR_CEIL(NULL, 5)")
+ testFoldConst("SELECT YEAR_CEIL('2023-07-13 22:28:18', NULL)")
+ testFoldConst("SELECT YEAR_FLOOR(NULL, 5)")
+ testFoldConst("SELECT YEAR_FLOOR('2023-07-13 22:28:18', NULL)")
+ testFoldConst("SELECT YEAR(NULL)")
+ testFoldConst("SELECT YEAR_OF_WEEK(NULL)")
+ testFoldConst("SELECT YEARS_ADD(NULL, 1)")
+ testFoldConst("SELECT YEARS_ADD('2020-01-31', NULL)")
+ testFoldConst("SELECT YEARS_DIFF(NULL, '2019-12-25')")
+ testFoldConst("SELECT YEARS_DIFF('2020-12-25', NULL)")
+ testFoldConst("SELECT YEARS_SUB(NULL, 1)")
+ testFoldConst("SELECT YEARS_SUB('2020-02-02', NULL)")
+
+ // Invalid parameter tests for error conditions
+ testFoldConst("SELECT DAY_CEIL('2023-07-13', -5)")
+ testFoldConst("SELECT HOUR_CEIL('2023-07-13 22:28:18', -5)")
+ testFoldConst("SELECT MINUTE_CEIL('2023-07-13 22:28:18', -5)")
+ testFoldConst("SELECT MONTH_CEIL('2023-07-13 22:28:18', -5)")
+ testFoldConst("SELECT SECOND_CEIL('2025-01-23 12:34:56', -5)")
+ testFoldConst("SELECT WEEK_CEIL('2023-07-13 22:28:18', -2)")
+ testFoldConst("SELECT YEAR_CEIL('2023-07-13 22:28:18', -5)")
+
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
