/dports/databases/sqlite3/sqlite-src-3350500/test/ |
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 | between.test | 6 # 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 D | analyze6.test | 6 # 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 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 | skipscan3.test | 6 # 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 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 | 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 …]
|
/dports/databases/sqlcipher/sqlcipher-3.4.2/test/ |
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 | between.test | 6 # 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 D | analyze6.test | 6 # 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 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 | skipscan3.test | 6 # 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 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 {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 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 | index7.test | 28 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 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 | between.test | 6 # 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 D | analyze6.test | 6 # 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 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 | skipscan3.test | 6 # 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 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 | 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 …]
|
/dports/databases/db5/db-5.3.28/lang/sql/sqlite/test/ |
H A D | analyze2.test | 6 # 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 D | analyze6.test | 6 # 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 D | absorption.inp | 25 # 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 …]
|