Lines Matching refs:CAST
12 # focus of this file is testing the CAST operator.
19 # Only run these tests if the build includes the CAST operator
25 # Tests for the CAST( AS blob), CAST( AS text) and CAST( AS numeric) built-ins
35 execsql {SELECT CAST(x'616263' AS text)}
38 execsql {SELECT typeof(CAST(x'616263' AS text))}
41 execsql {SELECT CAST(x'616263' AS numeric)}
44 execsql {SELECT typeof(CAST(x'616263' AS numeric))}
47 execsql {SELECT CAST(x'616263' AS blob)}
50 execsql {SELECT typeof(CAST(x'616263' AS blob))}
53 execsql {SELECT CAST(x'616263' AS integer)}
56 execsql {SELECT typeof(CAST(x'616263' AS integer))}
66 execsql {SELECT CAST(NULL AS text)}
69 execsql {SELECT typeof(CAST(NULL AS text))}
72 execsql {SELECT CAST(NULL AS numeric)}
75 execsql {SELECT typeof(CAST(NULL AS numeric))}
78 execsql {SELECT CAST(NULL AS blob)}
81 execsql {SELECT typeof(CAST(NULL AS blob))}
84 execsql {SELECT CAST(NULL AS integer)}
87 execsql {SELECT typeof(CAST(NULL AS integer))}
96 execsql {SELECT CAST(123 AS text)}
99 execsql {SELECT typeof(CAST(123 AS text))}
102 execsql {SELECT CAST(123 AS numeric)}
105 execsql {SELECT typeof(CAST(123 AS numeric))}
108 execsql {SELECT CAST(123 AS blob)}
111 execsql {SELECT typeof(CAST(123 AS blob))}
114 execsql {SELECT CAST(123 AS integer)}
117 execsql {SELECT typeof(CAST(123 AS integer))}
126 execsql {SELECT CAST(123.456 AS text)}
129 execsql {SELECT typeof(CAST(123.456 AS text))}
132 execsql {SELECT CAST(123.456 AS numeric)}
135 execsql {SELECT typeof(CAST(123.456 AS numeric))}
138 execsql {SELECT CAST(123.456 AS blob)}
141 execsql {SELECT typeof(CAST(123.456 AS blob))}
144 execsql {SELECT CAST(123.456 AS integer)}
147 execsql {SELECT typeof(CAST(123.456 AS integer))}
156 execsql {SELECT CAST('123abc' AS text)}
159 execsql {SELECT typeof(CAST('123abc' AS text))}
162 execsql {SELECT CAST('123abc' AS numeric)}
165 execsql {SELECT typeof(CAST('123abc' AS numeric))}
168 execsql {SELECT CAST('123abc' AS blob)}
171 execsql {SELECT typeof(CAST('123abc' AS blob))}
174 execsql {SELECT CAST('123abc' AS integer)}
177 execsql {SELECT typeof(CAST('123abc' AS integer))}
180 execsql {SELECT CAST('123.5abc' AS numeric)}
183 execsql {SELECT CAST('123.5abc' AS integer)}
187 execsql {SELECT CAST(null AS REAL)}
190 execsql {SELECT typeof(CAST(null AS REAL))}
193 execsql {SELECT CAST(1 AS REAL)}
196 execsql {SELECT typeof(CAST(1 AS REAL))}
199 execsql {SELECT CAST('1' AS REAL)}
202 execsql {SELECT typeof(CAST('1' AS REAL))}
205 execsql {SELECT CAST('abc' AS REAL)}
208 execsql {SELECT typeof(CAST('abc' AS REAL))}
211 execsql {SELECT CAST(x'31' AS REAL)}
214 execsql {SELECT typeof(CAST(x'31' AS REAL))}
221 execsql {SELECT CAST(' 123' AS integer)}
224 execsql {SELECT CAST(' -123.456' AS real)}
232 execsql {SELECT CAST(9223372036854774800 AS integer)}
235 execsql {SELECT CAST(9223372036854774800 AS numeric)}
238 execsql {SELECT CAST(9223372036854774800 AS real)}
241 execsql {SELECT CAST(CAST(9223372036854774800 AS real) AS integer)}
244 execsql {SELECT CAST(-9223372036854774800 AS integer)}
247 execsql {SELECT CAST(-9223372036854774800 AS numeric)}
250 execsql {SELECT CAST(-9223372036854774800 AS real)}
253 execsql {SELECT CAST(CAST(-9223372036854774800 AS real) AS integer)}
256 execsql {SELECT CAST('9223372036854774800' AS integer)}
259 execsql {SELECT CAST('9223372036854774800' AS numeric)}
262 execsql {SELECT CAST('9223372036854774800' AS real)}
266 execsql {SELECT CAST(CAST('9223372036854774800' AS real) AS integer)}
270 execsql {SELECT CAST('-9223372036854774800' AS integer)}
273 execsql {SELECT CAST('-9223372036854774800' AS numeric)}
276 execsql {SELECT CAST('-9223372036854774800' AS real)}
280 execsql {SELECT CAST(CAST('-9223372036854774800' AS real) AS integer)}
285 execsql {SELECT CAST(x'39323233333732303336383534373734383030' AS integer)}
288 execsql {SELECT CAST(x'39323233333732303336383534373734383030' AS numeric)}
291 execsql {SELECT CAST(x'39323233333732303336383534373734383030' AS real)}
296 SELECT CAST(CAST(x'39323233333732303336383534373734383030' AS real)
303 execsql {SELECT CAST(NULL AS numeric)}
311 set ::STMT [sqlite3_prepare $DB {SELECT CAST(? AS real)} -1 TAIL]
327 SELECT a, CAST(a AS integer) FROM t1;
332 SELECT CAST(a AS integer), a FROM t1;
337 SELECT a, CAST(a AS integer), a FROM t1;
342 SELECT CAST(a AS integer), a, CAST(a AS real), a FROM t1;
352 SELECT CAST('9223372036854775808' AS integer);
353 SELECT CAST(' +000009223372036854775808' AS integer);
354 SELECT CAST('12345678901234567890123' AS INTEGER);
361 SELECT CAST('-9223372036854775808' AS integer);
362 SELECT CAST('-9223372036854775809' AS integer);
363 SELECT CAST('-12345678901234567890123' AS INTEGER);
369 # EVIDENCE-OF: R-24225-46995 For example, "(CAST '123e+5' AS INTEGER)"
372 SELECT CAST('123e+5' AS INTEGER);
373 SELECT CAST('123e+5' AS NUMERIC);
374 SELECT CAST('123e+5' AS REAL);
378 # The following does not have anything to do with the CAST operator,
395 SELECT CAST('-' AS NUMERIC);
398 SELECT CAST('-0' AS NUMERIC);
401 SELECT CAST('+' AS NUMERIC);
404 SELECT CAST('/' AS NUMERIC);
429 SELECT CAST(c0 AS NUMERIC) FROM t0;
442 SELECT CAST('.' AS numeric);
445 SELECT -CAST('.' AS numeric);
452 SELECT CAST('-0.0' AS numeric);
455 SELECT CAST('0.0' AS numeric);
458 SELECT CAST('+0.0' AS numeric);
461 SELECT CAST('-1.0' AS numeric);
472 SELECT CAST(X'310032003300' AS TEXT)
473 ==CAST(substr(X'310032003300', 1) AS TEXT)
482 SELECT CAST(0.0 AS NUMERIC), COUNT(*) OVER () FROM t0;