| /dports/databases/sqlite3/sqlite-src-3350500/test/ |
| H A D | index6.test | 6 # May you do good and not evil.
16 set testdir [file dirname $argv0]
195 do_execsql_test index6-2.102eqp {
202 do_execsql_test index6-2.103eqp {
209 do_execsql_test index6-2.104eqp {
223 # unable to insert a duplicate row a-value that is not 999.
229 # can insert multiple rows with a==999 because such rows are not
364 do_execsql_test index6-10.1eqp {
371 do_execsql_test index6-10.2eqp {
378 do_execsql_test index6-10.3eqp {
|
| H A D | permutations.test | 6 # May you do good and not evil.
59 set isExclude 0
142 # is matched, not any directory component of the path.
145 set bIn 1
350 eqp.test e_reindex.test e_resolve.test e_select2.test e_select.test
412 "Vfslog" quick test suite. Like "veryquick" except does not omits
413 a few tests that do not work with a version 1 VFS. And the quota* tests,
414 which do not work with a VFS that uses the pVfs argument passed to
790 # This test does not work as the "PRAGMA journal_mode = memory"
799 # state. Which is not possible with an in-memory journal
[all …]
|
| H A D | skipscan2.test | 6 # May you do good and not evil.
18 set testdir [file dirname $argv0]
59 # Without ANALYZE, a skip-scan is not used
64 do_execsql_test skipscan2-1.3eqp {
84 do_execsql_test skipscan2-1.5eqp {
105 # skip-scan should not be used after an (unfudged) ANALYZE.
123 do_execsql_test skipscan2-1.9eqp {
142 do_execsql_test skipscan2-1.11eqp {
184 do_execsql_test skipscan2-2.5eqp {
195 for {set i 0} {$i < 1000} {incr i} {
[all …]
|
| H A D | tkt-b75a9ca6b0.test | 6 # May you do good and not evil.
20 set testdir [file dirname $argv0]
22 set testprefix tkt-b75a9ca6b0
35 set idxscan {SCAN TABLE t1 USING COVERING INDEX i1}
36 set tblscan {SCAN TABLE t1}
37 set grpsort {USE TEMP B-TREE FOR GROUP BY}
38 set sort {USE TEMP B-TREE FOR ORDER BY}
40 foreach {tn q res eqp} [subst -nocommands {
73 do_eqp_test 1.$tn.2 $q $eqp
|
| H A D | where3.test | 6 # May you do good and not evil.
17 set testdir [file dirname $argv0]
109 set ::sqlite_sort_count 0
110 set data [execsql $sql]
111 set eqp [execsql "EXPLAIN QUERY PLAN $sql"]
112 # puts eqp=$eqp
113 foreach {a b c x} $eqp {
130 # the C table would not reorder. So the following reorderings
136 # But these reorders were not allowed
226 # If the outer loop must be a full table scan, do not let ANALYZE trick
[all …]
|
| H A D | index3.test | 6 # May you do good and not evil.
16 set testdir [file dirname $argv0]
61 do_execsql_test index3-2.2eqp {
|
| H A D | indexexpr1.test | 6 # May you do good and not evil.
15 set testdir [file dirname $argv0]
33 do_execsql_test indexexpr1-110eqp {
40 do_execsql_test indexexpr1-120eqp {
49 do_execsql_test indexexpr1-130eqp {
61 do_execsql_test indexexpr1-141eqp {
72 do_execsql_test indexexpr1-150eqp {
85 do_execsql_test indexexpr1-160eqp {
97 do_execsql_test indexexpr1-170eqp {
450 # "(NULL IS FALSE) IS FALSE" does not imply "NULL IS NULL"
[all …]
|
| H A D | indexexpr2.test | 6 # May you do good and not evil.
16 set testprefix indexexpr2
154 do_execsql_test 3.4.5eqp {
166 set cnt 0
180 set ::cnt
184 set ::cnt
188 set ::cnt 0
190 set ::cnt
195 set ::cnt 0
197 set ::cnt
[all …]
|
| H A D | shell1.test | 6 # May you do good and not evil.
658 # Adverse interaction between .stats and .eqp
665 .eqp full
817 # If the table contains an INTEGER PRIMARY KEY, do not record a separate
842 # an INTEGER PRIMARY KEY DESC is not an alias for the rowid.
865 # Do not record rowids for a WITHOUT ROWID table. Also check correct quoting
889 # Do not record rowids if the rowid is inaccessible
920 } {1 {The --preserve-rowids option is not compatible with SQLITE_OMIT_VIRTUALTABLE}}
1063 # characters do not appear to require escaping on Unix. For
1091 # These test cases do not work on MinGW
[all …]
|
| H A D | where2.test | 6 # May you do good and not evil.
28 set w $i
62 if {[db status sort]} {set x sort} {set x nosort}
74 if {$::sqlite_sort_count} {set x sort} {set x nosort}
76 set eqp [execsql "EXPLAIN QUERY PLAN $sql"]
77 # puts eqp=$eqp
78 foreach {a b c x} $eqp {
143 -- random() is not optimized out
147 -- random() is not optimized out
419 # These tests are not run if subquery support is not included in the
[all …]
|
| H A D | analyze8.test | 6 # May you do good and not evil.
16 set testdir [file dirname $argv0]
24 set testprefix analyze8
26 proc eqp {sql {db db}} {
46 for {set i 0} {$i<1000} {incr i} {
47 if {$i%2==0} {set a $i} {set a [expr {($i%8)*100}]}
48 set b [expr {$i/10}]
49 set c [expr {$i/8}]
50 set c [expr {$c*$c*$c}]
104 eqp {SELECT * FROM t1
[all …]
|
| H A D | analyze9.test | 6 # May you do good and not evil.
26 set ret ""
734 # for indexes that do not exist. Or NULL values in the idx column.
834 if {$i<8} {set b 0} else { set b $i }
920 } {1 {not authorized}}
976 # the index is used. In the second, it is not.
1056 -- Formerly used index i41. But i41 is not a covering index whereas
1081 foreach {tn where eqp} {
1088 do_eqp_test 24.$tn "SeLeCt * FROM t5 WHERE $where" $eqp
1106 # Term (b<?) is estimated at 25%. Better than (a<30) but not as
[all …]
|
| H A D | exists2.test | 6 # May you do good and not evil.
16 set testdir [file dirname $argv0]
18 set testprefix exists2
37 proc do_execsql_eqp_test {tn sql eqp res} {
38 uplevel [list do_eqp_test $tn.1 $sql [string trim $eqp]]
|
| H A D | whereK.test | 6 # May you do good and not evil.
22 set testdir [file dirname $argv0]
24 set ::testprefix whereK
33 do_execsql_test 1.1eqp {
41 do_execsql_test 1.2eqp {
49 do_execsql_test 1.3eqp {
57 do_execsql_test 1.4eqp {
66 do_execsql_test 1.5eqp {
|
| H A D | fts3aux1.test | 6 # May you do good and not evil.
119 set cnt
124 set cnt
128 # is not featured in the dataset.
133 set cnt
138 set cnt
179 set cnt
375 } {1 {table terms may not be modified}}
378 } {1 {table terms may not be modified}}
381 } {1 {table terms may not be modified}}
[all …]
|
| H A D | in4.test | 6 # May you do good and not evil.
14 set testdir [file dirname $argv0]
16 set testprefix in4
97 # i.e. IN expressions with a literal empty set.
217 # hold the list of values on the RHS. But "x IN (?)" does not create
253 # sequence and affinity computations do not get messed up.
330 do_execsql_test in4-6.1-eqp {
337 do_execsql_test in4-6.2-eqp {
|
| H A D | orderbyA.test | 6 # May you do good and not evil.
17 set testdir [file dirname $argv0]
19 set ::testprefix orderbyA
22 set eqp [execsql "EXPLAIN QUERY PLAN $sql"]
23 set rcnt [regexp -all {USE TEMP} $eqp]
51 # of expected sorts if the GROUP BY and ORDER BY are not compatible.
52 set match 1
53 set nomatch 2
55 set match 0
56 set nomatch 1
[all …]
|
| /dports/editors/poke/poke-1.0/jitter/example-vms/jitterlisp/ |
| H A D | jitterlispvm-vm2.c | 25742 JITTER_INSTRUCTION_PROLOG_(primitive-eqp, primitive_meqp, hot) in jitterlispvm_execute_or_initialize()
26040 JITTER_INSTRUCTION_PROLOG_(primitive-fixnum-not-eqp/fR, primitive_mfixnum_mnot_meqp__fR, hot) in jitterlispvm_execute_or_initialize()
26108 # define JITTER_SPECIALIZED_INSTRUCTION_NAME primitive-fixnum-not-eqp/fR in jitterlispvm_execute_or_initialize()
26206 …JITTER_INSTRUCTION_EPILOG_(primitive-fixnum-not-eqp/fR, primitive_mfixnum_mnot_meqp__fR, JITTER_SP… in jitterlispvm_execute_or_initialize()
28019 JITTER_INSTRUCTION_PROLOG_(primitive-not-eqp, primitive_mnot_meqp, hot) in jitterlispvm_execute_or_initialize()
28087 # define JITTER_SPECIALIZED_INSTRUCTION_NAME primitive-not-eqp in jitterlispvm_execute_or_initialize()
28145 …JITTER_INSTRUCTION_EPILOG_(primitive-not-eqp, primitive_mnot_meqp, JITTER_SPECIALIZED_INSTRUCTION_… in jitterlispvm_execute_or_initialize()
50362 …JITTER_INSTRUCTION_PROLOG_(*primitive-fixnum-not-eqp/fR*-no-fast-branches, _Aprimitive_mfixnum_mno… in jitterlispvm_execute_or_initialize()
50434 # define JITTER_SPECIALIZED_INSTRUCTION_NAME *primitive-fixnum-not-eqp/fR*-no-fast-branch… in jitterlispvm_execute_or_initialize()
50501 …JITTER_INSTRUCTION_EPILOG_(*primitive-fixnum-not-eqp/fR*-no-fast-branches, _Aprimitive_mfixnum_mno… in jitterlispvm_execute_or_initialize()
[all …]
|
| /dports/www/chromium-legacy/chromium-88.0.4324.182/third_party/sqlite/src/test/ |
| H A D | indexexpr2.test | 6 # May you do good and not evil.
16 set testprefix indexexpr2
154 do_execsql_test 3.4.5eqp {
166 set cnt 0
180 set ::cnt
184 set ::cnt
188 set ::cnt 0
190 set ::cnt
195 set ::cnt 0
197 set ::cnt
[all …]
|
| H A D | permutations.test | 6 # May you do good and not evil.
59 set isExclude 0
142 # is matched, not any directory component of the path.
145 set bIn 1
350 eqp.test e_reindex.test e_resolve.test e_select2.test e_select.test
412 "Vfslog" quick test suite. Like "veryquick" except does not omits
413 a few tests that do not work with a version 1 VFS. And the quota* tests,
414 which do not work with a VFS that uses the pVfs argument passed to
790 # This test does not work as the "PRAGMA journal_mode = memory"
799 # state. Which is not possible with an in-memory journal
[all …]
|
| H A D | index3.test | 6 # May you do good and not evil.
16 set testdir [file dirname $argv0]
61 do_execsql_test index3-2.2eqp {
|
| H A D | index8.test | 6 # May you do good and not evil.
16 set testdir [file dirname $argv0]
27 # be handled by the index and do not require a table lookup.
41 do_execsql_test 1.0eqp {
54 do_execsql_test 1.1eqp {
|
| H A D | indexexpr1.test | 6 # May you do good and not evil.
15 set testdir [file dirname $argv0]
33 do_execsql_test indexexpr1-110eqp {
40 do_execsql_test indexexpr1-120eqp {
49 do_execsql_test indexexpr1-130eqp {
61 do_execsql_test indexexpr1-141eqp {
72 do_execsql_test indexexpr1-150eqp {
85 do_execsql_test indexexpr1-160eqp {
97 do_execsql_test indexexpr1-170eqp {
450 # "(NULL IS FALSE) IS FALSE" does not imply "NULL IS NULL"
[all …]
|
| H A D | shell1.test | 6 # May you do good and not evil.
658 # Adverse interaction between .stats and .eqp
665 .eqp full
817 # If the table contains an INTEGER PRIMARY KEY, do not record a separate
842 # an INTEGER PRIMARY KEY DESC is not an alias for the rowid.
865 # Do not record rowids for a WITHOUT ROWID table. Also check correct quoting
889 # Do not record rowids if the rowid is inaccessible
920 } {1 {The --preserve-rowids option is not compatible with SQLITE_OMIT_VIRTUALTABLE}}
1063 # characters do not appear to require escaping on Unix. For
1091 # These test cases do not work on MinGW
[all …]
|
| H A D | whereK.test | 6 # May you do good and not evil.
22 set testdir [file dirname $argv0]
24 set ::testprefix whereK
33 do_execsql_test 1.1eqp {
41 do_execsql_test 1.2eqp {
49 do_execsql_test 1.3eqp {
57 do_execsql_test 1.4eqp {
66 do_execsql_test 1.5eqp {
|