Home
last modified time | relevance | path

Searched +refs:set +refs:not +refs:eqp (Results 1 – 25 of 129) sorted by relevance

123456

/dports/databases/sqlite3/sqlite-src-3350500/test/
H A Danalyze8.test6 # 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 Dbetween.test6 # May you do good and not evil.
28 set w $i
31 set z [expr {$x+$y}]
36 # If the $varname syntax is not available, use the regular variable
50 # "sort" or "nosort" keyword depending on whether or not any sorting
54 set ::sqlite_sort_count 0
55 set data [execsql $sql]
56 if {$::sqlite_sort_count} {set x sort} {set x nosort}
58 set eqp [execsql "EXPLAIN QUERY PLAN $sql"]
59 # puts eqp=$eqp
[all …]
H A Danalyze6.test6 # May you do good and not evil.
17 set testdir [file dirname $argv0]
25 set testprefix analyze6
27 proc eqp {sql {db db}} {
88 eqp {SELECT * FROM t201 WHERE z=5}
91 eqp {SELECT * FROM t201 WHERE y=5}
94 eqp {SELECT * FROM t201 WHERE x=5}
101 eqp {SELECT * FROM t201 WHERE z=5}
104 eqp {SELECT * FROM t201 WHERE y=5}
107 eqp {SELECT * FROM t201 WHERE x=5}
[all …]
H A DwhereK.test6 # 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 Dskipscan3.test6 # May you do good and not evil.
18 set testdir [file dirname $argv0]
32 do_execsql_test skipscan3-1.2eqp {
40 # did not prior to changes implemented on 2014-08-20
42 do_execsql_test skipscan3-1.3eqp {
59 do_execsql_test skipscan3-2.2eqp {
65 do_execsql_test skipscan3-2.3eqp {
H A Dtkt-b75a9ca6b0.test6 # 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 Dskipscan2.test6 # 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 …]
/dports/databases/sqlcipher/sqlcipher-3.4.2/test/
H A Danalyze8.test6 # 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 Dbetween.test6 # May you do good and not evil.
28 set w $i
31 set z [expr {$x+$y}]
36 # If the $varname syntax is not available, use the regular variable
50 # "sort" or "nosort" keyword depending on whether or not any sorting
54 set ::sqlite_sort_count 0
55 set data [execsql $sql]
56 if {$::sqlite_sort_count} {set x sort} {set x nosort}
58 set eqp [execsql "EXPLAIN QUERY PLAN $sql"]
59 # puts eqp=$eqp
[all …]
H A Danalyze6.test6 # May you do good and not evil.
17 set testdir [file dirname $argv0]
25 set testprefix analyze6
27 proc eqp {sql {db db}} {
84 eqp {SELECT * FROM t201 WHERE z=5}
87 eqp {SELECT * FROM t201 WHERE y=5}
90 eqp {SELECT * FROM t201 WHERE x=5}
97 eqp {SELECT * FROM t201 WHERE z=5}
100 eqp {SELECT * FROM t201 WHERE y=5}
103 eqp {SELECT * FROM t201 WHERE x=5}
[all …]
H A DwhereK.test6 # 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 Dskipscan3.test6 # May you do good and not evil.
18 set testdir [file dirname $argv0]
32 do_execsql_test skipscan3-1.2eqp {
40 # did not prior to changes implemented on 2014-08-20
42 do_execsql_test skipscan3-1.3eqp {
59 do_execsql_test skipscan3-2.2eqp {
65 do_execsql_test skipscan3-2.3eqp {
H A Dtkt-b75a9ca6b0.test6 # May you do good and not evil.
20 set testdir [file dirname $argv0]
22 set testprefix tkt-b75a9ca6b0
35 set idxscan {0 0 0 {SCAN TABLE t1 USING COVERING INDEX i1}}
36 set tblscan {0 0 0 {SCAN TABLE t1}}
37 set grpsort {0 0 0 {USE TEMP B-TREE FOR GROUP BY}}
38 set sort {0 0 0 {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 Dskipscan2.test6 # 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 Dindex7.test28 set once 1
31 set once 0
34 set sep "("
38 set sep ,
67 # if not.
113 do_execsql_test index7-1.7eqp {
238 do_execsql_test index7-2.102eqp {
245 do_execsql_test index7-2.103eqp {
252 do_execsql_test index7-2.104eqp {
307 1 xyz abc {not xyz}
[all …]
/dports/www/chromium-legacy/chromium-88.0.4324.182/third_party/sqlite/src/test/
H A Danalyze8.test6 # 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 Dbetween.test6 # May you do good and not evil.
28 set w $i
31 set z [expr {$x+$y}]
36 # If the $varname syntax is not available, use the regular variable
50 # "sort" or "nosort" keyword depending on whether or not any sorting
54 set ::sqlite_sort_count 0
55 set data [execsql $sql]
56 if {$::sqlite_sort_count} {set x sort} {set x nosort}
58 set eqp [execsql "EXPLAIN QUERY PLAN $sql"]
59 # puts eqp=$eqp
[all …]
H A Danalyze6.test6 # May you do good and not evil.
17 set testdir [file dirname $argv0]
25 set testprefix analyze6
27 proc eqp {sql {db db}} {
88 eqp {SELECT * FROM t201 WHERE z=5}
91 eqp {SELECT * FROM t201 WHERE y=5}
94 eqp {SELECT * FROM t201 WHERE x=5}
101 eqp {SELECT * FROM t201 WHERE z=5}
104 eqp {SELECT * FROM t201 WHERE y=5}
107 eqp {SELECT * FROM t201 WHERE x=5}
[all …]
H A DwhereK.test6 # 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 Dskipscan3.test6 # May you do good and not evil.
18 set testdir [file dirname $argv0]
32 do_execsql_test skipscan3-1.2eqp {
40 # did not prior to changes implemented on 2014-08-20
42 do_execsql_test skipscan3-1.3eqp {
59 do_execsql_test skipscan3-2.2eqp {
65 do_execsql_test skipscan3-2.3eqp {
H A Dtkt-b75a9ca6b0.test6 # 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 Dskipscan2.test6 # 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 …]
/dports/databases/db5/db-5.3.28/lang/sql/sqlite/test/
H A Danalyze2.test6 # May you do good and not evil.
17 set testdir [file dirname $argv0]
25 set testprefix analyze2
27 # Do not use a codec for tests in this file, as the database file is
63 proc eqp {sql {db db}} {
69 for {set i 0} {$i < 1000} {incr i} {
118 for {set i 0} {$i < 1000} {incr i} {
178 for {set i 0} {$i < 1000} {incr i} {
322 # If the sqlite_stat1 table is not present, then the sqlite_stat2
323 # table is not read. However, if it is the sqlite_stat2 table that
[all …]
H A Danalyze6.test6 # May you do good and not evil.
17 set testdir [file dirname $argv0]
25 set testprefix analyze6
27 proc eqp {sql {db db}} {
84 eqp {SELECT * FROM t201 WHERE z=5}
87 eqp {SELECT * FROM t201 WHERE y=5}
90 eqp {SELECT * FROM t201 WHERE x=5}
97 eqp {SELECT * FROM t201 WHERE z=5}
100 eqp {SELECT * FROM t201 WHERE y=5}
103 eqp {SELECT * FROM t201 WHERE x=5}
[all …]
/dports/science/berkeleygw/BGW-2.0.0/BSE/
H A Dabsorption.inp25 # Note that value refers to energies AFTER scissor shift or eqp corrections.
28 # NOTE: If you are using inteqp.x to interpolate eqp_co.dat into a eqp.dat
97 # 2 = medium - info about k-points, symmetries, and eqp corrections.
169 # Set this to use eigenvalues in eqp.dat and eqp_q.dat
170 # If not set, these files will be ignored.
175 # the shifted and unshifted fine grids and written to eqp.dat,
176 # eqp_q.dat, and bandstructure.dat. If not set, this file will be ignored.
278 # Then you should use eqp_corrections with eqp.dat (and eqp_q.dat).
322 # - If extended_kernel is not set, we restrict the d_vn` and d_cn` coefficients
323 # to the subspaces of d_cc` and d_vv` after the eqp interpolation.
[all …]

123456