Lines Matching refs:execsql
22 execsql {CREATE TABLE tbl1(t1 text)}
24 execsql "INSERT INTO tbl1 VALUES('$word')"
26 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
29 execsql {
43 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
46 set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
50 set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
54 execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
58 execsql {SELECT coalesce(length(a),-1) FROM t2}
64 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
67 execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
70 execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
73 execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
76 execsql {SELECT substr(t1,-1,2) FROM tbl1 ORDER BY t1}
79 execsql {SELECT substr(t1,-2,1) FROM tbl1 ORDER BY t1}
82 execsql {SELECT substr(t1,-2,2) FROM tbl1 ORDER BY t1}
85 execsql {SELECT substr(t1,-4,2) FROM tbl1 ORDER BY t1}
88 execsql {SELECT t1 FROM tbl1 ORDER BY substr(t1,2,20)}
91 execsql {SELECT substr(a,1,1) FROM t2}
94 execsql {SELECT substr(a,2,2) FROM t2}
104 execsql {DELETE FROM tbl1}
106 execsql "INSERT INTO tbl1 VALUES('$word')"
108 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
111 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
114 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
117 execsql {SELECT substr(t1,1,3) FROM tbl1 ORDER BY t1}
120 execsql {SELECT substr(t1,2,2) FROM tbl1 ORDER BY t1}
123 execsql {SELECT substr(t1,2,3) FROM tbl1 ORDER BY t1}
126 execsql {SELECT substr(t1,3,2) FROM tbl1 ORDER BY t1}
129 execsql {SELECT substr(t1,4,2) FROM tbl1 ORDER BY t1}
132 execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
135 execsql {SELECT substr(t1,-3,2) FROM tbl1 ORDER BY t1}
138 execsql {SELECT substr(t1,-4,3) FROM tbl1 ORDER BY t1}
141 execsql {DELETE FROM tbl1}
143 execsql "INSERT INTO tbl1 VALUES('$word')"
145 execsql {SELECT t1 FROM tbl1}
154 execsql {
165 execsql {
196 execsql {SELECT abs(a) FROM t2}
199 execsql {SELECT abs(t1) FROM tbl1}
225 execsql {SELECT coalesce(round(a,2),'nil') FROM t2}
228 execsql {SELECT round(t1,2) FROM tbl1}
231 execsql {SELECT typeof(round(5.1,1));}
234 execsql {SELECT typeof(round(5.1));}
247 execsql {SELECT round($x1);}
254 execsql {SELECT round($x1,1);}
258 execsql {SELECT round(40223.4999999999);}
261 execsql {SELECT round(40224.4999999999);}
264 execsql {SELECT round(40225.4999999999);}
268 execsql {SELECT round(40223.4999999999,$i);}
271 execsql {SELECT round(40224.4999999999,$i);}
274 execsql {SELECT round(40225.4999999999,$i);}
279 execsql {SELECT round(40223.4999999999,$i);}
282 execsql {SELECT round(40224.4999999999,$i);}
285 execsql {SELECT round(40225.4999999999,$i);}
289 execsql {SELECT round(1234567890.5);}
292 execsql {SELECT round(12345678901.5);}
295 execsql {SELECT round(123456789012.5);}
298 execsql {SELECT round(1234567890123.5);}
301 execsql {SELECT round(12345678901234.5);}
304 execsql {SELECT round(1234567890123.35,1);}
307 execsql {SELECT round(1234567890123.445,2);}
310 execsql {SELECT round(99999999999994.5);}
313 execsql {SELECT round(9999999999999.55,1);}
316 execsql {SELECT round(9999999999999.556,2);}
326 execsql {SELECT upper(t1) FROM tbl1}
329 execsql {SELECT lower(upper(t1)) FROM tbl1}
332 execsql {SELECT upper(a), lower(a) FROM t2}
346 execsql {SELECT coalesce(a,'xyz') FROM t2}
349 execsql {SELECT coalesce(upper(a),'nil') FROM t2}
352 execsql {SELECT coalesce(nullif(1,1),'nil')}
355 execsql {SELECT coalesce(nullif(1,2),'nil')}
358 execsql {SELECT coalesce(nullif(1,NULL),'nil')}
365 execsql {SELECT last_insert_rowid()}
373 execsql {EXPLAIN SELECT sum(a) FROM t2;}
375 execsql {
383 execsql {EXPLAIN SELECT sum(a) FROM t2;}
385 execsql {
391 execsql {
398 execsql {
405 execsql {
412 execsql {
418 execsql {
424 execsql {
430 execsql {
437 execsql {
445 execsql {
456 execsql {
461 execsql {
466 execsql {
471 execsql {
476 execsql {
488 execsql {SELECT hex(x'00112233445566778899aAbBcCdDeEfF')}
494 execsql {SELECT hex(replace('abcdefg','ef','12'))}
497 execsql {SELECT hex(replace('abcdefg','','12'))}
500 execsql {SELECT hex(replace('aabcdefg','a','aaa'))}
504 execsql {SELECT hex(replace('abcdefg','ef','12'))}
507 execsql {SELECT hex(replace('abcdefg','','12'))}
510 execsql {SELECT hex(replace('aabcdefg','a','aaa'))}
538 execsql {
546 execsql {
556 execsql {
564 execsql {
586 execsql {
602 execsql {
609 execsql {
616 execsql {
621 execsql {
626 execsql {
631 execsql {
639 execsql {
644 execsql {
654 execsql {
660 execsql {
667 execsql {
672 execsql {
677 execsql {
682 execsql {
753 execsql {
760 execsql {
778 execsql {
788 execsql {
800 execsql {
806 execsql {
812 execsql {
818 execsql {
829 execsql {
837 execsql {
849 execsql {
862 execsql {
869 execsql {
947 execsql {
991 execsql {SELECT soundex($name)}
1009 execsql {
1014 execsql {
1019 execsql {
1024 execsql {
1029 execsql {
1034 execsql {
1045 execsql {
1063 execsql {SELECT trim(' hi ');}
1066 execsql {SELECT ltrim(' hi ');}
1069 execsql {SELECT rtrim(' hi ');}
1072 execsql {SELECT trim(' hi ','xyz');}
1075 execsql {SELECT ltrim(' hi ','xyz');}
1078 execsql {SELECT rtrim(' hi ','xyz');}
1081 execsql {SELECT trim('xyxzy hi zzzy','xyz');}
1084 execsql {SELECT ltrim('xyxzy hi zzzy','xyz');}
1087 execsql {SELECT rtrim('xyxzy hi zzzy','xyz');}
1090 execsql {SELECT trim(' hi ','');}
1094 execsql {SELECT hex(trim(x'c280e1bfbff48fbfbf6869',x'6162e1bfbfc280'))}
1097 execsql {SELECT hex(trim(x'6869c280e1bfbff48fbfbf61',
1101 execsql {SELECT hex(trim(x'ceb1ceb2ceb3',x'ceb1'));}
1105 execsql {SELECT typeof(trim(NULL));}
1108 execsql {SELECT typeof(trim(NULL,'xyz'));}
1111 execsql {SELECT typeof(trim('hello',NULL));}
1126 execsql {
1135 execsql {
1140 execsql {
1145 execsql {
1150 execsql {
1155 execsql {
1160 execsql {
1189 execsql {
1194 execsql {
1203 execsql {
1208 execsql {
1213 execsql {
1220 execsql {
1225 execsql {
1236 execsql {SELECT test_isolation(t1,t1) FROM tbl1}