Home
last modified time | relevance | path

Searched refs:type (Results 1 – 25 of 198) sorted by relevance

12345678

/sqlite-3.40.0/test/
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;
77 SELECT type, name, tbl_name, '|' FROM sqlite_master;
87 SELECT type, name, tbl_name, '|' FROM sqlite_master;
97 UPDATE sqlite_master SET type='view' WHERE name='t1';
98 SELECT type, name, tbl_name, '|' FROM sqlite_master;
110 SELECT type, name, tbl_name, '|' FROM sqlite_master;
121 SELECT type, name, tbl_name, '|' FROM sqlite_master;
[all …]
H A Dtransitive1.test151type="season" season="3">http://thetvdb.com/banners/seasons/80379-3-9.jpg</thumb><thumb aspect="po…
152type="season" season="6">http://thetvdb.com/banners/seasons/80379-6-6.jpg</thumb><thumb aspect="po…
153type="season" season="6">http://thetvdb.com/banners/seasons/80379-6-5.jpg</thumb><thumb aspect="po…
154type="season" season="5">http://thetvdb.com/banners/seasons/80379-5-2.jpg</thumb><thumb aspect="po…
155type="season" season="2">http://thetvdb.com/banners/seasons/80379-2-3.jpg</thumb><thumb aspect="po…
156type="season" season="3">http://thetvdb.com/banners/seasons/80379-3-7.jpg</thumb><thumb aspect="po…
160type="season" season="-1">http://thetvdb.com/banners/posters/80379-22.jpg</thumb><thumb aspect="po…
161type="season" season="-1">http://thetvdb.com/banners/posters/80379-8.jpg</thumb><thumb aspect="pos…
213 CREATE INDEX ix_bookmark ON bookmark (idFile, type);
227 CREATE INDEX ix_art ON art(media_id, media_type, type);
[all …]
H A Djson101.test148 "type": "home",
152 "type": "office",
162 "type": "donut",
177 { "id": "5001", "type": "None" },
179 { "id": "5005", "type": "Sugar" },
183 { "id": "5004", "type": "Maple" }
190 "type": "donut",
205 { "id": "5001", "type": "None" },
211 { "id": "5004", "type": "Maple" }
216 "type": "donut",
[all …]
H A Dexists.test38 sql2 { SELECT name FROM sqlite_master WHERE type = 'table' }
46 sql2 { SELECT name FROM sqlite_master WHERE type = 'table' }
57 sql2 { SELECT name FROM sqlite_master WHERE type = 'index' }
67 sql2 { SELECT name FROM sqlite_master WHERE type = 'view' }
77 sql2 { SELECT name FROM sqlite_master WHERE type = 'trigger' }
92 sql2 { SELECT name FROM sqlite_master WHERE type = 'table' }
102 sql2 { SELECT name FROM sqlite_master WHERE type = 'index' }
111 sql2 { SELECT name FROM sqlite_master WHERE type = 'view' }
120 sql2 { SELECT name FROM sqlite_master WHERE type = 'trigger' }
163 sql2 { SELECT * FROM aux.sqlite_master WHERE type = 'index' }
[all …]
H A Dtrans.test321 WHERE type='table' OR type='index'
330 WHERE type='table' OR type='index'
338 WHERE type='table' OR type='index'
346 WHERE type='table' OR type='index'
358 WHERE type='table' OR type='index'
366 WHERE type='table' OR type='index'
375 WHERE type='table' OR type='index'
383 WHERE type='table' OR type='index'
396 WHERE type='table' OR type='index'
404 WHERE type='table' OR type='index'
[all …]
H A Davtrans.test283 WHERE type='table' OR type='index'
292 WHERE type='table' OR type='index'
300 WHERE type='table' OR type='index'
308 WHERE type='table' OR type='index'
320 WHERE type='table' OR type='index'
328 WHERE type='table' OR type='index'
337 WHERE type='table' OR type='index'
345 WHERE type='table' OR type='index'
358 WHERE type='table' OR type='index'
366 WHERE type='table' OR type='index'
[all …]
H A Dalterauth2.test25 proc xAuth {type args} {
26 lappend ::auth [concat $type [lrange $args 0 3]]
27 if {$type=="SQLITE_READ" && [lindex $args 0] == "t2"} breakpoint
66 {SQLITE_READ sqlite_master type main {}}
70 {SQLITE_READ sqlite_temp_master type temp {}}
90 {SQLITE_READ sqlite_master type main {}}
93 {SQLITE_READ sqlite_temp_master type temp {}}
110 {SQLITE_READ sqlite_master type main {}}
113 {SQLITE_READ sqlite_temp_master type temp {}}
H A Dindex.test24 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
27 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
33 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
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}
86 WHERE type='index' AND tbl_name='test1'
103 WHERE type='index' AND tbl_name='test1'
173 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
213 SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name;
234 WHERE type='index' AND tbl_name='test1'
[all …]
H A Dtable.test28 SELECT sql FROM sqlite_master WHERE type!='meta'
39 execsql {SELECT name, tbl_name, type FROM sqlite_master WHERE type!='meta'}
48 execsql {SELECT name, tbl_name, type from sqlite_master WHERE type!='meta'}
55 execsql {SELECT * FROM sqlite_master WHERE type!='meta'}
64 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
71 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
75 execsql {SELECT name FROM "sqlite_master" WHERE type!='meta'}
83 execsql {SELECT name FROM "sqlite_master" WHERE type!='meta'}
173 execsql {SELECT sql FROM sqlite_master WHERE type=='table'}
195 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
[all …]
H A Dalterauth.test25 proc xAuth {type args} {
26 if {$type == "SQLITE_ALTER_TABLE"} {
27 lappend ::auth [concat $type [lrange $args 0 3]]
53 proc xAuth {type args} {
54 if {$type == "SQLITE_ALTER_TABLE"} {
H A Dalter.test74 INSERT INTO objlist SELECT type, name, tbl_name
79 INSERT INTO objlist SELECT type, name, tbl_name
85 SELECT type, name, tbl_name FROM objlist ORDER BY tbl_name, type desc, name;
121 INSERT INTO objlist SELECT type, name, tbl_name
125 INSERT INTO objlist SELECT type, name, tbl_name
129 SELECT type, name, tbl_name FROM objlist ORDER BY tbl_name, type desc, name;
158 SELECT type, name, tbl_name FROM objlist
159 ORDER BY tbl_name, type desc, name;
200 INSERT INTO objlist SELECT type, name, tbl_name
208 SELECT type, name, tbl_name FROM objlist ORDER BY tbl_name, type desc, name;
[all …]
H A Dvtab3.test85 SELECT name FROM sqlite_master WHERE type = 'table';
97 SELECT name FROM sqlite_master WHERE type = 'table';
109 SELECT name FROM sqlite_master WHERE type = 'table';
124 SELECT name FROM sqlite_master WHERE type = 'table';
136 SELECT name FROM sqlite_master WHERE type = 'table';
H A DwindowC.test34 foreach type {text blob} {
35 do_test 1.$type.$tn.1 {
38 if {$type=="text"} {
51 do_test 1.$type.$tn.2.$tn2 {
/sqlite-3.40.0/src/
H A Dparse.y194 %type temp {int}
306 %type nm {Token}
398 %type autoinc {int}
415 %type refact {int}
455 %type onconf {int}
456 %type orconf {int}
670 %type as {Token}
746 %type dbnm {Token}
776 %type joinop {int}
852 %type nulls {int}
[all …]
/sqlite-3.40.0/tool/
H A Dmkpragmatab.tcl237 COLS: schema name type ncol wr strict
271 COLS: name builtin type enc narg flags
417 set type {}
439 set type {}
453 set type [string toupper $val]
455 set type $val
484 set type [lindex $allbyname($name) 0]
488 set seentype($type) 1
493 set type [lindex $allbyname($name) 0]
497 set seentype($type) 1
[all …]
H A Dlemon.c346 enum e_action type; member
521 rc = (int)ap1->type - (int)ap2->type; in actioncmp()
523 if( rc==0 && (ap1->type==REDUCE || ap1->type==SHIFTREDUCE) ){ in actioncmp()
543 enum e_action type, in Action_add() argument
551 newaction->type = type; in Action_add()
554 if( type==SHIFT ){ in Action_add()
1246 if( apx->type==SHIFT && apy->type==SHIFT ){ in resolve_conflict()
1250 if( apx->type==SHIFT && apy->type==REDUCE ){ in resolve_conflict()
1269 }else if( apx->type==REDUCE && apy->type==REDUCE ){ in resolve_conflict()
4580 if( ap->type==REDUCE || ap->type==SHIFTREDUCE ){ in ReportTable()
[all …]
/sqlite-3.40.0/ext/wasm/api/
H A Dsqlite3-worker1-promiser.js143 return msg.type+'#'+(idTypeMap[msg.type] = (idTypeMap[msg.type]||0) + 1);
154 if(ev && 'sqlite3-api'===ev.type && 'worker1-ready'===ev.result) {
159 msgHandler = handlerMap[ev.type] /* check for exec per-row callback */;
169 switch(ev.type){
191 type: arguments[0], property
203 if('exec'===msg.type && msg.args){
232 debug("Posting",msg.type,"message to Worker dbId="+(dbId||'default')+':',msg);
H A Dsqlite3-api-worker1.js529 type: theCallback, property
544 type: theCallback, property
606 let result, dbId = ev.dbId, evType = ev.type;
613 toss("Unknown db worker message type:",ev.type);
618 operation: ev.type,
637 type: evType, property
652 self.postMessage({type:'sqlite3-api',result:'worker1-ready'}); property
/sqlite-3.40.0/ext/fts5/
H A Dfts5parse.y85 %type cnearset {Fts5ExprNode*}
86 %type expr {Fts5ExprNode*}
87 %type exprlist {Fts5ExprNode*}
92 %type colset {Fts5Colset*}
94 %type colsetlist {Fts5Colset*}
146 %type nearset {Fts5ExprNearset*}
147 %type nearphrases {Fts5ExprNearset*}
182 %type phrase {Fts5ExprPhrase*}
195 %type star_opt {int}
/sqlite-3.40.0/
H A Dsqlite_cfg.h.in12 /* Define to 1 if the system has the type `int16_t'. */
15 /* Define to 1 if the system has the type `int32_t'. */
18 /* Define to 1 if the system has the type `int64_t'. */
21 /* Define to 1 if the system has the type `int8_t'. */
24 /* Define to 1 if the system has the type `intptr_t'. */
81 /* Define to 1 if the system has the type `uint16_t'. */
84 /* Define to 1 if the system has the type `uint32_t'. */
87 /* Define to 1 if the system has the type `uint64_t'. */
90 /* Define to 1 if the system has the type `uint8_t'. */
93 /* Define to 1 if the system has the type `uintptr_t'. */
/sqlite-3.40.0/ext/wasm/fiddle/
H A Dfiddle.js265 addMsgHandler: function f(type,callback){
266 if(Array.isArray(type)){
270 (this._msgMap.hasOwnProperty(type)
271 ? this._msgMap[type]
272 : (this._msgMap[type] = [])).push(callback);
278 ? this._msgMap[msg.type] : false);
288 clearMsgHandlers: function(type){ argument
289 delete this._msgMap[type];
293 wMsg: function(type,data,transferables){ argument
347 if('status'!==ev.type){
[all …]
/sqlite-3.40.0/ext/wasm/
H A Dspeedtest1-worker.js38 postMessage({type: msgType, data: payload}); property
43 const logMsg = (type,msgArgs)=>{ argument
46 mPost(type,msg);
73 switch(msg.type){
76 logErr("Unhandled worker message type:",msg.type);
H A Ddemo-worker1.js57 push: function(type,callback){ argument
59 return type + '-' + (++this.id);
93 type: eventType, property
310 if('error'===ev.type){
318 switch(ev.type){
331 if(dbMsgHandler.hasOwnProperty(ev.type)){
332 try{dbMsgHandler[ev.type](ev);}
/sqlite-3.40.0/doc/
H A Djson-enhancements.md30 SQL type
40 INTEGER or REAL. This is due to limitations in the type handling capabilities
41 of those systems. In MySQL and PG, the result type a function or operator
42 may only depend on the type of its arguments, never the value of its arguments.
43 But the underlying JSON type depends on the value of the JSON path
44 expression, not the type of the JSON path expression (which is always TEXT).
45 Hence, the result type of ->> in MySQL and PG is unable to vary according
46 to the type of the JSON value being extracted.
48 The type system in SQLite is more general. Functions in SQLite are able
51 depending on the JSON type of the value being extracted. This means that
/sqlite-3.40.0/ext/wasm/common/
H A Dwhwasmutil.js644 target.getMemValue = function(ptr, type='i8'){ argument
645 if(type.endsWith('*')) type = ptrIR;
648 switch(type){
660 toss('Invalid type for getMemValue():',type);
677 target.setMemValue = function f(ptr, value, type='i8'){ argument
678 if (type.endsWith('*')) type = ptrIR;
681 switch (type) {
695 toss('Invalid type for setMemValue(): ' + type);

12345678