Skip to content

Commit 1085144

Browse files
RoanHeNaNpull[bot]
authored andcommitted
[impro](regression test) Add case for time cast apache#24895
1 parent 9999002 commit 1085144

2 files changed

Lines changed: 177 additions & 9 deletions

File tree

Lines changed: 81 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,13 +1,90 @@
11
-- This file is automatically generated. You should know what you did if you want to edit this
2-
-- !select1 --
2+
-- !select --
33
16:32:18
44

5-
-- !select2 --
5+
-- !select --
66
16:32:18
77

8-
-- !select3 --
8+
-- !select --
9+
12:34:56
10+
11+
-- !select --
12+
00:34:56
13+
14+
-- !select --
15+
00:00:56
16+
17+
-- !select --
18+
12:34:56
19+
20+
-- !select --
21+
34:56:00
22+
23+
-- !select --
24+
\N
25+
26+
-- !select --
27+
12:34:56
28+
29+
-- !select --
30+
00:34:56
31+
32+
-- !select --
33+
00:00:56
34+
35+
-- !select --
36+
\N
37+
38+
-- !select --
39+
\N
40+
41+
-- !select --
42+
\N
43+
44+
-- !select --
45+
\N
46+
47+
-- !select --
948
16:32:18
1049

11-
-- !select4 --
50+
-- !select --
1251
16:32:18
1352

53+
-- !select --
54+
12:34:56
55+
56+
-- !select --
57+
00:34:56
58+
59+
-- !select --
60+
00:00:56
61+
62+
-- !select --
63+
12:34:56
64+
65+
-- !select --
66+
34:56:00
67+
68+
-- !select --
69+
\N
70+
71+
-- !select --
72+
12:34:56
73+
74+
-- !select --
75+
00:34:56
76+
77+
-- !select --
78+
00:00:56
79+
80+
-- !select --
81+
\N
82+
83+
-- !select --
84+
\N
85+
86+
-- !select --
87+
\N
88+
89+
-- !select --
90+
\N

‎regression-test/suites/correctness/test_time_function.groovy‎

Lines changed: 96 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -19,24 +19,115 @@ suite("test_time_function") {
1919
sql """
2020
set enable_nereids_planner=true,enable_fallback_to_original_planner=false
2121
"""
22-
qt_select1 """
22+
qt_select """
2323
select sec_to_time(time_to_sec(cast('16:32:18' as time)));
2424
"""
25-
qt_select2 """
25+
qt_select """
2626
select sec_to_time(59538);
2727
"""
28+
// "HHMMSS"
29+
qt_select """
30+
select cast("123456" as TIME);
31+
"""
32+
qt_select """
33+
select cast("3456" as TIME);
34+
"""
35+
qt_select """
36+
select cast("56" as TIME);
37+
"""
38+
39+
// "HH:MM:SS"
40+
qt_select """
41+
select cast("12:34:56" as TIME);
42+
"""
43+
qt_select """
44+
select cast("34:56" as TIME);
45+
"""
46+
qt_select """
47+
select cast(":56" as TIME);
48+
"""
49+
50+
// HHMMSS
51+
qt_select """
52+
select cast(123456 as TIME);
53+
"""
54+
qt_select """
55+
select cast(3456 as TIME);
56+
"""
57+
qt_select """
58+
select cast(56 as TIME);
59+
"""
60+
61+
// Invalid value in seconds part.
62+
qt_select """
63+
select cast(":61" as TIME);
64+
"""
65+
qt_select """
66+
select cast("61" as TIME);
67+
"""
68+
qt_select """
69+
select cast(61 as TIME);
70+
"""
71+
72+
qt_select """
73+
select sec_to_time(time_to_sec(cast("61" as time)));
74+
"""
2875

2976
sql """
3077
set enable_nereids_planner=false
3178
"""
3279

33-
qt_select3 """
80+
qt_select """
3481
select sec_to_time(time_to_sec(cast('16:32:18' as time)));
3582
"""
36-
qt_select4 """
83+
qt_select """
3784
select sec_to_time(59538);
3885
"""
86+
// "HHMMSS"
87+
qt_select """
88+
select cast("123456" as TIME);
89+
"""
90+
qt_select """
91+
select cast("3456" as TIME);
92+
"""
93+
qt_select """
94+
select cast("56" as TIME);
95+
"""
96+
97+
// "HH:MM:SS"
98+
qt_select """
99+
select cast("12:34:56" as TIME);
100+
"""
101+
qt_select """
102+
select cast("34:56" as TIME);
103+
"""
104+
qt_select """
105+
select cast(":56" as TIME);
106+
"""
107+
108+
// HHMMSS
109+
qt_select """
110+
select cast(123456 as TIME);
111+
"""
112+
qt_select """
113+
select cast(3456 as TIME);
114+
"""
115+
qt_select """
116+
select cast(56 as TIME);
117+
"""
39118

119+
// Invalid value in seconds part.
120+
qt_select """
121+
select cast(":61" as TIME);
122+
"""
123+
qt_select """
124+
select cast("61" as TIME);
125+
"""
126+
qt_select """
127+
select cast(61 as TIME);
128+
"""
40129

41-
130+
qt_select """
131+
select sec_to_time(time_to_sec(cast("61" as time)));
132+
"""
42133
}

0 commit comments

Comments
 (0)