Skip to content

Commit 2bbcee0

Browse files
gengliangwanggengliangwang
committed
improve test coverage
1 parent f99e2e6 commit 2bbcee0

File tree

2 files changed

+236
-0
lines changed

2 files changed

+236
-0
lines changed

‎sql/core/src/test/resources/sql-tests/inputs/ansi/try_arithmetic.sql‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
--IMPORT try_arithmetic.sql

‎sql/core/src/test/resources/sql-tests/results/ansi/try_arithmetic.sql.out‎

Lines changed: 235 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,235 @@
1+
-- Automatically generated by SQLQueryTestSuite
2+
-- Number of queries: 29
3+
4+
5+
-- !query
6+
SELECT try_add(1, 1)
7+
-- !query schema
8+
struct<try_add(1, 1):int>
9+
-- !query output
10+
2
11+
12+
13+
-- !query
14+
SELECT try_add(2147483647, 1)
15+
-- !query schema
16+
struct<try_add(2147483647, 1):int>
17+
-- !query output
18+
NULL
19+
20+
21+
-- !query
22+
SELECT try_add(-2147483648, -1)
23+
-- !query schema
24+
struct<try_add(-2147483648, -1):int>
25+
-- !query output
26+
NULL
27+
28+
29+
-- !query
30+
SELECT try_add(9223372036854775807L, 1)
31+
-- !query schema
32+
struct<try_add(9223372036854775807, 1):bigint>
33+
-- !query output
34+
NULL
35+
36+
37+
-- !query
38+
SELECT try_add(-9223372036854775808L, -1)
39+
-- !query schema
40+
struct<try_add(-9223372036854775808, -1):bigint>
41+
-- !query output
42+
NULL
43+
44+
45+
-- !query
46+
SELECT try_add(date'2021-01-01', 1)
47+
-- !query schema
48+
struct<try_add(DATE '2021-01-01', 1):date>
49+
-- !query output
50+
2021-01-02
51+
52+
53+
-- !query
54+
SELECT try_add(1, date'2021-01-01')
55+
-- !query schema
56+
struct<try_add(1, DATE '2021-01-01'):date>
57+
-- !query output
58+
2021-01-02
59+
60+
61+
-- !query
62+
SELECT try_add(date'2021-01-01', interval 2 year)
63+
-- !query schema
64+
struct<try_add(DATE '2021-01-01', INTERVAL '2' YEAR):date>
65+
-- !query output
66+
2023-01-01
67+
68+
69+
-- !query
70+
SELECT try_add(date'2021-01-01', interval 2 second)
71+
-- !query schema
72+
struct<try_add(DATE '2021-01-01', INTERVAL '02' SECOND):timestamp>
73+
-- !query output
74+
2021-01-01 00:00:02
75+
76+
77+
-- !query
78+
SELECT try_add(interval 2 year, date'2021-01-01')
79+
-- !query schema
80+
struct<try_add(INTERVAL '2' YEAR, DATE '2021-01-01'):date>
81+
-- !query output
82+
2023-01-01
83+
84+
85+
-- !query
86+
SELECT try_add(interval 2 second, date'2021-01-01')
87+
-- !query schema
88+
struct<try_add(INTERVAL '02' SECOND, DATE '2021-01-01'):timestamp>
89+
-- !query output
90+
2021-01-01 00:00:02
91+
92+
93+
-- !query
94+
SELECT try_add(timestamp_ltz'2021-01-01 00:00:00', interval 2 year)
95+
-- !query schema
96+
struct<try_add(TIMESTAMP '2021-01-01 00:00:00', INTERVAL '2' YEAR):timestamp>
97+
-- !query output
98+
2023-01-01 00:00:00
99+
100+
101+
-- !query
102+
SELECT try_add(timestamp_ntz'2021-01-01 00:00:00', interval 2 second)
103+
-- !query schema
104+
struct<try_add(TIMESTAMP_NTZ '2021-01-01 00:00:00', INTERVAL '02' SECOND):timestamp_ntz>
105+
-- !query output
106+
2021-01-01 00:00:02
107+
108+
109+
-- !query
110+
SELECT try_add(interval 2 year, timestamp_ltz'2021-01-01 00:00:00')
111+
-- !query schema
112+
struct<try_add(INTERVAL '2' YEAR, TIMESTAMP '2021-01-01 00:00:00'):timestamp>
113+
-- !query output
114+
2023-01-01 00:00:00
115+
116+
117+
-- !query
118+
SELECT try_add(interval 2 second, timestamp_ntz'2021-01-01 00:00:00')
119+
-- !query schema
120+
struct<try_add(INTERVAL '02' SECOND, TIMESTAMP_NTZ '2021-01-01 00:00:00'):timestamp_ntz>
121+
-- !query output
122+
2021-01-01 00:00:02
123+
124+
125+
-- !query
126+
SELECT try_add(interval 2 year, interval 2 year)
127+
-- !query schema
128+
struct<try_add(INTERVAL '2' YEAR, INTERVAL '2' YEAR):interval year>
129+
-- !query output
130+
4-0
131+
132+
133+
-- !query
134+
SELECT try_add(interval 2 second, interval 2 second)
135+
-- !query schema
136+
struct<try_add(INTERVAL '02' SECOND, INTERVAL '02' SECOND):interval second>
137+
-- !query output
138+
0 00:00:04.000000000
139+
140+
141+
-- !query
142+
SELECT try_add(interval 2 year, interval 2 second)
143+
-- !query schema
144+
struct<>
145+
-- !query output
146+
org.apache.spark.sql.AnalysisException
147+
cannot resolve 'INTERVAL '2' YEAR + INTERVAL '02' SECOND' due to data type mismatch: argument 1 requires (timestamp or timestamp without time zone) type, however, 'INTERVAL '2' YEAR' is of interval year type.; line 1 pos 7
148+
149+
150+
-- !query
151+
SELECT try_add(interval 2147483647 month, interval 2 month)
152+
-- !query schema
153+
struct<try_add(INTERVAL '2147483647' MONTH, INTERVAL '2' MONTH):interval month>
154+
-- !query output
155+
NULL
156+
157+
158+
-- !query
159+
SELECT try_add(interval 106751991 day, interval 3 day)
160+
-- !query schema
161+
struct<try_add(INTERVAL '106751991' DAY, INTERVAL '3' DAY):interval day>
162+
-- !query output
163+
NULL
164+
165+
166+
-- !query
167+
SELECT try_divide(1, 0.5)
168+
-- !query schema
169+
struct<try_divide(1, 0.5):decimal(8,6)>
170+
-- !query output
171+
2.000000
172+
173+
174+
-- !query
175+
SELECT try_divide(1, 0)
176+
-- !query schema
177+
struct<try_divide(1, 0):double>
178+
-- !query output
179+
NULL
180+
181+
182+
-- !query
183+
SELECT try_divide(0, 0)
184+
-- !query schema
185+
struct<try_divide(0, 0):double>
186+
-- !query output
187+
NULL
188+
189+
190+
-- !query
191+
SELECT try_divide(interval 2 year, 2)
192+
-- !query schema
193+
struct<try_divide(INTERVAL '2' YEAR, 2):interval year to month>
194+
-- !query output
195+
1-0
196+
197+
198+
-- !query
199+
SELECT try_divide(interval 2 second, 2)
200+
-- !query schema
201+
struct<try_divide(INTERVAL '02' SECOND, 2):interval day to second>
202+
-- !query output
203+
0 00:00:01.000000000
204+
205+
206+
-- !query
207+
SELECT try_divide(interval 2 year, 0)
208+
-- !query schema
209+
struct<try_divide(INTERVAL '2' YEAR, 0):interval year to month>
210+
-- !query output
211+
NULL
212+
213+
214+
-- !query
215+
SELECT try_divide(interval 2 second, 0)
216+
-- !query schema
217+
struct<try_divide(INTERVAL '02' SECOND, 0):interval day to second>
218+
-- !query output
219+
NULL
220+
221+
222+
-- !query
223+
SELECT try_divide(interval 2147483647 month, 0.5)
224+
-- !query schema
225+
struct<try_divide(INTERVAL '2147483647' MONTH, 0.5):interval year to month>
226+
-- !query output
227+
NULL
228+
229+
230+
-- !query
231+
SELECT try_divide(interval 106751991 day, 0.5)
232+
-- !query schema
233+
struct<try_divide(INTERVAL '106751991' DAY, 0.5):interval day to second>
234+
-- !query output
235+
NULL

0 commit comments

Comments
 (0)