Home
last modified time | relevance | path

Searched refs:tbl (Results 1 – 25 of 103) sorted by relevance

12345

/sqlite-3.40.0/test/
H A Dtrigger2.test70 {CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);} \
74 {CREATE TEMP TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
85 DROP TABLE tbl;
220 DROP TABLE tbl;
338 DROP TABLE tbl;
366 DROP TABLE tbl;
374 {t2 BEFORE INSERT ON tbl WHEN (SELECT count(*) FROM tbl) = 0}
409 DROP TABLE tbl;
457 DROP TABLE tbl;
479 DROP TABLE tbl;
[all …]
H A Dwithout_rowid4.test89 DROP TABLE tbl;
149 DELETE FROM tbl;
224 DROP TABLE tbl;
302 DROP TABLE tbl;
342 DROP TABLE tbl;
370 DROP TABLE tbl;
378 {t2 BEFORE INSERT ON tbl WHEN (SELECT count(*) FROM tbl) = 0}
413 DROP TABLE tbl;
461 DROP TABLE tbl;
483 DROP TABLE tbl;
[all …]
H A Dtrigger3.test51 SELECT * FROM tbl;
56 execsql {SELECT * FROM tbl}
70 SELECT * FROM tbl;
85 SELECT * FROM tbl;
113 SELECT * FROM tbl;
119 execsql {DROP TABLE tbl;}
135 SELECT * FROM tbl;
140 DELETE FROM tbl;
141 SELECT * FROM tbl;
157 SELECT * FROM tbl;
[all …]
H A Dschema4.test31 CREATE TABLE tbl(a, b);
35 CREATE INDEX i1 ON tbl(a);
52 UPDATE tbl SET b=a+b, a=a+1;
53 DELETE FROM tbl;
67 DELETE FROM tbl;
79 DELETE FROM tbl;
86 CREATE INDEX i1 ON tbl(a);
100 DELETE FROM tbl;
109 CREATE TABLE tbl(a, b);
128 DELETE FROM tbl;
[all …]
H A Dtrigger4.test139 create view vw as select * from tbl;
141 delete from tbl where a = old.a;
147 insert into tbl values (new.a,new.b);
149 insert into tbl values(101,1001);
150 insert into tbl values(102,1002);
151 insert into tbl select a+2, b+2 from tbl;
152 insert into tbl select a+4, b+4 from tbl;
153 insert into tbl select a+8, b+8 from tbl;
154 insert into tbl select a+16, b+16 from tbl;
155 insert into tbl select a+32, b+32 from tbl;
[all …]
H A Dtkt2817.test22 CREATE TEMP TABLE tbl(a, b, c);
23 -- INSERT INTO tbl VALUES(1, 'abc', 'def');
24 -- INSERT INTO tbl VALUES(2, 'ghi', 'jkl');
29 CREATE TABLE main.tbl(a, b, c);
30 CREATE INDEX main.tbli ON tbl(a, b, c);
31 INSERT INTO main.tbl SELECT a, b, c FROM temp.tbl;
62 CREATE TABLE main.tbl(a, b, c);
63 CREATE INDEX main.tbli ON tbl(a, b, c);
64 INSERT INTO main.tbl SELECT a, b, c FROM temp.tmp;
H A Dfts3_common.tcl171 proc fts3_integrity_check {tbl} { argument
173 fts3_read2 $tbl 1 A
259 proc fts3_terms {tbl where} {
260 fts3_read $tbl $where a
282 proc fts3_doclist {tbl term where} {
283 fts3_read $tbl $where a
374 proc fts3_read2 {tbl where varname} {
378 FROM ${tbl}_segdir WHERE $where
387 FROM ${tbl}_segments
397 proc fts3_read {tbl where varname} {
[all …]
H A Dautoanalyze1.test49 SELECT tbl, (flgs & 0x10)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
54 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
63 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
70 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
77 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
87 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
95 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
103 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
113 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
120 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
H A Dfts3auto.test63 set tbl [lindex $args [expr $nArg-2]]
78 get_near_results $tbl $match $deferred aHit
93 SELECT docid FROM $tbl WHERE $tbl MATCH '$match' ORDER BY docid ASC
97 SELECT docid FROM $tbl WHERE $tbl MATCH '$match' ORDER BY docid DESC
101 SELECT docid, mit(matchinfo($tbl, 'x')) FROM $tbl
106 SELECT docid, mit(matchinfo($tbl, 'x')) FROM $tbl
107 WHERE $tbl MATCH '$match' ORDER BY docid ASC
113 proc fts3_make_deferrable {tbl token {nRow 0}} {
136 proc fts3_zero_long_segments {tbl limit} {
139 UPDATE ${tbl}_segments
[all …]
H A De_droptrigger.test30 set tbl sqlite_temp_master
32 set tbl "$name.sqlite_master"
102 foreach {tn tbl droptrigger before after} {
118 execsql " INSERT INTO $tbl VALUES('1', '2') "
125 execsql " INSERT INTO $tbl VALUES('1', '2') "
140 foreach {tn tbl droptrigger before after} {
156 execsql "UPDATE $tbl SET a = 'abc'"
163 execsql "UPDATE $tbl SET a = 'abc'"
167 foreach {tn tbl droptrigger before after} {
183 execsql "DELETE FROM $tbl"
[all …]
H A Dattach4.test60 execsql "CREATE TABLE $name.tbl(x)"
61 execsql "INSERT INTO $name.tbl VALUES('$f')"
69 lappend L $name [execsql "SELECT x FROM $name.tbl"]
86 UPDATE $name.tbl SET x = '$name';
94 lappend L [execsql "SELECT x FROM $name.tbl"] $f
102 execsql "UPDATE $name.tbl SET x = '$f'"
110 lappend L $name [execsql "SELECT x FROM $name.tbl"]
H A Dtkt-cbd054fa6b.test61 SELECT tbl,idx,neq,nlt,ndlt,test_extract(sample,0) AS sample
68 SELECT tbl,idx,group_concat(s(sample),' ')
71 GROUP BY tbl,idx
100 SELECT tbl,idx,group_concat(s(sample),' ')
103 GROUP BY tbl,idx
H A Dswarmvtab3.test30 CREATE TEMP TABLE swarm(id, tbl, minval, maxval);
87 'SELECT :prefix || id, tbl, minval, minval FROM swarm',
97 'SELECT :prefix || id, tbl, minval, minval FROM swarm',
107 'SELECT :prefix||''.''||:suffix||id, tbl, minval, minval FROM swarm',
142 CREATE TEMP TABLE swarm(file, tbl, minval, maxval, ctx);
207 'SELECT file, tbl, minval, minval, ctx FROM swarm',
H A Danalyze.test306 SELECT DISTINCT tbl FROM sqlite_stat1 ORDER BY 1;
313 SELECT DISTINCT tbl FROM sqlite_stat4 ORDER BY 1;
321 SELECT DISTINCT tbl FROM sqlite_stat1 ORDER BY 1;
328 SELECT DISTINCT tbl FROM sqlite_stat4 ORDER BY 1;
336 SELECT DISTINCT tbl FROM sqlite_stat1 ORDER BY 1;
343 SELECT DISTINCT tbl FROM sqlite_stat4 ORDER BY 1;
377 SELECT tbl FROM sqlite_stat1 WHERE idx IS NULL ORDER BY tbl;
H A Dbestindex4.test25 # Virtual table callback for a virtual table named $tbl.
127 # SELECT * FROM tbl, vtab(tbl.x);
129 # The implicit constraint "tbl.x = vtab.hidden" is not optimized using
130 # an index on tbl.x.
H A DanalyzeC.test38 INSERT INTO sqlite_stat1(tbl,idx,stat)
114 INSERT INTO sqlite_stat1(tbl,idx,stat)
125 INSERT INTO sqlite_stat1(tbl,idx,stat)
155 INSERT INTO sqlite_stat1(tbl,idx,stat)
167 INSERT INTO sqlite_stat1(tbl,idx,stat)
/sqlite-3.40.0/ext/rbu/
H A Drbu5.test22 proc pkcols {db tbl} {
33 proc allcols {db tbl} {
100 set pk [pkcols dbRbu $tbl]
101 set cols [allcols dbRbu $tbl]
106 foreach c $pk { lappend where "main.$tbl.$c IS orig.$tbl.$c" }
112 foreach c $cols { lappend where2 "main.$tbl.$c IS orig.$tbl.$c" }
119 FROM main.$tbl LIMIT 0
124 INSERT INTO rbu.data_$tbl
133 INSERT INTO rbu.data_$tbl
145 INSERT INTO rbu.data_$tbl
[all …]
H A Drbuprogress.test35 CREATE TABLE rbu_count(tbl, cnt);
135 CREATE TABLE rbu_count(tbl, cnt);
163 CREATE TABLE rbu_count(tbl, cnt);
182 CREATE TABLE rbu_count(tbl, cnt);
201 CREATE TABLE rbu_count(tbl, cnt);
286 CREATE TABLE rbu_count(tbl, cnt);
298 foreach {tn tbl} {
309 CREATE TABLE rbu_count(tbl, cnt);
336 reset_db ; execsql $tbl
356 foreach {tn tbl} {
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5conflict.test39 CREATE TABLE tbl(a INTEGER PRIMARY KEY, b, c);
40 CREATE VIRTUAL TABLE fts_idx USING fts5(b, c, content=tbl, content_rowid=a);
41 CREATE TRIGGER tbl_ai AFTER INSERT ON tbl BEGIN
44 CREATE TRIGGER tbl_ad AFTER DELETE ON tbl BEGIN
48 CREATE TRIGGER tbl_au AFTER UPDATE ON tbl BEGIN
57 INSERT INTO tbl VALUES(1, 'x y z', '1 2 3');
58 INSERT INTO tbl VALUES(10, 'x y z', '1 2 3');
59 INSERT INTO tbl VALUES(100, 'x 1 z', '1 y 3');
61 UPDATE tbl SET b = '1 2 x' WHERE rowid=10;
62 REPLACE INTO tbl VALUES(1, '4 5 6', '3 2 1');
[all …]
H A Dfts5_common.tcl162 proc fts5_segcount {tbl} { argument
164 foreach n [fts5_level_segs $tbl] { incr N $n }
168 proc fts5_level_segs {tbl} { argument
177 proc fts5_level_segids {tbl} { argument
477 proc fts5_query_data {expr tbl {order ASC} {aDictVar ""}} {
482 db eval "PRAGMA table_info = $tbl" x { lappend lCols $x(name) }
497 db eval "SELECT rowid, * FROM $tbl ORDER BY rowid $order" x {
514 proc fts5_poslist_data {expr tbl {order ASC} {aDictVar ""}} {
530 proc fts5_collist_data {expr tbl {order ASC} {aDictVar ""}} {
557 proc fts5_expr_ok {expr tbl} { argument
[all …]
H A Dfts5content.test107 CREATE TABLE tbl(a INTEGER PRIMARY KEY, b, c);
108 CREATE VIRTUAL TABLE fts_idx USING fts5(b, c, content='tbl', content_rowid='a');
111 CREATE TRIGGER tbl_ai AFTER INSERT ON tbl BEGIN
114 CREATE TRIGGER tbl_ad AFTER DELETE ON tbl BEGIN
118 CREATE TRIGGER tbl_au AFTER UPDATE ON tbl BEGIN
126 INSERT INTO tbl VALUES(1, 'one', 'o n e');
127 INSERT INTO tbl VALUES(NULL, 'two', 't w o');
128 INSERT INTO tbl VALUES(3, 'three', 't h r e e');
136 DELETE FROM tbl WHERE rowid=2;
141 UPDATE tbl SET c = c || ' x y z';
/sqlite-3.40.0/ext/fts5/tool/
H A Dshowfts5.tcl37 set tbl [lindex $argv end]
48 proc count_terms {tbl arrayname} {
51 db eval "SELECT fts5_decode(rowid, block) AS d FROM ${tbl}_data" {
68 if {$O(nterm)} { count_terms $tbl A }
70 db eval "SELECT fts5_decode(rowid, block) AS d FROM ${tbl}_data WHERE id=10" {
89 db eval "SELECT fts5_decode(rowid, block) AS d FROM ${tbl}_data WHERE id>10" {
/sqlite-3.40.0/ext/session/
H A Dsession_common.tcl163 foreach tbl $lot1 {
167 $db1 eval "PRAGMA table_info = $tbl" { lappend col1 $name }
168 $db2 eval "PRAGMA table_info = $tbl" { lappend col2 $name }
169 if {$col1 != $col2} { error "table $tbl schema mismatch" }
171 set sql "SELECT * FROM $tbl ORDER BY [join $col1 ,]"
177 error "table $tbl data mismatch"
/sqlite-3.40.0/ext/rtree/
H A DrtreeA.test49 proc set_tree_depth {tbl {newvalue ""}} {
50 set blob [db one "SELECT data FROM ${tbl}_node WHERE nodeno=1"]
58 db eval "UPDATE ${tbl}_node SET data = \$blob WHERE nodeno=1"
59 return [set_tree_depth $tbl]
62 proc set_entry_count {tbl nodeno {newvalue ""}} {
63 set blob [db one "SELECT data FROM ${tbl}_node WHERE nodeno=$nodeno"]
73 db eval "UPDATE ${tbl}_node SET data = \$blob WHERE nodeno=$nodeno"
74 return [set_entry_count $tbl $nodeno]
/sqlite-3.40.0/tool/
H A Dlemon.c5292 if( x1a->tbl==0 ){ in Strsafe_init()
5334 oldnp = &(x1a->tbl[i]); in Strsafe_insert()
5336 newnp = &(array.tbl[i]); in Strsafe_insert()
5460 if( x2a->tbl==0 ){ in Symbol_init()
5502 oldnp = &(x2a->tbl[i]); in Symbol_insert()
5504 newnp = &(array.tbl[i]); in Symbol_insert()
5659 if( x3a->tbl==0 ){ in State_init()
5701 oldnp = &(x3a->tbl[i]); in State_insert()
5711 free(x3a->tbl); in State_insert()
5799 if( x4a->tbl==0 ){ in Configtable_init()
[all …]

12345