1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
|
# name: test/sql/cast/cast_error_location.test
# description: Test reporting error location of casts
# group: [cast]
statement ok
PRAGMA enable_verification
# unimplemented cast
statement error
SELECT 1::STRUCT(i INTEGER)
----
^
# out of range integer cast
statement error
SELECT 1000::utinyint
----
^
# string cast
statement error
SELECT 'hello'::int
----
^
# numeric -> decimal cast
statement error
SELECT 1000::decimal(2,1)
----
^
# decimal -> decimal cast
statement error
SELECT 1000.0::decimal(5,1)::decimal(2,1)
----
^
# list cast
statement error
SELECT [1000]::utinyint[]
----
^
# struct cast
statement error
SELECT {'x': 1000}::row(x tinyint)
----
^
# double -> float
statement error
select 1e308::float
----
^
# double -> hugeint
statement error
select 1e308::hugeint
----
^
# hugeint -> int
statement error
select 1000000000000000000000000000000::hugeint::int
----
^
# automatically added cast
statement error
select nth_value(42, 'hello') over ()
----
^
# dates
statement error
select '1900'::date
----
^
statement error
select 42::utinyint + 'hello'
----
^
# bit
statement error
SELECT bitstring('1', 9)::BOOL;
----
^
# array
statement error
SELECT [1,2,3]::INT[2]
----
^
# blob
statement error
SELECT '\x'::BYTEA
----
^
# now with a table
statement ok
CREATE TABLE cast_table(i INTEGER, s VARCHAR, d DECIMAL(5,1), l INT[], int_struct ROW(i INTEGER), dbl DOUBLE, hge HUGEINT, invalid_blob_str VARCHAR);
statement ok
INSERT INTO cast_table VALUES (1000, 'hello', 1000.0, [1000], {'i': 1000}, 1e308, 1000000000000000000000000000000, '\x')
# out of range integer cast
statement error
SELECT i::utinyint from cast_table
----
^
# string cast
statement error
SELECT s::int FROM cast_table
----
^
# numeric -> decimal cast
statement error
SELECT i::decimal(2,1) FROM cast_table
----
^
# decimal -> decimal cast
statement error
SELECT d::decimal(2,1) FROM cast_table
----
^
# list cast
statement error
SELECT l::utinyint[] FROM cast_table
----
^
statement error
SELECT int_struct::ROW(x TINYINT) FROM cast_table
----
<REGEX>:Binder Error.*STRUCT to STRUCT cast must have at least one matching member.*
# DOUBLE to FLOAT cast.
statement error
select dbl::float FROM cast_table
----
^
# double -> hugeint
statement error
select dbl::hugeint FROM cast_table
----
^
# hugeint -> int
statement error
select hge::hugeint::int FROM cast_table
----
^
# array
statement error
SELECT l::INT[3] FROM cast_table
----
^
# blob
statement error
SELECT invalid_blob_str::BYTEA FROM cast_table
----
^
# inserts into a table
statement ok
CREATE TABLE int_tbl AS SELECT 42 my_integer
statement ok
CREATE TABLE str_tbl AS SELECT 'hello' my_str
statement ok
CREATE TABLE ts_tbl(ts TIMESTAMP)
statement error
INSERT INTO ts_tbl SELECT my_integer FROM int_tbl
----
^
statement error
INSERT INTO ts_tbl SELECT my_integer * 2 FROM int_tbl
----
^
statement error
INSERT INTO ts_tbl FROM int_tbl
----
my_integer
statement error
INSERT INTO ts_tbl FROM str_tbl
----
my_str
|
