Home
last modified time | relevance | path

Searched refs:col (Results 1 – 25 of 52) sorted by relevance

123

/sqlite-3.40.0/contrib/
H A Dsqlitecon.tcl314 foreach col $x(*) {
323 foreach col $x(*) {
332 foreach col $x(*) {
333 if {![info exists cw($col)] || $cw($col)<[string length $x($col)]} {
334 set cw($col) [string length $x($col)]
344 foreach col $x(*) {
345 if {![info exists cw($col)] || $cw($col)<[string length $col]} {
346 set cw($col) [string length $col]
348 lappend hdr $col
358 foreach col $x(*) {
[all …]
/sqlite-3.40.0/test/
H A Dfts3aux2.test60 FROM terms WHERE col = '*' AND languageid=1;
66 SELECT term, col, documents, occurrences, languageid
76 SELECT term, col, documents, occurrences, languageid
82 SELECT term, col, documents, occurrences, languageid
89 SELECT term, col, documents, occurrences, languageid
99 FROM terms WHERE col = '*' AND languageid=2;
105 SELECT term, col, documents, occurrences, languageid
115 SELECT term, col, documents, occurrences, languageid
122 SELECT term, col, documents, occurrences, languageid
129 SELECT term, col, documents, occurrences, languageid
[all …]
H A Dnormalize.test125 CREATE TABLE t1(a,b,c,d,e,"col f",w,x,y,z);
126 CREATE TABLE t2(x,"col y");
312 {SELECT "col f", [col f] FROM t1;}
314 {0 {SELECT"col f","col f"FROM t1;}}
317 {SELECT a, "col f" FROM t1 LEFT OUTER JOIN t2 ON [t1].[col f] == [t2].[col y];}
319 {0 {SELECT a,"col f"FROM t1 LEFT OUTER JOIN t2 ON t1."col f"==t2."col y";}}
H A Dfts3aux1.test27 SELECT term, documents, occurrences FROM terms WHERE col = '*';
35 SELECT term, documents, occurrences FROM terms WHERE col = '*';
43 SELECT term, documents, occurrences FROM terms WHERE col = '*';
56 SELECT term, documents, occurrences FROM terms WHERE col = '*';
88 SELECT term, documents, occurrences FROM terms WHERE col = '*';
403 INSERT INTO x2 SELECT term FROM terms WHERE col = '*';
404 INSERT INTO x3 SELECT term FROM terms WHERE col = '*';
413 SELECT y FROM x2, terms WHERE y = term AND col = '*'
423 SELECT y FROM terms, x2 WHERE y = term AND col = '*'
433 SELECT y FROM x3, terms WHERE y = term AND col = '*'
[all …]
H A Dfts3_common.tcl219 foreach col [lrange $E(*) 1 end] {
220 set c $E($col)
325 foreach col $ret($docid) {
326 foreach {iCol lPos} $col {}
H A Dbestindex6.test45 set col [db one {
50 lappend wlist "$col IS NULL"
54 lappend wlist "$col = %$iCons%"
H A Damatch1.test40 SELECT term FROM t1aux WHERE col=0 ORDER BY 1 LIMIT 5
45 SELECT term FROM t1aux WHERE term>'b' AND col=0 ORDER BY 1 LIMIT 5
50 SELECT term FROM t1aux WHERE term>'b' AND col=0 LIMIT 5
H A Dtkt3121.test30 CREATE TABLE r2(col PRIMARY KEY, descr);
46 from t1 inner join t2 on t1.field = t2.col order by t1.field
H A Dfts3expr4.test49 # In "col:word", if "col" is not the name of a column, the entire thing
H A Daltercol.test253 CREATE TABLE t6("col a", "col b", "col c");
254 CREATE TRIGGER zzz AFTER UPDATE OF "col a", "col c" ON t6 BEGIN
261 UPDATE t6 SET "col c" = 1;
266 ALTER TABLE t6 RENAME "col c" TO "col 3";
270 UPDATE t6 SET "col 3" = 0;
H A Dfts3prefix.test50 $db eval { SELECT term, docid, col, pos FROM temp.terms } a {
56 term = $prefix AND docid = $a(docid) AND col = $a(col) AND pos = $a(pos)
59 error "$t, $a(docid), $a(col), $a(pos)"
H A Dfts3comp1.test91 SELECT term, documents, occurrences FROM terms WHERE col = '*';
98 SELECT term, documents, occurrences FROM terms WHERE col = '*';
H A Dfuzz.test359 set E {{no such col} {ambiguous column name}}
365 set E {{no such col} {ambiguous column name} {table}}
375 set E [list table view duplicate {no such col} {ambiguous column name} {use DROP}]
/sqlite-3.40.0/tool/
H A Dstripccomments.c61 int col = 0; in do_it_all() local
71 ++col){ in do_it_all()
78 startLine = line, startCol = col; in do_it_all()
81 for( ++col; !endOfString && EOF != (ch2 = fgetc(App.input)); in do_it_all()
82 ++col ){ in do_it_all()
98 col = 0; in do_it_all()
133 state3Col = col-1; in do_it_all()
185 if(col!=state3Col+2){ in do_it_all()
199 col = 0; in do_it_all()
H A Dmkopts.tcl21 set col 0
23 global col
27 incr col
30 set col 0
34 global col
36 set col 0
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5prefix.test117 proc gmatch {col pattern} {
122 proc ghl {col pattern} {
123 foreach t $col {
151 foreach col {a b c} {
164 "SELECT ghl($col, '$pattern') FROM t3 WHERE gmatch($col, '$pattern')"
166 set idx $COLS($col)
259 proc gmatch {col pattern} {
263 foreach {tn col pattern} {
268 set query "$col : $pattern"
284 proc gmatch {col pattern} {
[all …]
H A Dfts5_common.tcl229 set O(-col) {}
265 if {$O(-col)!="" && [lsearch $O(-col) $iCol]<0} continue
421 foreach d [list full col none] {
499 foreach col $lCols { lappend cols $x($col) }
591 if {[lsearch $args -col]>=0} {
H A Dfts5detail.test30 CREATE VIRTUAL TABLE t1 USING fts5(a, b, c, detail=col);
74 CREATE VIRTUAL TABLE t2 USING fts5(a, detail=col, prefix="1");
98 # work with detail=col tables.
175 1 { CREATE VIRTUAL TABLE t3 USING fts5(x, y, z, detail=col) }
221 # detail=col, and that detail=col uses less space than detail=full
225 foreach {tbl detail} {t1 none t2 col t3 full} {
H A Dfts5vocab.test73 CREATE VIRTUAL TABLE v2 USING fts5vocab(t1, 'col');
77 1 col {} 0 {} 0
150 1 "fts5vocab(tt, 'col')" res_col
277 CREATE VIRTUAL TABLE txc USING fts5vocab(tx, col);
389 WHERE txc.term = txc_c.term AND txc.col=txc_c.col;
405 CREATE VIRTUAL TABLE x1_c USING fts5vocab(x1, col);
550 CREATE VIRTUAL TABLE t3 USING fts5vocab(rowid , 'col');
H A Dfts5fault5.test76 CREATE VIRTUAL TABLE tt2 USING fts5(x, detail=col);
77 CREATE VIRTUAL TABLE tv2 USING fts5vocab(tt2, 'col');
H A Dfts5simple3.test25 CREATE VIRTUAL TABLE t1 USING fts5(a, b, c, detail=col);
43 # Create detail=col and detail=full tables with 998 columns.
H A Dfts5content.test200 CREATE TABLE x2(a, "key col" PRIMARY KEY, b, c) WITHOUT ROWID;
204 CREATE VIRTUAL TABLE t2 USING fts5(a, c, content=x2, content_rowid='key col');
216 DELETE FROM x2 WHERE "key col" = 1;
/sqlite-3.40.0/ext/fts3/
H A DREADME.syntax8 SELECT * FROM t1 WHERE <col> MATCH <full-text query>
36 <col> MATCH 'hello world'
45 <col> MATCH '"hello world" joe"
60 <col> MATCH 'engineering NEAR consultancy'
69 <col> MATCH 'engineering NEAR/5 consultancy'
87 <col> MATCH 'hello OR world'
96 <col> MATCH 'sqlite fantastic OR impressive'
104 <col> MATCH 'sql*'
113 <col> MATCH '"database engine" -sqlite'
131 <col> MATCH 'col1:hello col2:world'
[all …]
/sqlite-3.40.0/ext/rtree/
H A Drtree2.test94 set col ii
96 set col "c$colidx"
100 lappend where "$col $op $val"
/sqlite-3.40.0/src/
H A Dtest1.c5200 int col; in test_column_type() local
5212 tp = sqlite3_column_type(pStmt, col); in test_column_type()
5249 int col; in test_column_int64() local
5276 int col; in test_column_blob() local
5290 len = sqlite3_column_bytes(pStmt, col); in test_column_blob()
5308 int col; in test_column_double() local
5364 int col; in test_stmt_utf8() local
5377 zRet = xFunc(pStmt, col); in test_stmt_utf8()
5417 int col; in test_stmt_utf16() local
5432 zName16 = xFunc(pStmt, col); in test_stmt_utf16()
[all …]

123