Lines Matching refs:do_execsql_test
26 uplevel do_execsql_test $tn [list "SELECT typeof($expr), $expr"] [
32 uplevel do_execsql_test $tn [list "SELECT quote($expr)"] [list $value]
136 do_execsql_test $testname $sql1 [list [
154 do_execsql_test e_expr-1.2.1 {
157 do_execsql_test e_expr-1.2.2 {
163 do_execsql_test e_expr-1.2.3 {
166 do_execsql_test e_expr-1.2.4 {
172 do_execsql_test e_expr-1.2.5 {
175 do_execsql_test e_expr-1.6 {
186 do_execsql_test e_expr-2.1 { SELECT - 10 } {-10}
187 do_execsql_test e_expr-2.2 { SELECT + 10 } {10}
188 do_execsql_test e_expr-2.3 { SELECT ~ 10 } {-11}
189 do_execsql_test e_expr-2.4 { SELECT NOT 10 } {0}
209 do_execsql_test e_expr-3.$tn $sql [list $literal $type]
227 do_execsql_test e_expr-4.$tn "
251 do_execsql_test e_expr-5.$tn "SELECT $a || $b" [list "${as}${bs}"]
261 do_execsql_test e_expr-6.1 {SELECT 72%5} {2}
262 do_execsql_test e_expr-6.2 {SELECT 72%-5} {2}
263 do_execsql_test e_expr-6.3 {SELECT -72%-5} {-2}
264 do_execsql_test e_expr-6.4 {SELECT -72%5} {-2}
265 do_execsql_test e_expr-6.5 {SELECT 72.35%5} {2.0}
312 do_execsql_test e_expr-8.1.1 { SELECT NULL IS NULL } {1}
313 do_execsql_test e_expr-8.1.2 { SELECT 'ab' IS NULL } {0}
314 do_execsql_test e_expr-8.1.3 { SELECT NULL IS 'ab' } {0}
315 do_execsql_test e_expr-8.1.4 { SELECT 'ab' IS 'ab' } {1}
316 do_execsql_test e_expr-8.1.5 { SELECT NULL == NULL } {{}}
317 do_execsql_test e_expr-8.1.6 { SELECT 'ab' == NULL } {{}}
318 do_execsql_test e_expr-8.1.7 { SELECT NULL == 'ab' } {{}}
319 do_execsql_test e_expr-8.1.8 { SELECT 'ab' == 'ab' } {1}
320 do_execsql_test e_expr-8.1.9 { SELECT NULL IS NOT NULL } {0}
321 do_execsql_test e_expr-8.1.10 { SELECT 'ab' IS NOT NULL } {1}
322 do_execsql_test e_expr-8.1.11 { SELECT NULL IS NOT 'ab' } {1}
323 do_execsql_test e_expr-8.1.12 { SELECT 'ab' IS NOT 'ab' } {0}
324 do_execsql_test e_expr-8.1.13 { SELECT NULL != NULL } {{}}
325 do_execsql_test e_expr-8.1.14 { SELECT 'ab' != NULL } {{}}
326 do_execsql_test e_expr-8.1.15 { SELECT NULL != 'ab' } {{}}
327 do_execsql_test e_expr-8.1.16 { SELECT 'ab' != 'ab' } {0}
339 do_execsql_test $test.1 "SELECT $lhs IS $rhs, $lhs IS NOT $rhs" $eq
340 do_execsql_test $test.2 "
372 do_execsql_test e_expr-9.1 { SELECT 'abcd' < 'bbbb' COLLATE reverse } 0
373 do_execsql_test e_expr-9.2 { SELECT ('abcd' < 'bbbb') COLLATE reverse } 1
374 do_execsql_test e_expr-9.3 { SELECT 'abcd' <= 'bbbb' COLLATE reverse } 0
375 do_execsql_test e_expr-9.4 { SELECT ('abcd' <= 'bbbb') COLLATE reverse } 1
377 do_execsql_test e_expr-9.5 { SELECT 'abcd' > 'bbbb' COLLATE reverse } 1
378 do_execsql_test e_expr-9.6 { SELECT ('abcd' > 'bbbb') COLLATE reverse } 0
379 do_execsql_test e_expr-9.7 { SELECT 'abcd' >= 'bbbb' COLLATE reverse } 1
380 do_execsql_test e_expr-9.8 { SELECT ('abcd' >= 'bbbb') COLLATE reverse } 0
382 do_execsql_test e_expr-9.10 { SELECT 'abcd' = 'ABCD' COLLATE nocase } 1
383 do_execsql_test e_expr-9.11 { SELECT ('abcd' = 'ABCD') COLLATE nocase } 0
384 do_execsql_test e_expr-9.12 { SELECT 'abcd' == 'ABCD' COLLATE nocase } 1
385 do_execsql_test e_expr-9.13 { SELECT ('abcd' == 'ABCD') COLLATE nocase } 0
386 do_execsql_test e_expr-9.14 { SELECT 'abcd' IS 'ABCD' COLLATE nocase } 1
387 do_execsql_test e_expr-9.15 { SELECT ('abcd' IS 'ABCD') COLLATE nocase } 0
389 do_execsql_test e_expr-9.16 { SELECT 'abcd' != 'ABCD' COLLATE nocase } 0
390 do_execsql_test e_expr-9.17 { SELECT ('abcd' != 'ABCD') COLLATE nocase } 1
391 do_execsql_test e_expr-9.18 { SELECT 'abcd' <> 'ABCD' COLLATE nocase } 0
392 do_execsql_test e_expr-9.19 { SELECT ('abcd' <> 'ABCD') COLLATE nocase } 1
393 do_execsql_test e_expr-9.20 { SELECT 'abcd' IS NOT 'ABCD' COLLATE nocase } 0
394 do_execsql_test e_expr-9.21 { SELECT ('abcd' IS NOT 'ABCD') COLLATE nocase } 1
396 do_execsql_test e_expr-9.22 {
399 do_execsql_test e_expr-9.23 {
407 do_execsql_test e_expr-9.24 {
413 do_execsql_test e_expr-9.25 { SELECT 'BBB' = a FROM t24 } {0 1 0}
414 do_execsql_test e_expr-9.25 { SELECT a = 'BBB' FROM t24 } {0 1 0}
415 do_execsql_test e_expr-9.25 { SELECT 'BBB' = a COLLATE binary FROM t24 } {0 0 0}
416 do_execsql_test e_expr-9.25 { SELECT a COLLATE binary = 'BBB' FROM t24 } {0 0 0}
424 do_execsql_test e_expr-10.1.1 { SELECT typeof(5) } {integer}
425 do_execsql_test e_expr-10.1.2 { SELECT typeof(5.1) } {real}
426 do_execsql_test e_expr-10.1.3 { SELECT typeof('5.1') } {text}
427 do_execsql_test e_expr-10.1.4 { SELECT typeof(X'ABCD') } {blob}
428 do_execsql_test e_expr-10.1.5 { SELECT typeof(NULL) } {null}
432 do_execsql_test e_expr-10.2.1 { SELECT typeof(3.4e-02) } {real}
433 do_execsql_test e_expr-10.2.2 { SELECT typeof(3e+5) } {real}
434 do_execsql_test e_expr-10.2.3 { SELECT 3.4e-02 } {0.034}
435 do_execsql_test e_expr-10.2.4 { SELECT 3e+4 } {30000.0}
443 do_execsql_test e_expr-10.3.1 { SELECT 'is not' } {{is not}}
444 do_execsql_test e_expr-10.3.2 { SELECT typeof('is not') } {text}
445 do_execsql_test e_expr-10.3.3 { SELECT 'isn''t' } {isn't}
446 do_execsql_test e_expr-10.3.4 { SELECT typeof('isn''t') } {text}
454 do_execsql_test e_expr-10.4.1 { SELECT typeof(X'0123456789ABCDEF') } blob
455 do_execsql_test e_expr-10.4.2 { SELECT typeof(x'0123456789ABCDEF') } blob
456 do_execsql_test e_expr-10.4.3 { SELECT typeof(X'0123456789abcdef') } blob
457 do_execsql_test e_expr-10.4.4 { SELECT typeof(x'0123456789abcdef') } blob
458 do_execsql_test e_expr-10.4.5 { SELECT typeof(X'53514C697465') } blob
463 do_execsql_test e_expr-10.5.1 { SELECT NULL } {{}}
464 do_execsql_test e_expr-10.5.2 { SELECT typeof(NULL) } {null}
635 do_execsql_test e_expr-12.1.1 { SELECT 0, +0, -0 } {0 0 0}
636 do_execsql_test e_expr-12.1.2 { SELECT 1, +1, -1 } {1 1 -1}
637 do_execsql_test e_expr-12.1.3 { SELECT 2, +2, -2 } {2 2 -2}
638 do_execsql_test e_expr-12.1.4 {
641 do_execsql_test e_expr-12.1.5 {
644 do_execsql_test e_expr-12.1.6 {
651 do_execsql_test e_expr-12.2.1 {SELECT 123} {123}
652 do_execsql_test e_expr-12.2.2 {SELECT 123.4e05} {12340000.0}
653 do_execsql_test e_expr-12.2.3 {SELECT 'abcde'} {abcde}
654 do_execsql_test e_expr-12.2.4 {SELECT X'414243'} {ABC}
655 do_execsql_test e_expr-12.2.5 {SELECT NULL} {{}}
656 do_execsql_test e_expr-12.2.6 {SELECT CURRENT_TIME} {00:00:01}
657 do_execsql_test e_expr-12.2.7 {SELECT CURRENT_DATE} {1970-01-01}
658 do_execsql_test e_expr-12.2.8 {SELECT CURRENT_TIMESTAMP} {{1970-01-01 00:00:01}}
826 do_execsql_test e_expr-12.4.$tn "
867 do_execsql_test e_expr-13.2.1 { SELECT 1 == 10 BETWEEN 0 AND 2 } 1
868 do_execsql_test e_expr-13.2.2 { SELECT (1 == 10) BETWEEN 0 AND 2 } 1
869 do_execsql_test e_expr-13.2.3 { SELECT 1 == (10 BETWEEN 0 AND 2) } 0
870 do_execsql_test e_expr-13.2.4 { SELECT 6 BETWEEN 4 AND 8 == 1 } 1
871 do_execsql_test e_expr-13.2.5 { SELECT (6 BETWEEN 4 AND 8) == 1 } 1
872 do_execsql_test e_expr-13.2.6 { SELECT 6 BETWEEN 4 AND (8 == 1) } 0
874 do_execsql_test e_expr-13.2.7 { SELECT 5 BETWEEN 0 AND 0 != 1 } 1
875 do_execsql_test e_expr-13.2.8 { SELECT (5 BETWEEN 0 AND 0) != 1 } 1
876 do_execsql_test e_expr-13.2.9 { SELECT 5 BETWEEN 0 AND (0 != 1) } 0
877 do_execsql_test e_expr-13.2.10 { SELECT 1 != 0 BETWEEN 0 AND 2 } 1
878 do_execsql_test e_expr-13.2.11 { SELECT (1 != 0) BETWEEN 0 AND 2 } 1
879 do_execsql_test e_expr-13.2.12 { SELECT 1 != (0 BETWEEN 0 AND 2) } 0
881 do_execsql_test e_expr-13.2.13 { SELECT 1 LIKE 10 BETWEEN 0 AND 2 } 1
882 do_execsql_test e_expr-13.2.14 { SELECT (1 LIKE 10) BETWEEN 0 AND 2 } 1
883 do_execsql_test e_expr-13.2.15 { SELECT 1 LIKE (10 BETWEEN 0 AND 2) } 0
884 do_execsql_test e_expr-13.2.16 { SELECT 6 BETWEEN 4 AND 8 LIKE 1 } 1
885 do_execsql_test e_expr-13.2.17 { SELECT (6 BETWEEN 4 AND 8) LIKE 1 } 1
886 do_execsql_test e_expr-13.2.18 { SELECT 6 BETWEEN 4 AND (8 LIKE 1) } 0
888 do_execsql_test e_expr-13.2.19 { SELECT 0 AND 0 BETWEEN 0 AND 1 } 0
889 do_execsql_test e_expr-13.2.20 { SELECT 0 AND (0 BETWEEN 0 AND 1) } 0
890 do_execsql_test e_expr-13.2.21 { SELECT (0 AND 0) BETWEEN 0 AND 1 } 1
891 do_execsql_test e_expr-13.2.22 { SELECT 0 BETWEEN -1 AND 1 AND 0 } 0
892 do_execsql_test e_expr-13.2.23 { SELECT (0 BETWEEN -1 AND 1) AND 0 } 0
893 do_execsql_test e_expr-13.2.24 { SELECT 0 BETWEEN -1 AND (1 AND 0) } 1
895 do_execsql_test e_expr-13.2.25 { SELECT 2 < 3 BETWEEN 0 AND 1 } 1
896 do_execsql_test e_expr-13.2.26 { SELECT (2 < 3) BETWEEN 0 AND 1 } 1
897 do_execsql_test e_expr-13.2.27 { SELECT 2 < (3 BETWEEN 0 AND 1) } 0
898 do_execsql_test e_expr-13.2.28 { SELECT 2 BETWEEN 1 AND 2 < 3 } 0
899 do_execsql_test e_expr-13.2.29 { SELECT 2 BETWEEN 1 AND (2 < 3) } 0
900 do_execsql_test e_expr-13.2.30 { SELECT (2 BETWEEN 1 AND 2) < 3 } 1
912 do_execsql_test e_expr-14.1.1 { SELECT 'abc%' LIKE 'abcde' } 0
913 do_execsql_test e_expr-14.1.2 { SELECT 'abcde' LIKE 'abc%' } 1
918 do_execsql_test e_expr-14.2.1 { SELECT 'abde' LIKE 'ab%de' } 1
919 do_execsql_test e_expr-14.2.2 { SELECT 'abXde' LIKE 'ab%de' } 1
920 do_execsql_test e_expr-14.2.3 { SELECT 'abABCde' LIKE 'ab%de' } 1
925 do_execsql_test e_expr-14.3.1 { SELECT 'abde' LIKE 'ab_de' } 0
926 do_execsql_test e_expr-14.3.2 { SELECT 'abXde' LIKE 'ab_de' } 1
927 do_execsql_test e_expr-14.3.3 { SELECT 'abABCde' LIKE 'ab_de' } 0
932 do_execsql_test e_expr-14.4.1 { SELECT 'abc' LIKE 'aBc' } 1
933 do_execsql_test e_expr-14.4.2 { SELECT 'aBc' LIKE 'aBc' } 1
934 do_execsql_test e_expr-14.4.3 { SELECT 'ac' LIKE 'aBc' } 0
950 do_execsql_test e_expr-14.5.1 { SELECT 'A' LIKE 'a' } 1
952 do_execsql_test e_expr-14.5.2 "SELECT '\u00c6' LIKE '\u00e6'" 0
976 do_execsql_test e_expr-14.7.1 { SELECT 'abc%' LIKE 'abcX%' ESCAPE 'X' } 1
977 do_execsql_test e_expr-14.7.2 { SELECT 'abc5' LIKE 'abcX%' ESCAPE 'X' } 0
978 do_execsql_test e_expr-14.7.3 { SELECT 'abc' LIKE 'abcX%' ESCAPE 'X' } 0
979 do_execsql_test e_expr-14.7.4 { SELECT 'abcX%' LIKE 'abcX%' ESCAPE 'X' } 0
980 do_execsql_test e_expr-14.7.5 { SELECT 'abc%%' LIKE 'abcX%' ESCAPE 'X' } 0
982 do_execsql_test e_expr-14.7.6 { SELECT 'abc_' LIKE 'abcX_' ESCAPE 'X' } 1
983 do_execsql_test e_expr-14.7.7 { SELECT 'abc5' LIKE 'abcX_' ESCAPE 'X' } 0
984 do_execsql_test e_expr-14.7.8 { SELECT 'abc' LIKE 'abcX_' ESCAPE 'X' } 0
985 do_execsql_test e_expr-14.7.9 { SELECT 'abcX_' LIKE 'abcX_' ESCAPE 'X' } 0
986 do_execsql_test e_expr-14.7.10 { SELECT 'abc__' LIKE 'abcX_' ESCAPE 'X' } 0
988 do_execsql_test e_expr-14.7.11 { SELECT 'abcX' LIKE 'abcXX' ESCAPE 'X' } 1
989 do_execsql_test e_expr-14.7.12 { SELECT 'abc5' LIKE 'abcXX' ESCAPE 'X' } 0
990 do_execsql_test e_expr-14.7.13 { SELECT 'abc' LIKE 'abcXX' ESCAPE 'X' } 0
991 do_execsql_test e_expr-14.7.14 { SELECT 'abcXX' LIKE 'abcXX' ESCAPE 'X' } 0
1003 do_execsql_test e_expr-15.1.1 { SELECT 'abc' LIKE 'def' } 1
1006 do_execsql_test e_expr-15.1.3 { SELECT 'abc' LIKE 'def' ESCAPE 'X' } 1
1014 do_execsql_test e_expr-16.1.1 { SELECT 'abcxyz' LIKE 'ABC%' } 1
1015 do_execsql_test e_expr-16.1.1b { SELECT 'abc%xyz' LIKE 'ABC\%x%' ESCAPE '\' } 1
1016 do_execsql_test e_expr-16.1.2 { PRAGMA case_sensitive_like = 1 } {}
1017 do_execsql_test e_expr-16.1.3 { SELECT 'abcxyz' LIKE 'ABC%' } 0
1018 do_execsql_test e_expr-16.1.3b { SELECT 'abc%xyz' LIKE 'ABC\%X%' ESCAPE '\' } 0
1019 do_execsql_test e_expr-16.1.4 { SELECT 'ABCxyz' LIKE 'ABC%' } 1
1020 do_execsql_test e_expr-16.1.4b { SELECT 'ABC%xyz' LIKE 'ABC\%x%' ESCAPE '\' } 1
1021 do_execsql_test e_expr-16.1.5 { PRAGMA case_sensitive_like = 0 } {}
1022 do_execsql_test e_expr-16.1.6 { SELECT 'abcxyz' LIKE 'ABC%' } 1
1023 do_execsql_test e_expr-16.1.6b { SELECT 'abc%xyz' LIKE 'ABC\%X%' ESCAPE '\' } 1
1024 do_execsql_test e_expr-16.1.7 { SELECT 'ABCxyz' LIKE 'ABC%' } 1
1025 do_execsql_test e_expr-16.1.7b { SELECT 'ABC%xyz' LIKE 'ABC\%X%' ESCAPE '\' } 1
1032 do_execsql_test e_expr-17.1.1 { SELECT 'abcxyz' GLOB 'abc%' } 0
1033 do_execsql_test e_expr-17.1.2 { SELECT 'abcxyz' GLOB 'abc*' } 1
1034 do_execsql_test e_expr-17.1.3 { SELECT 'abcxyz' GLOB 'abc___' } 0
1035 do_execsql_test e_expr-17.1.4 { SELECT 'abcxyz' GLOB 'abc???' } 1
1037 do_execsql_test e_expr-17.1.5 { SELECT 'abcxyz' GLOB 'abc*' } 1
1038 do_execsql_test e_expr-17.1.6 { SELECT 'ABCxyz' GLOB 'abc*' } 0
1039 do_execsql_test e_expr-17.1.7 { SELECT 'abcxyz' GLOB 'ABC*' } 0
1044 do_execsql_test e_expr-17.2.1 { SELECT 'abcxyz' NOT GLOB 'ABC*' } 1
1045 do_execsql_test e_expr-17.2.2 { SELECT 'abcxyz' NOT GLOB 'abc*' } 0
1046 do_execsql_test e_expr-17.2.3 { SELECT 'abcxyz' NOT LIKE 'ABC%' } 0
1047 do_execsql_test e_expr-17.2.4 { SELECT 'abcxyz' NOT LIKE 'abc%' } 0
1048 do_execsql_test e_expr-17.2.5 { SELECT 'abdxyz' NOT LIKE 'abc%' } 1
1051 do_execsql_test e_expr-17.2.6 { SELECT 'abcxyz' NOT GLOB NULL } null
1052 do_execsql_test e_expr-17.2.7 { SELECT 'abcxyz' NOT LIKE NULL } null
1053 do_execsql_test e_expr-17.2.8 { SELECT NULL NOT GLOB 'abc*' } null
1054 do_execsql_test e_expr-17.2.9 { SELECT NULL NOT LIKE 'ABC%' } null
1066 do_execsql_test e_expr-17.3.1 { SELECT 'abc' GLOB 'def' } 1
1069 do_execsql_test e_expr-17.3.3 { SELECT 'X' NOT GLOB 'Y' } 0
1101 do_execsql_test e_expr-18.2.1 { SELECT 'abc' REGEXP 'def' } 1
1104 do_execsql_test e_expr-18.2.3 { SELECT 'X' NOT REGEXP 'Y' } 0
1130 do_execsql_test e_expr-19.2.1 { SELECT 'abc' MATCH 'def' } 1
1133 do_execsql_test e_expr-19.2.3 { SELECT 'X' NOT MATCH 'Y' } 0
1143 do_execsql_test e_expr-20.1 {
1146 do_execsql_test e_expr-20.2 {
1162 do_execsql_test e_expr-21.1.1 {
1169 do_execsql_test e_expr-21.1.3 {
1183 do_execsql_test e_expr-21.2.1 {
1191 do_execsql_test e_expr-21.2.2 {
1199 do_execsql_test e_expr-21.2.3 {
1212 do_execsql_test e_expr-21.3.1 {
1224 do_execsql_test e_expr-21.3.2 {
1235 do_execsql_test e_expr-21.4.1 {
1238 do_execsql_test e_expr-21.4.2 {
1252 do_execsql_test e_expr-22.1.1 {
1261 do_execsql_test e_expr-22.2.1 {
1264 do_execsql_test e_expr-22.2.2 {
1272 do_execsql_test e_expr-22.3.1 {
1280 do_execsql_test e_expr-22.4.1 {
1284 do_execsql_test e_expr-22.4.2 {
1307 do_execsql_test e_expr-23.1.1 {
1316 do_execsql_test e_expr-23.1.2 {
1319 do_execsql_test e_expr-23.1.3 {
1322 do_execsql_test e_expr-23.1.4 {
1325 do_execsql_test e_expr-23.1.5 {
1328 do_execsql_test e_expr-23.1.6 {
1331 do_execsql_test e_expr-23.1.7 {
1334 do_execsql_test e_expr-23.1.8 {
1337 do_execsql_test e_expr-23.1.9 {
1345 do_execsql_test e_expr-24.1.1 {
1348 do_execsql_test e_expr-24.1.2 {
1357 do_execsql_test e_expr-25.1.1 {
1365 do_execsql_test e_expr-25.1.3 {
1386 do_execsql_test e_expr-26.1.1 {
1392 do_execsql_test e_expr-26.1.2 {
1395 do_execsql_test e_expr-26.1.3 {
1399 do_execsql_test e_expr-26.1.4 {
1404 do_execsql_test e_expr-26.1.6 {
1424 do_execsql_test e_expr-27.1.1 {
1429 do_execsql_test e_expr-27.1.2 {
1709 do_execsql_test e_expr-32.2.8 {
1786 do_execsql_test e_expr-34.1 {
1917 do_execsql_test e_expr-36.3.1 {
1952 do_execsql_test e_expr-37.1 {
1955 do_execsql_test e_expr-37.2 {
1958 do_execsql_test e_expr-37.3 {
1961 do_execsql_test e_expr-37.4 {
1964 do_execsql_test e_expr-37.5 {
1971 do_execsql_test e_expr-37.6 {
1974 do_execsql_test e_expr-37.7 {
1977 do_execsql_test e_expr-37.8 {
1980 do_execsql_test e_expr-37.9 {
1983 do_execsql_test e_expr-37.10 {