Lines Matching refs:execsql

29     execsql {SELECT x'616263'}
32     execsql {SELECT typeof(x'616263')}
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))}
60   execsql {SELECT null}
63   execsql {SELECT typeof(NULL)}
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))}
90   execsql {SELECT 123}
93   execsql {SELECT typeof(123)}
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))}
120   execsql {SELECT 123.456}
123   execsql {SELECT typeof(123.456)}
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))}
150   execsql {SELECT '123abc'}
153   execsql {SELECT typeof('123abc')}
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)}
295       execsql {
303   execsql {SELECT CAST(NULL AS numeric)}
466   execsql { PRAGMA encoding='utf16' }