Home
last modified time | relevance | path

Searched refs:row (Results 1 – 25 of 184) sorted by relevance

12345678

/sqlite-3.40.0/test/
H A Dspeed2.test90 speed_trial speed2-insert1 50000 row $sql
101 speed_trial speed2-insert2 50000 row $sql
154 speed_trial speed2-createidx 150000 row {
196 speed_trial speed2-select6a 50000 row $sql
237 speed_trial speed2-select6b 50000 row $sql
251 # 50000 single-row updates. An index is used to find the row quickly.
259 speed_trial speed2-update2 50000 row $sql
264 speed_trial speed2-update3 50000 row {
277 speed_trial speed2-update4 50000 row $sql
299 speed_trial speed2-drop1 50000 row {
[all …]
H A Dspeed1p.test97 speed_trial_tcl speed1p-insert1 50000 row $script
114 speed_trial_tcl speed1p-insert2 50000 row $script
156 speed_trial speed1p-createidx 150000 row {
222 speed_trial_tcl speed1p-select6 50000 row $script
227 speed_trial speed1p-vacuum 100000 row VACUUM
246 # 50000 single-row updates. An index is used to find the row quickly.
264 speed_trial speed1p-update3 50000 row {
304 speed_trial speed1p-drop1 50000 row {
317 speed_trial speed1p-random1 50000 row {
323 speed_trial speed1p-random-del1 20000 row {
[all …]
H A Dspeed1.test94 speed_trial speed1-insert1 50000 row $sql
105 speed_trial speed1-insert2 50000 row $sql
138 speed_trial speed1-createidx 150000 row {
166 speed_trial speed1-select4 100000 row $sql
187 speed_trial speed1-select6 50000 row $sql
206 # 50000 single-row updates. An index is used to find the row quickly.
214 speed_trial speed1-update2 50000 row $sql
219 speed_trial speed1-update3 50000 row {
232 speed_trial speed1-update4 50000 row $sql
254 speed_trial speed1-drop1 50000 row {
[all …]
H A Dspeed1p.explain99 speed_trial_tcl speed1p-insert1 50000 row $script
117 speed_trial_tcl speed1p-insert2 50000 row $script
163 speed_trial speed1p-createidx 150000 row {
233 speed_trial_tcl speed1p-select6 50000 row $script
238 speed_trial speed1p-vacuum 100000 row VACUUM
258 # 50000 single-row updates. An index is used to find the row quickly.
278 speed_trial speed1p-update3 50000 row {
324 speed_trial speed1p-drop1 50000 row {
338 speed_trial speed1p-random1 50000 row {
346 speed_trial speed1p-random-del1 20000 row {
[all …]
H A Dorderby7.test34 (11,'a row that occurs twice'),
35 (12,'a row that occurs twice');
53 } {11 {a row that occurs twice} 12 {a row that occurs twice}}
60 } {{a row that occurs twice}}
67 } {{a row that occurs twice} {a row that occurs twice}}
73 } {{a row that occurs twice}}
79 } {{a row that occurs twice} {a row that occurs twice}}
87 } {{a row that occurs twice}}
94 } {{a row that occurs twice} 111}
101 } {{a row that occurs twice} 111}
H A Dconflict3.test39 # Insert a row that conflicts on column B. The insert should be ignored.
46 # Insert two rows where the second conflicts on C. The first row show go
69 # Insert a row that conflicts on column B. The insert should be ignored.
76 # Insert two rows where the second conflicts on C. The first row show go
99 # Insert a row that conflicts on column B. The insert should be ignored.
106 # Insert two rows where the second conflicts on C. The first row show go
129 # Insert a row that conflicts on column B. The insert should be ignored.
136 # Insert two rows where the second conflicts on C. The first row show go
159 # Insert a row that conflicts on column B. The insert should be ignored.
166 # Insert two rows where the second conflicts on C. The first row show go
[all …]
H A Dpragma.test375 } {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2}}
378 } {{row 1 missing from index i2}}
384 …} {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2} {r…
389 …} {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2} {r…
395 …} {0 {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2}…
403 …} {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2} {r…
438 Page 6 is never used} {row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entri…
441 } {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2}}
458 Page 6 is never used} {row 1 missing from index i2} {row 2 missing from index i2}}
466 Page 6 is never used} {row 1 missing from index i2}}
[all …]
H A Dspeed3.test29 # is not the first overflow page for the row. The improvement
154 # Delete all content in a table, one row at a time.
158 speed_trial speed3-1.incrvacuum $::NROW row {DELETE FROM main.t1 WHERE 1}
159 speed_trial speed3-1.normal $::NROW row {DELETE FROM aux.t1 WHERE 1}
163 # chain) from each table row.
168 speed_trial speed3-2.incrvacuum $::NROW row {SELECT c FROM main.t1}
169 speed_trial speed3-2.normal $::NROW row {SELECT c FROM aux.t1}
H A Drowvalue4.test12 # focus of this file is syntax errors involving row-value constructors
23 # * row values used where they are not supported,
24 # * row values or sub-selects that contain/return the wrong number
37 do_catchsql_test 1.$tn "SELECT $e" {1 {row value misused}}
41 1 "SELECT * FROM t1 WHERE a = (1, 2)" {row value misused}
42 2 "SELECT * FROM t1 WHERE b = (1, 2)" {row value misused}
43 3 "SELECT * FROM t1 WHERE NOT (b = (1, 2))" {row value misused}
44 4 "SELECT * FROM t1 LIMIT (1, 2)" {row value misused}
50 7 "SELECT * FROM t1 WHERE (c, c) <= 1" {row value misused}
51 8 "SELECT * FROM t1 WHERE (b, b) <= 1" {row value misused}
[all …]
H A Drowvalue.test153 } {1 {row value misused}}
156 } {1 {row value misused}}
235 } {1 {row value misused}}
238 } {1 {row value misused}}
241 } {1 {row value misused}}
244 } {1 {row value misused}}
247 } {1 {row value misused}}
250 } {1 {row value misused}}
253 } {1 {row value misused}}
256 } {1 {row value misused}}
[all …]
H A Dtkt1435.test59 row INTEGER PRIMARY KEY,
78 select row, pinned from tlList, Instances, Versions, Flavors
86 order by row asc;
99 select row, pinned from tlList, Instances, Versions, Flavors
107 order by row asc;
H A Dfts2n.test41 INSERT INTO t1(rowid, c) VALUES(2, 'Another lovely row');
104 execsql "SELECT rowid FROM t1 WHERE t1 MATCH '\"a* l* row\"'"
119 INSERT INTO t2(rowid, c) VALUES(2, 'Another lovely row');
161 # hit counts for each row. offsets() returns 4 elements for every
162 # hit. We'll have 6 hits for row 1, 1 for row 2, and 6*(2^5)==192 for
170 INSERT INTO t3(rowid, c) VALUES(2, 'Another lovely row');
H A Dfts3an.test41 INSERT INTO t1(rowid, c) VALUES(2, 'Another lovely row');
104 execsql "SELECT rowid FROM t1 WHERE t1 MATCH '\"a* l* row\"'"
119 INSERT INTO t2(rowid, c) VALUES(2, 'Another lovely row');
161 # hit counts for each row. offsets() returns 4 elements for every
162 # hit. We'll have 6 hits for row 1, 1 for row 2, and 6*(2^5)==192 for
170 INSERT INTO t3(rowid, c) VALUES(2, 'Another lovely row');
H A Dwalthread.test227 # 1) Reading the md5sum of all but the last table row,
229 # 3) Reading the value stored in the last table row,
231 # the md5sum of all but the last table row has not changed.
236 # 2) Appending a new row to the table containing the md5sum() of all
319 # 4. Execute a write transaction to insert a row into the db.
466 set row 1
468 db eval { REPLACE INTO t1 VALUES($row, randomblob(300)) }
469 incr row
470 if {$row == 10} { set row 1 }
/sqlite-3.40.0/ext/wasm/
H A Ddemo-123.js110 callback: function(row){ argument
111 log("row ",++this.counter,"=",row);
119 callback: function(row){ argument
120 log("row ",++this.counter,"=",JSON.stringify(row));
128 callback: function(row){ argument
129 log("row ",++this.counter,"get(0) =",row.get(0));
137 callback: function(row){ argument
138 log("row ",++this.counter,"b =",row);
173 callback: function(row){ argument
174 log("a =",row.get(0), "twice(a) =", row.get(1),
[all …]
H A Ddemo-worker1-promiser.js160 T.assert(undefined === ev.row)
169 T.assert(null === ev.rowNumber || 'number' === typeof ev.row.B);
183 T.assert(undefined === ev.row)
191 T.assert(null === ev.rowNumber || 'number' === typeof ev.row);
209 T.assert('number' === typeof ev.row);
H A Dbatch-runner.js46 const row = rows.item(i);
47 const name = JSON.stringify(row.name);
48 const type = row.type;
386 const row = [k.split('/').pop()/*remove dir prefix from filename*/];
387 rc.push(row);
388 row.push(...mk.map((kk)=>m[kk]));
399 ma.forEach(function(row){ argument
400 ar.push(row.join(colSeparator),'\n');
H A Dtester1.js1269 callback: function(row,stmt){ argument
1271 T.assert((row.a%2 && row.a<6) || 'blob'===row.a);
1281 callback: function(row,stmt){ argument
1283 T.assert(Array.isArray(row))
1284 .assert((0===row[1]%2 && row[1]<7)
1541 for(const row of rc){
1543 case 1: T.assert('a'===row[0] && 9===row[1]); break;
1544 case 2: T.assert('b'===row[0] && 12===row[1]); break;
1545 case 3: T.assert('c'===row[0] && 16===row[1]); break;
1546 case 4: T.assert('d'===row[0] && 12===row[1]); break;
[all …]
/sqlite-3.40.0/ext/fts3/
H A DREADME.content40 It is not possible to UPDATE or DELETE a row stored in a contentless FTS4
91 the row in the content table with a rowid value equal to the current FTS
92 docid. Or, if such a row cannot be found in the content table, a NULL
106 -- term matches the row with docid=3. It then retrieves the values
107 -- of columns b and c from the row with rowid=3 in the content table
112 -- Following the UPDATE, the query still returns a single row, this
114 -- full-text index still indicates that the row with docid=3 matches
123 -- a row with rowid=3 within the content table.
128 When a row is deleted from an external content FTS4 table, FTS4 needs to
131 that occurs within the deleted row to indicate that that row has been
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5vocab.test64 CREATE VIRTUAL TABLE v1 USING fts5vocab(t1, 'row');
151 2 "fts5vocab(tt, 'row')" res_row
152 3 "fts5vocab(tt, \"row\")" res_row
153 4 "fts5vocab(tt, [row])" res_row
154 5 "fts5vocab(tt, `row`)" res_row
156 6 "fts5vocab('tt', 'row')" res_row
157 7 "fts5vocab(\"tt\", \"row\")" res_row
158 8 "fts5vocab([tt], [row])" res_row
159 9 "fts5vocab(`tt`, `row`)" res_row
276 CREATE VIRTUAL TABLE txr USING fts5vocab(tx, row);
[all …]
/sqlite-3.40.0/tool/
H A Dgenfkey.README15 An SQL foreign key is a constraint that requires that each row in
16 the "child" table corresponds to a row in the "parent" table. For
22 implies that for each row in table "child", there must be a row in
32 row in the parent table. So, taking this into account, the expression that
33 must be true for every row of the child table in the above example is
40 Attempting to insert or update a row in the child table so that the
41 affected row violates this constraint results in an exception being
44 The effect of attempting to delete or update a row in the parent table
52 RESTRICT: Attempting to update or delete a row in the parent table so
57 rows are either deleted (if the parent row is being deleted)
[all …]
/sqlite-3.40.0/ext/rtree/
H A Dviewrtree.tcl89 grid configure .select -row 0 -column 0 -columnspan 2 -sticky nsew
90 grid configure .b -row 1 -column 0 -columnspan 2 -sticky nsew
91 grid configure .l -row 2 -column 0 -sticky nsew
92 grid configure .status -row 3 -column 0 -columnspan 3 -sticky nsew
94 grid configure .title -row 0 -column 2 -sticky nsew
95 grid configure .c -row 1 -column 2 -rowspan 2 -sticky nsew
96 grid configure .ls -row 2 -column 1 -sticky nsew
H A Drtreedoc3.test83 # Invoked each time a row is returned. Checks that the row returned
168 # If it had been a leaf, the row should have been returned, instead of
227 # as one row of the query result.
229 if {$N(iLevel)!=0} { error "result row mismatch (1)" }
234 if {$N(iLevel)!=0} { error "result row mismatch (2)" }
237 if {$id!=$N(iRowid)} { error "result row mismatch (3)" }
/sqlite-3.40.0/ext/repair/test/
H A Dcheckindex01.test93 {row missing} 'five',5
96 {row data mismatch} 'three',3
102 {row data mismatch} 'three',3
105 {row missing} 'five',5
232 {row data mismatch} 'AAA','CCC',2
233 {row missing} 'aab','ddd',3
280 {row missing} NULL,4
281 {row data mismatch} 1,1
288 {row missing} {'{"w":4, "z":4}',4}
289 {row data mismatch} {'{"x":1, "y":1}',1}
/sqlite-3.40.0/src/
H A Din-operator.md37 The RHS is a partial-NULL if any row contains a NULL value. The RHS is
40 called "non-NULL" if it contains no NULL values in any row.
62 2. For each row in the RHS:
101 6. For each row in the RHS, compare that row against the LHS and
104 row the RHS because for a scalar RHS, all NULLs will always come

12345678