Home
last modified time | relevance | path

Searched refs:value (Results 1 – 25 of 307) sorted by relevance

12345678910>>...13

/sqlite-3.40.0/test/
H A De_reindex.test156 test_index 1.2 t1 collB value
158 test_index 1.4 t2 collB value
160 test_index 1.6 aux.t1 collB value
167 set_collations value length
169 test_index 2.2 t1 collA value
180 set_collations length value
200 set_collations value length
226 set_collations length value
274 set_collations value length
286 set_collations length value
[all …]
H A Dmerge1.test30 SELECT value FROM generate_series(1,35,3)
32 SELECT value FROM generate_series(10,30,4)
34 SELECT value FROM generate_series(20,50,5)
36 SELECT value FROM generate_series(30,60,6)
38 SELECT value FROM generate_series(1,50,7)
40 SELECT value FROM generate_series(10,80,8)
46 SELECT value FROM generate_series(1,35,3)
48 SELECT value FROM generate_series(10,30,4)
50 SELECT value FROM generate_series(20,50,5)
52 SELECT value FROM generate_series(30,60,6)
[all …]
H A Dstrict2.test51 } {{non-INT value in t1.a}}
55 } {{non-INT value in t1.a}}
59 } {{non-INT value in t1.a}}
63 } {{non-INT value in t1nn.a}}
67 } {{non-INT value in t1nn.a}}
71 } {{non-INT value in t1nn.a}}
97 } {{NULL value in t1nn.b}}
103 } {{non-TEXT value in t1.c}}
107 } {{non-TEXT value in t1.c}}
111 } {{non-TEXT value in t1.c}}
[all …]
H A Dtabfunc01.test41 SELECT *, '|' FROM generate_series(value) LIMIT 5;
121 SELECT value FROM generate_series(1,10) ORDER BY value;
127 SELECT value FROM generate_series(1,10) ORDER BY +value;
134 SELECT value FROM generate_series(1,10) ORDER BY value, stop;
140 SELECT value FROM generate_series(1,10) ORDER BY stop, value;
150 SELECT value FROM generate_series(0,10,2)
152 SELECT value FROM generate_series(9,18,3)
238 SELECT value FROM carray(inttoptr($PTR2),5,'int64');
260 WHERE a=trim(value,'x');
266 SELECT aa.value, bb.value, '|'
[all …]
H A DvtabJ.test37 INSERT INTO tclvar(fullname, value)
51 INSERT INTO tclvar(fullname, value) VALUES('vtabJ(4)',444);
58 INSERT INTO tclvar(fullname, value) VALUES('vtabJ(4)',NULL);
65 UPDATE tclvar SET value=55 WHERE fullname='vtabJ(five)';
106 INSERT INTO tclvar(fullname, value) VALUES('xx', 'a');
107 SELECT name, value FROM tclvar where name = 'xx';
110 UPDATE tclvar SET value = value || 't'
112 SELECT name, value FROM tclvar where name = 'xx';
115 UPDATE tclvar SET value = value || 't'
117 SELECT name, value FROM tclvar where name = 'xx';
[all …]
H A Dtkt2192.test35 value integer,
45 select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
51 select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
57 select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
65 select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
72 select 'Energy' as expense, date, value from energy
74 select 'Phone/Internet' as expense, date, value from phone_internet
76 select 'Credit Card' as expense, date, value from credit_cards;
79 select 'jan', expense, value from expense_overview
83 select 'nov', expense, value from expense_overview
H A Dcorrupt6.test23 # value is nonzero.
81 # Adjust value of record 1 / field 1 SerialTypeLen and see if the
93 # Adjust value of record 1 / field 1 SerialTypeLen and see if the
105 # Put value of record 1 / field 1 SerialTypeLen back.
116 # Adjust value of record 2 / field 1 SerialTypeLen and see if the
128 # Adjust value of record 2 / field 2 SerialTypeLen and see if the
140 # Put value of record 1 / field 2 SerialTypeLen back.
151 # Adjust value of record 1 / field 1 SerialTypeLen and see if the
163 # Adjust value of record 1 / field 1 SerialTypeLen and see if the
175 # Adjust value of record 1 / field 1 SerialTypeLen and see if the
[all …]
H A Dstrict1.test57 } {1 {cannot store TEXT value in INT column t1.a}}
60 } {1 {cannot store TEXT value in INTEGER column t1.b}}
63 } {1 {cannot store TEXT value in BLOB column t1.c}}
66 } {1 {cannot store BLOB value in TEXT column t1.d}}
69 } {1 {cannot store TEXT value in REAL column t1.e}}
78 } {1 {cannot store REAL value in INT column t1.a}}
81 } {1 {cannot store BLOB value in INT column t1.a}}
96 } {1 {cannot store TEXT value in BLOB column t1.c}}
105 } {1 {cannot store BLOB value in TEXT column t1.d}}
114 } {1 {cannot store TEXT value in REAL column t1.e}}
[all …]
H A Ddate3.test33 # EVIDENCE-OF: R-45708-63005 unixepoch(time-value, modifier, modifier,
52 # even if the input time-value has millisecond precision.
56 # EVIDENCE-OF: R-05412-24332 If the time-value is numeric (the
57 # DDDDDDDDDD format) then the 'auto' modifier causes the time-value to
61 # EVIDENCE-OF: R-56763-40111 If the value is between 0.0 and
68 # 253402300799, the 'auto' modifier causes the value to be interpreted
111 # it immediately follows a time value in the DDDDDDDDDD format.
121 # follow the initial time-value which must be of the form DDDDDDDDD.
127 # time-value number to be interpreted as a julian-day number.
130 # 'julianday' forces the DDDDDDDDD time-value format, and causes a NULL
[all …]
H A Dfuzz3.test41 0 { # SQL NULL value.
44 1 { # Integer value.
47 2 { # Real value.
50 3 { # String value.
54 4 { # Blob value.
68 # argument value, which must be an integer, determines both the offset of
69 # the byte that is modified, and the value that it is set to. The lower
70 # 8 bits of iMod determine the new byte value. The offset of the byte
71 # modified is the value of ($iMod >> 8).
73 # The return value is the iMod value required to restore the file
H A DvtabE.test42 SELECT t1.name, t1.arrayname, t1.value,
43 t2.name, t2.arrayname, t2.value,
44 abs(t3.b + abs(t2.value + abs(t1.value)))
46 LEFT JOIN t3 ON t3.a=t2.value
48 ORDER BY t1.value, t2.value;
H A De_walauto.test28 # value is nonzero.
45 proc do_autocommit_threshold_test {tn value} {
50 if {[read_mxframe] >= $value} break
66 proc autocheckpoint {db value} {
67 uplevel [list $db eval "PRAGMA wal_autocheckpoint = $value"]
72 proc autocheckpoint {db value} {
73 uplevel [list sqlite3_wal_autocheckpoint $db $value]
74 return $value
112 # EVIDENCE-OF: R-26993-43540 Passing zero or a negative value as the
127 autocheckpoint db -4 ;# Set to a negative value
H A Dindex6.test33 SELECT CASE WHEN value%3!=0 THEN value END, value, value
34 FROM nums WHERE value<=20;
150 INSERT INTO t2(a,b) SELECT value, value FROM nums WHERE value<1000;
218 INSERT INTO t3 SELECT value, value FROM nums WHERE value<200;
306 CREATE INDEX i8c ON t8b(y) WHERE x = 'value';
312 INSERT INTO t8b VALUES('value', 1);
314 INSERT INTO t8b VALUES('value', 3);
319 SELECT * FROM t8a LEFT JOIN t8b ON (x = 'value' AND y = a)
327 SELECT * FROM t8a LEFT JOIN t8b ON (x = 'value' AND y = a)
329 1 one value 1
[all …]
H A DwhereB.test21 # * t1.y holds an integer value with affinity NONE
22 # * t2.b holds a text value with affinity TEXT
73 # * t1.y holds a text value with affinity TEXT
74 # * t2.b holds an integer value with affinity NONE
128 # * t1.y holds a text value with affinity NONE
184 # * t1.y holds a text value with affinity NONE
245 # * t1.y holds a text value with affinity NONE
305 # * t1.y holds a text value with affinity NONE
366 # * t2.b holds a text value with affinity NONE
425 # * t2.b holds a text value with affinity NONE
[all …]
H A Dtkt2251.test17 # value of a table column. But then we added the ALTER TABLE ADD COLUMN
19 # and so the OP_Column opcode has to contain a default value. Later
20 # still we added a feature whereby a REAL value with no fractional
22 # After extracting the value, we have to call OP_RealAffinity to
41 # Create sample data. Verify that the default value and type of an added
69 # Make sure that the REAL value comes out when values are accessed
90 # Make sure the correct REAL value is used when copying from one
H A Dindex7.test58 SELECT CASE WHEN value%3!=0 THEN value END, value, value
59 FROM nums WHERE value<=20;
194 INSERT INTO t2(a,b) SELECT value, value FROM nums WHERE value<1000;
261 INSERT INTO t3 SELECT value, value FROM nums WHERE value<200;
266 # unable to insert a duplicate row a-value that is not 999.
H A Dbestindex6.test85 CREATE TABLE t1(id int, value text);
86 CREATE TABLE t2(ctx int, id int, value text);
97 select * from t2 left join t1 on t1.id=t2.ctx where t1.value is null;
101 select * from vt2 left join vt1 on vt1.id=vt2.ctx where vt1.value is null;
106 select * from vt2 left join vt1 on vt1.id=vt2.ctx where vt1.value is $xxx;
110 select * from t2 left join vt1 on vt1.id=t2.ctx where vt1.value = 3
H A Dchanges2.test19 id INTEGER NOT NULL, value VARCHAR(40) NOT NULL, PRIMARY KEY (id)
21 INSERT INTO some_table (id, value) VALUES (1, 'v1');
25 UPDATE some_table SET value='v2' WHERE id=1 RETURNING id
41 id INTEGER NOT NULL, value VARCHAR(40) NOT NULL, PRIMARY KEY (id)
43 INSERT INTO some_table (id, value) VALUES (1, 'v1');
H A De_changes.test17 # Like [do_execsql_test], except it appends the value returned by
75 # the return value of sqlite3_changes().
87 # constraints set the sqlite3_changes() value to 0. Regardless of
112 # does not modify the value returned by this function.
233 # EVIDENCE-OF: R-09813-48563 The value returned by sqlite3_changes()
270 # program has finished, the original value is restored.
329 # UPDATE and DELETE statement sets the value returned by
330 # sqlite3_changes() upon completion as normal. Of course, this value
332 # sqlite3_changes() value will be saved and restored after each
394 # statement within a trigger, it returns the value as set when the
[all …]
H A Dorderby5.test144 CREATE TABLE Records(typeID INTEGER, key TEXT COLLATE nocase, value TEXT);
145 CREATE INDEX RecordsIndex ON Records(typeID, key, value);
149 SELECT typeID, key, value FROM Records
151 ORDER BY key, value;
155 SELECT typeID, key, value FROM Records
157 ORDER BY key, value;
161 SELECT typeID, key, value FROM Records
163 ORDER BY key, value;
/sqlite-3.40.0/ext/wasm/fiddle/
H A Dfiddle.js249 f._.value = '';
253 f._.value = '';
257 f._.value += text + "\n";
360 progress.value = msg.step;
407 taInput.value = '';
420 taOutput.value = '';
430 sql = taInput.value.trim();
768 o.value = val;
778 taInput.value = '-- ' +
780 '\n' + this.value;
[all …]
/sqlite-3.40.0/ext/wasm/
H A Dbatch-runner.js330 opt.value = '';
338 opt.value = fn;
439 ? this.dbs[this.e.selImpl.value]
458 d.id = opt.value;
480 const dbId = this.e.selImpl.value;
544 if(!who.e.selSql.value) return;
545 who.evalFile(who.e.selSql.value);
549 if(!who.e.selSql.value) return;
550 who.evalFile(who.e.selSql.value);
565 let v = who.e.selSql.value;
[all …]
/sqlite-3.40.0/doc/
H A Djson-enhancements.md29 value is selected, that value is converted into its corresponding
33 array is selected, or a primitive SQL datatype when a JSON value
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
46 to the type of the JSON value being extracted.
49 to return different datatypes depending on the value of their arguments.
51 depending on the JSON type of the value being extracted. This means that
57 actual JSON value this would cause problems, so I'm including the enhanced
94 when the JSON value is numeric, SQLite returns a numeric SQL value,
96 value.
/sqlite-3.40.0/src/
H A Dtest_windirent.c26 static char value[32768]; /* Maximum length, per MSDN */ in windirent_getenv() local
27 DWORD dwSize = sizeof(value) / sizeof(char); /* Size in chars */ in windirent_getenv()
30 memset(value, 0, sizeof(value)); in windirent_getenv()
31 dwRet = GetEnvironmentVariableA(name, value, dwSize); in windirent_getenv()
43 return value; in windirent_getenv()
/sqlite-3.40.0/ext/rtree/
H A DREADME29 value. For each pair of real values, the first (leftmost) must be
61 * Inserting a NULL value into the primary key column has the
64 an unused integer key value to the new record. Usually, this
65 is one greater than the largest primary key value currently
68 * Attempting to insert a duplicate primary key value fails with
71 * Attempting to insert or modify a record such that the value
86 R-trees support fast lookup by primary key value (O(logN), like

12345678910>>...13