Home
last modified time | relevance | path

Searched refs:name (Results 1 – 25 of 393) sorted by relevance

12345678910>>...16

/sqlite-3.40.0/tool/
H A Dmkopcodeh.tcl81 set op($name) -1
84 set in1($name) 0
137 set jump($name) 0
138 set in1($name) 0
139 set in2($name) 0
140 set in3($name) 0
141 set out2($name) 0
142 set out3($name) 0
143 set op($name) -1
198 if {$jump($name) && $op($name)>$mxJump} {set mxJump $op($name)}
[all …]
H A Dmkpragmatab.tcl249 COLS: seqno cid name
266 COLS: seq name file
277 COLS: name
284 COLS: name
289 COLS: seq name
416 set name {}
438 set name {}
452 set name $val
483 foreach name $allnames {
492 foreach name $allnames {
[all …]
H A Dmkopts.tcl14 if {![regexp {(([a-zA-Z]+)_)?([_a-zA-Z0-9]+)} $token all px p2 name]} continue
15 lappend namelist [string tolower $name]
39 foreach name [lsort $namelist] {
40 put_item \"$name\",
46 foreach name [lsort $namelist] {
47 regsub -all {@} $name {} name
48 put_item ${prefix}_[string toupper $name],
H A Dmkctimec.tcl393 set name [trim_name $b]
394 set options($name) [subst {
397 "$name=" CTIMEOPT_VAL($b),
404 set name [trim_name $b]
405 set options($name) [subst {
407 "$name",
413 set name [trim_name $v]
414 set options($name) [subst {
416 "$name=" CTIMEOPT_VAL($v),
422 set name [trim_name $v]
[all …]
/sqlite-3.40.0/test/
H A Dzipfile.test349 WHERE a.name=+b.name AND +a.mode=b.mode
357 SELECT name, data FROM zz WHERE name LIKE '%txt'
644 db eval { DELETE FROM zz WHERE name=$name }
735 UPDATE z SET name = 'b1' WHERE name = 'b0';
740 SELECT name, data FROM z ORDER BY name;
743 UPDATE z SET name = 'b1' WHERE name = 'b0';
747 SELECT name, data FROM z ORDER BY name;
756 UPDATE z SET name = name;
757 SELECT name, data FROM z ORDER BY name;
760 UPDATE z SET name = name || 'suffix';
[all …]
H A DcorruptM.test44 SELECT type, name, tbl_name, '|' FROM sqlite_master;
49 SELECT type, name, tbl_name, '|' FROM sqlite_master;
59 SELECT type, name, tbl_name, '|' FROM sqlite_master;
68 SELECT type, name, tbl_name, '|' FROM sqlite_master;
76 UPDATE sqlite_master SET tbl_name='t9',type='table',name='t9'WHERE name='t1';
77 SELECT type, name, tbl_name, '|' FROM sqlite_master;
86 UPDATE sqlite_master SET name='t1',tbl_name='T1' WHERE name='t9';
87 SELECT type, name, tbl_name, '|' FROM sqlite_master;
98 SELECT type, name, tbl_name, '|' FROM sqlite_master;
154 UPDATE sqlite_master SET type='view',name='v3',tbl_name='v3' WHERE name='v2';
[all …]
H A Dattach4.test42 foreach {name f} $files {
43 if {$name == "main"} continue
59 foreach {name f} $files {
68 foreach {name f} $files {
69 lappend L $name [execsql "SELECT x FROM $name.tbl"]
76 foreach {name f} $files {
86 UPDATE $name.tbl SET x = '$name';
93 foreach {name f} $files {
101 foreach {name f} $files {
109 foreach {name f} $files {
[all …]
H A Dzipfile2.test82 WITH contents(name,mtime,data) AS (
118 SELECT name,data FROM zipfile($blob)
130 SELECT name,data FROM zipfile($blob)
138 # WITH contents(name,mtime,data) AS (
222 UPDATE temp.zip SET name='test1' WHERE name='test2'
223 } {1 {duplicate name: "test1"}}
230 UPDATE temp.zip set name=name||'new' where name='test';
232 UPDATE temp.zip set name=name||'new' where name='test';
233 } {1 {duplicate name: "testnew"}}
239 UPDATE OR REPLACE zip SET name='test2' WHERE name='test1';
[all …]
H A Dskipscan2.test62 SELECT name FROM people WHERE height>=180 ORDER BY +name;
66 SELECT name FROM people WHERE height>=180 ORDER BY +name;
82 SELECT name FROM people WHERE height>=180 ORDER BY +name;
86 SELECT name FROM people WHERE height>=180 ORDER BY +name;
121 SELECT name FROM people WHERE height>=180 ORDER BY +name;
125 SELECT name FROM people WHERE height>=180 ORDER BY +name;
140 SELECT name FROM people WHERE height>=180 ORDER BY +name;
144 SELECT name FROM people WHERE height>=180 ORDER BY +name;
160 SELECT name FROM peoplew WHERE height>=180 ORDER BY +name;
181 SELECT name FROM peoplew WHERE height>=180 ORDER BY +name;
[all …]
H A Dcrash4.test29 {CREATE TABLE a(id INTEGER, name CHAR(50))}
30 {INSERT INTO a(id,name) VALUES(1,'one')}
31 {INSERT INTO a(id,name) VALUES(2,'two')}
32 {INSERT INTO a(id,name) VALUES(3,'three')}
33 {INSERT INTO a(id,name) VALUES(4,'four')}
34 {INSERT INTO a(id,name) VALUES(5,'five')}
35 {INSERT INTO a(id,name) VALUES(6,'six')}
36 {INSERT INTO a(id,name) VALUES(7,'seven')}
37 {INSERT INTO a(id,name) VALUES(8,'eight')}
38 {INSERT INTO a(id,name) VALUES(9,'nine')}
[all …]
H A Dtkt3997.test31 create table mytext(name BLOB);
39 SELECT name
41 ORDER BY name COLLATE reverse
46 SELECT name
47 FROM (SELECT name FROM mytext)
48 ORDER BY name COLLATE reverse
60 SELECT name
62 ORDER BY name
67 SELECT name
68 FROM (SELECT name FROM mytext2)
[all …]
H A DvtabJ.test32 SELECT fullname, value FROM tclvar WHERE name='vtabJ' ORDER BY fullname;
39 SELECT fullname, value FROM tclvar WHERE name='vtabJ' ORDER BY fullname;
107 SELECT name, value FROM tclvar where name = 'xx';
111 WHERE name = 'xx' OR name = 'x'||'x';
112 SELECT name, value FROM tclvar where name = 'xx';
116 WHERE name = 'xx' OR name BETWEEN 'xx' AND 'xx';
117 SELECT name, value FROM tclvar where name = 'xx';
121 DELETE FROM tclvar WHERE name BETWEEN 'xx' AND 'xx' OR name='xx';
122 SELECT name, value FROM tclvar where name = 'xx';
137 UPDATE tclvar SET value = var.v FROM var WHERE name = var.k;
[all …]
H A Dwapp.tcl217 proc wapp-clear-cookie {name} {
218 wapp-set-cookie $name {}
248 proc wapp-param {name {dflt {}}} {
251 return [dict get $wapp $name]
256 proc wapp-param-exists {name} {
258 return [dict exists $wapp $name]
265 dict set wapp $name $value
536 set name [string toupper $name]
537 switch -- $name {
542 HOST {set name HTTP_HOST}
[all …]
H A Dorderby1.test35 name TEXT,
51 SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
69 SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
88 SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
94 SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
138 SELECT name FROM album CROSS JOIN track USING (aid)
144 SELECT name FROM album CROSS JOIN track USING (aid)
151 SELECT name FROM album CROSS JOIN track USING (aid)
172 name TEXT,
319 name TEXT,
[all …]
H A Dstat.test36 } {/0 name TEXT .* 1 path TEXT .* 9 pgsize INTEGER/}
44 } {/0 name TEXT .* 1 path TEXT .* 9 pgsize INTEGER/}
78 FROM stat WHERE name = 't1';
84 FROM stat WHERE name = 'i1';
90 FROM stat WHERE name = 'sqlite_schema';
113 FROM stat WHERE name != 'sqlite_schema' ORDER BY name;
140 SELECT * FROM dbstat WHERE aggregate=TRUE ORDER BY name;
163 FROM stat WHERE name != 'sqlite_schema' ORDER BY name;
197 FROM stat WHERE name = 't5' OR name = 'i5';
216 FROM stat WHERE name = 't1';
[all …]
H A Dalter.test85 SELECT type, name, tbl_name FROM objlist ORDER BY tbl_name, type desc, name;
129 SELECT type, name, tbl_name FROM objlist ORDER BY tbl_name, type desc, name;
208 SELECT type, name, tbl_name FROM objlist ORDER BY tbl_name, type desc, name;
716 execsql {SELECT name FROM sqlite_master WHERE name GLOB 'xyz*'}
719 execsql {SELECT name FROM sqlite_master WHERE name GLOB 'sqlite_autoindex*'}
723 execsql {SELECT name FROM sqlite_master WHERE name GLOB 'xyz*'}
726 execsql {SELECT name FROM sqlite_master WHERE name GLOB 'sqlite_autoindex*'}
823 SELECT name FROM sqlite_master WHERE name GLOB 't3102*' ORDER BY 1;
829 SELECT name FROM sqlite_master WHERE name GLOB 't3102*' ORDER BY 1;
835 SELECT name FROM sqlite_master WHERE name GLOB 't3102*' ORDER BY 1;
[all …]
H A Dindex.test24 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
39 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
46 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
87 ORDER BY name}
104 ORDER BY name}
121 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
162 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
189 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
199 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
204 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
[all …]
H A Dautoinc.test226 WHERE name='t1';
644 SELECT * FROM sqlite_sequence WHERE name LIKE 't3928%' ORDER BY name;
707 name='sqlite_sequence',
709 WHERE name='fake_sequence';
730 name='x_sequence',
732 WHERE name='sqlite_sequence';
757 WHERE name='sqlite_sequence';
783 WHERE name='sqlite_sequence';
785 WHERE name='fake';
806 WHERE name='sqlite_sequence';
[all …]
H A DvtabH.test74 SELECT name, arrayname, value FROM vars WHERE name = 'xyz';
116 execsql "SELECT name, value FROM vars WHERE name MATCH 'x*' AND $expr"
136 SELECT name FROM fsdir WHERE dir = '.' AND name = 'test.db';
137 SELECT name FROM fsdir WHERE dir = '.' AND name = '.'
152 foreach name $names {
154 if {[file attributes $name -hidden]} continue
155 if {[file attributes $name -system]} continue
156 lappend res $name
168 foreach name $names {
170 if {[file attributes $name -hidden]} continue
[all …]
H A Dauth.test29 proc_real proc {name arguments script} {
30 proc_real $name $arguments $script
31 if {$name=="auth"} {
69 execsql {SELECT name FROM sqlite_master}
91 execsql {SELECT name FROM sqlite_master}
135 execsql {SELECT name FROM sqlite_master}
148 execsql {SELECT name FROM sqlite_master}
1146 SELECT name FROM sqlite_master;
2502 SELECT name FROM (
2505 ORDER BY name
[all …]
H A Dtrans.test322 ORDER BY name
331 ORDER BY name;
339 ORDER BY name;
347 ORDER BY name;
359 ORDER BY name;
367 ORDER BY name;
376 ORDER BY name;
384 ORDER BY name;
397 ORDER BY name;
405 ORDER BY name;
[all …]
H A Dresolver01.test41 } {1 {ambiguous column name: y}}
84 } {1 {ambiguous column name: y}}
108 # input column name matches.
117 } {1 {ambiguous column name: y}}
122 } {1 {ambiguous column name: y}}
190 CREATE TABLE t61(name);
191 SELECT min(name) FROM t61 GROUP BY lower(name);
194 SELECT min(name) AS name FROM t61 GROUP BY lower(name);
197 CREATE TABLE t63(name);
201 NULLIF(name,'abc') AS name
[all …]
H A Dpragma5.test33 0 name {} 0 {} 0
41 SELECT DISTINCT name, builtin
42 FROM pragma_function_list WHERE name='upper' AND builtin
45 SELECT DISTINCT name, builtin
46 FROM pragma_function_list WHERE name LIKE 'exter%';
53 0 name {} 0 {} 0
56 SELECT * FROM pragma_module_list WHERE name='fts5'
63 0 name {} 0 {} 0
66 SELECT * FROM pragma_pragma_list WHERE name='pragma_list'
H A Davtrans.test284 ORDER BY name
293 ORDER BY name;
301 ORDER BY name;
309 ORDER BY name;
321 ORDER BY name;
329 ORDER BY name;
338 ORDER BY name;
346 ORDER BY name;
359 ORDER BY name;
367 ORDER BY name;
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5delete.test58 name TEXT,
62 name, content=test, content_rowid=id
67 INSERT INTO test_idx (test_idx, rowid, name) VALUES('delete', 1, 'quick');
71 INSERT INTO test_idx(rowid, name) VALUES(123, 'one one one');
72 INSERT INTO test_idx (test_idx, rowid, name) VALUES('delete', 123, 'one');
73 INSERT INTO test_idx (test_idx, rowid, name) VALUES('delete', 123, 'one');
79 name, content=test, content_rowid=id
82 INSERT INTO test_idx(rowid, name) VALUES(123, 'one one one');
83 INSERT INTO test_idx(rowid, name) VALUES(124, 'two two two');
84 INSERT INTO test_idx(rowid, name) VALUES(125, 'two two two');
[all …]

12345678910>>...16