Home
last modified time | relevance | path

Searched refs:sql (Results 1 – 25 of 362) sorted by relevance

12345678910>>...15

/sqlite-3.40.0/test/
H A Dpg_common.tcl19 proc execsql {sql} { argument
21 set sql [string map {{WITHOUT ROWID} {}} $sql]
29 set sql [string range $sql $i+1 end]
35 set frag $sql
36 set sql ""
72 proc execsql_test {tn sql} { argument
73 set res [execsql $sql]
74 set sql [string map {string_agg group_concat} $sql]
90 set sql [string map {string_agg group_concat} $sql]
103 set res [execsql $sql]
[all …]
H A Dspeed2.test84 set sql {}
95 set sql {}
109 set sql {}
120 set sql {}
133 set sql {}
144 set sql {}
164 set sql {}
174 set sql {}
183 set sql {}
192 set sql {}
[all …]
H A Dspeed1.test88 set sql {}
99 set sql {}
113 set sql {}
126 set sql {}
148 set sql {}
160 set sql {}
171 set sql {}
182 set sql {}
196 set sql {}
208 set sql {}
[all …]
H A Dspeed4.test132 set sql ""
143 set sql ""
151 set sql ""
153 append sql "
178 set sql ""
183 set sql ""
186 append sql "
191 set sql ""
210 set sql ""
215 set sql ""
[all …]
H A Dindex2.test21 set sql {CREATE TABLE t1(}
23 append sql "c$i,"
25 append sql "c1000);"
26 execsql $sql
31 append sql $i,
33 append sql {1000);}
34 execsql $sql
47 execsql $sql
61 append sql c$i,
63 append sql c1000)
[all …]
H A Dtester.tcl1125 execsql $sql
1553 $db eval $sql A {
1604 proc execsql2 {sql} { argument
1606 db eval $sql data {
1616 proc memdbsql {sql} { argument
1626 set sql [string trim $sql]
1794 puts $f "$sql"
2124 set sql {
2131 set sql {
2176 set sql ""
[all …]
H A Dtrace2.test29 proc sql {zSql} { db one $zSql }
32 db func sql sql
40 execsql $sql
66 SELECT sql('SELECT 1, 2, 3');
68 "SELECT sql('SELECT 1, 2, 3');"
73 SELECT sql('SELECT 1,
78 "SELECT sql('SELECT 1,
88 SELECT sql('SELECT 1,
94 "SELECT sql('SELECT 1,
106 SELECT $var, sql('SELECT 1,
[all …]
H A Dlock_common.tcl49 proc sql1 {sql} { db eval $sql }
50 proc sql2 {sql} { code2 [list db2 eval $sql] }
51 proc sql3 {sql} { code3 [list db3 eval $sql] }
53 proc csql1 {sql} { list [catch { sql1 $sql } msg] $msg }
54 proc csql2 {sql} { list [catch { sql2 $sql } msg] $msg }
55 proc csql3 {sql} { list [catch { sql3 $sql } msg] $msg }
H A Dalterauth2.test32 proc do_auth_test {tn sql authcode} {
35 execsql {$sql}
64 {SQLITE_READ sqlite_master sql main {}}
68 {SQLITE_READ sqlite_temp_master sql temp {}}
73 {SQLITE_UPDATE sqlite_master sql main {}}
88 {SQLITE_READ sqlite_master sql main {}}
92 {SQLITE_READ sqlite_temp_master sql temp {}}
95 {SQLITE_UPDATE sqlite_master sql main {}}
108 {SQLITE_READ sqlite_master sql main {}}
112 {SQLITE_READ sqlite_temp_master sql temp {}}
[all …]
H A Dbestindex8.test217 foreach {tn sql lfa} {
234 execsql $sql
276 foreach {tn sql lbir} {
285 execsql $sql
362 lappend ret idxStr $sql
369 set sql $idxstr
371 set sql [string map [list %$ii% $a] $sql]
372 set sql [string map [list %I$ii% [join $a ,]] $sql]
375 lappend ::lFilterSql $sql
382 $sql
[all …]
H A Dwhere3.test108 proc queryplan {sql} {
110 set data [execsql $sql]
405 append sql $::predicate
406 db eval $sql
412 db eval $sql
418 db eval $sql
424 db eval $sql
430 db eval $sql
436 db eval $sql
442 db eval $sql
[all …]
H A Djoin3.test30 set sql "SELECT * FROM t1"
31 for {set i 2} {$i<=$N} {incr i} {append sql ", t$i"}
32 execsql $sql
42 set sql "SELECT * FROM t1"
43 for {set i 2} {$i<=$N} {incr i} {append sql ", t$i"}
46 append sql " $sep t[expr {$i+1}].x==t$i.x+1"
49 execsql $sql
56 set sql "SELECT * FROM t1 AS t0, t1"
57 for {set i 2} {$i<=$bitmask_size} {incr i} {append sql ", t$i"}
58 catchsql $sql
H A DmallocK.test21 set sql {SELECT * FROM t1, t2 WHERE (a=1 OR a=2)}
23 append sql " AND b=y"
24 do_malloc_test mallocK-1.$x -sqlbody $sql -sqlprep {
32 append sql " AND b!=$x"
33 do_malloc_test mallocK-2.$x -sqlbody $sql -sqlprep {
38 set sql {SELECT * FROM t1 WHERE a BETWEEN 5 AND 10}
40 append sql " AND b=$x"
46 set sql {SELECT * FROM t1 WHERE b=0}
52 append sql " OR $term)"
59 set sql {SELECT * FROM t2 WHERE a MATCH 'xyz'}
[all …]
H A Daltercol.test115 SELECT sql FROM sqlite_master WHERE tbl_name='t1' AND sql!=''
354 foreach sql $lSchema {
355 execsql $sql
361 SELECT sql FROM sqlite_master WHERE sql!='' ORDER BY 1
467 SELECT sql FROM sqlite_master;
837 SELECT sql FROM sqlite_schema;
879 INSERT INTO schema_copy(name,sql) SELECT name, sql FROM sqlite_schema WHERE sql IS NOT NULL;
885 SELECT name, sql FROM sqlite_master
894 WHERE (name, sql) NOT IN (SELECT name, sql FROM schema_copy);
904 INSERT INTO schema_copy(name,sql) SELECT name, sql FROM sqlite_schema WHERE sql IS NOT NULL;
[all …]
H A DselectG.test28 set sql "CREATE TABLE t1(x);\nINSERT INTO t1(x) VALUES"
30 append sql "($i),"
32 append sql "($i);"
33 set microsec [lindex [time {db eval $sql}] 0]
43 set sql "SELECT (VALUES"
45 append sql "($i),"
47 append sql "($i));"
48 db eval $sql
55 set n [llength [split [db eval "explain $sql"] \n]]
H A Dbadutf2.test71 set sql "SELECT '$hstr'=CAST(x'$uval' AS text) AS x;"
72 set res [ sqlite3_exec db $sql ]
76 set sql "SELECT CAST('$hstr' AS blob)=x'$uval' AS x;"
77 set res [ sqlite3_exec db $sql ]
82 set sql "SELECT hex(CAST(x'$uval' AS text)) AS x;"
83 set res [ sqlite3_exec db $sql ]
87 set sql "SELECT hex(CAST(x'$uval' AS text)) AS x;"
88 set res [ sqlite3_exec db $sql ]
95 set sql "SELECT hex('$hstr') AS x;"
96 set res [ sqlite3_exec db $sql ]
H A Dalter4.test45 SELECT sql FROM sqlite_temp_master;
50 SELECT sql FROM temp.sqlite_master;
56 SELECT sql FROM sqlite_temp_master;
61 SELECT sql FROM temp.sqlite_master;
67 SELECT sql FROM sqlite_temp_master;
72 SELECT sql FROM temp.sqlite_master;
98 SELECT sql FROM sqlite_temp_master
107 SELECT sql FROM sqlite_temp_master
251 SELECT sql FROM aux.sqlite_master;
340 set ::sql ""
[all …]
/sqlite-3.40.0/tool/
H A Dsqldiff.c470 Str sql; in dump_table() local
471 strInit(&sql); in dump_table()
484 strFree(&sql); in dump_table()
539 strInit(&sql); in diff_one_table()
657 strPrintf(&sql, ")\n"); in diff_one_table()
764 strFree(&sql); in diff_one_table()
1377 strFree(&sql); in rbudiff_one_table()
1407 strInit(&sql); in summarize_one_table()
1509 strFree(&sql); in summarize_one_table()
1595 strInit(&sql); in changeset_one_table()
[all …]
/sqlite-3.40.0/ext/session/
H A Dsession_common.tcl38 set O(-sql) [list]
56 execsql $O(-sql)
73 proc do_common_sql {sql} { argument
74 execsql $sql db
75 execsql $sql db2
87 db eval $sql
104 db eval $sql
122 db eval $sql
136 execsql $sql
154 set lot1 [$db1 eval $sql]
[all …]
/sqlite-3.40.0/ext/fts3/
H A Dfts3speed.tcl33 proc sql {sql} { argument
34 puts $::fd $sql
72 sql "PRAGMA synchronous = OFF;"
73 sql "DROP TABLE IF EXISTS t1;"
74 sql "CREATE VIRTUAL TABLE t1 USING fts4;"
77 sql "INSERT INTO t1 VALUES('$doc');"
82 sql "INSERT INTO t1(t1) VALUES('optimize');"
87 sql "SELECT count(*) FROM t1 WHERE t1 MATCH '[select_term]';"
93 sql "SELECT count(*) FROM t1 WHERE t1 MATCH '[select_term] [select_term]';"
/sqlite-3.40.0/ext/wasm/
H A Ddemo-123.js63 sql:"CREATE TABLE IF NOT EXISTS t(a,b)" property
75 sql: "insert into t(a,b) values (?,?)", property
80 sql: "insert into t(a,b) values ($a,$b)", property
108 sql: "select a from t order by a limit 3", property
117 sql: "select a as aa, b as bb from t order by aa limit 3", property
126 sql: "select a from t order by a limit 3", property
135 sql: "select a, b from t order by a limit 3", property
144 sql: "select a a, b from t order by a limit 3", property
154 sql: "select a, b from t order by a limit 3", property
170 sql: "select a, twice(a), twice(''||a) from t order by a desc limit 3", property
[all …]
H A Ddemo-worker1-promiser.js104 sql: ["create table t(a,b)", property
116 sql: 'select a a, b b from t order by a', property
128 sql: 'select a a, b b from t order by a', property
140 {sql:'intentional_error'}, property
147 sql:'select 1 union all select 3', property
172 sql: 'select a a, b B from t order by a limit 3', property
194 sql: 'select a a from t limit 3', property
213 sql: "select 'foo' foo, a bar, 'baz' baz from t limit 2", property
224 sql:[ property
240 await wtest('exec',{sql: 'delete from t where a>3'}); property
[all …]
/sqlite-3.40.0/ext/wasm/api/
H A Dsqlite3-api-oo1.js188 __vfsPostOpenSql[pVfs] = sql;
374 out.sql = args[0];
376 out.sql = args[0];
379 out.sql = out.opt.sql;
383 out.sql = args[0];
388 out.sql = util.flexibleString(out.sql);
389 if('string'!==typeof out.sql){
604 prepare: function(sql){ argument
764 if(!arg.sql){
782 let sqlByteLen = isTA ? arg.sql.byteLength : wasm.jstrlen(arg.sql);
[all …]
/sqlite-3.40.0/ext/recover/
H A Drecoverfault2.test18 proc compare_result {db1 db2 sql} {
19 set r1 [$db1 eval $sql]
20 set r2 [$db2 eval $sql]
24 error "mismatch for $sql"
30 compare_result $db1 $db2 "SELECT sql FROM sqlite_master ORDER BY 1"
43 proc my_sql_hook {sql} {
44 lappend ::lSql $sql
75 proc my_sql_hook {sql} {
76 lappend ::lSql $sql
H A Drecoverold.test17 proc compare_result {db1 db2 sql} {
18 set r1 [$db1 eval $sql]
19 set r2 [$db2 eval $sql]
21 puts "sql: $sql"
24 error "mismatch for $sql"
30 compare_result $db1 $db2 "SELECT sql FROM sqlite_master ORDER BY 1"
70 uplevel [list do_test $tn.sql [list compare_dbs db db2] {}]
72 uplevel [list do_execsql_test -db db2 $tn.sql $tsql $res]
77 proc my_sql_hook {sql} {
78 lappend ::sqlhook $sql

12345678910>>...15