Home
last modified time | relevance | path

Searched refs:values (Results 1 – 25 of 226) sorted by relevance

12345678910

/sqlite-3.40.0/test/
H A Dlaststmtchanges.test35 insert into t0 values (1);
36 insert into t0 values (1);
37 insert into t0 values (2);
38 insert into t0 values (2);
39 insert into t0 values (1);
40 insert into t0 values (1);
41 insert into t0 values (1);
42 insert into t0 values (2);
113 insert into t1 values (77);
223 insert into t0 values (1);
[all …]
H A Dtkt3419.test29 insert into a values (1);
30 insert into a values (2);
32 insert into b values (3, 1);
33 insert into b values (4, 1);
34 insert into b values (5, 1);
35 insert into b values (6, 1);
36 insert into b values (9, 2);
38 insert into c values (4, 3);
39 insert into c values (5, 5);
40 insert into c values (6, 4);
[all …]
H A Dnull.test26 insert into t1 values(1,0,0);
27 insert into t1 values(2,0,1);
28 insert into t1 values(3,1,0);
29 insert into t1 values(4,1,1);
30 insert into t1 values(5,null,0);
31 insert into t1 values(6,null,1);
32 insert into t1 values(7,null,null);
200 insert into t2 values(1,1);
203 insert into t2 values(4,1);
210 insert into t3 values(1,1,1);
[all …]
H A Djoin4.test25 insert into t1 values(1,'one');
26 insert into t1 values(2,'two');
27 insert into t1 values(3,'three');
28 insert into t1 values(4,'four');
31 insert into t2 values(2,'niban','ok');
32 insert into t2 values(4,'yonban','err');
42 insert into t1 values(1,'one');
43 insert into t1 values(2,'two');
44 insert into t1 values(3,'three');
45 insert into t1 values(4,'four');
[all …]
H A Dlastinsert.test32 insert into t1 values (1);
33 insert into t1 values (NULL);
34 insert into t1 values (NULL);
45 insert into t1w values (123456);
102 insert into t1 values (13);
183 insert into v values (15);
306 insert into rid values (1, NULL, NULL);
307 insert into rid values (2, NULL, NULL);
310 insert into t1 values (100+NEW.k);
319 insert into t1 values (77);
[all …]
H A Dtkt2339.test26 insert into t1 values (1);
27 insert into t1 values (2);
28 insert into t1 values (3);
29 insert into t1 values (4);
32 insert into t2 values (11);
33 insert into t2 values (12);
34 insert into t2 values (13);
35 insert into t2 values (14);
H A Dtrigger4.test31 insert into test1 (id,a) values (NEW.id,NEW.a);
32 insert into test2 (id,b) values (NEW.id,NEW.b);
34 insert into test values(1,2,3);
47 insert into test values(4,5,6);
90 insert into test values(7,8,9);
97 insert into test values(7,8,9);
113 insert into test values(7,8,9);
147 insert into tbl values (new.a,new.b);
149 insert into tbl values(101,1001);
150 insert into tbl values(102,1002);
[all …]
H A Dtypes.test22 # types-1.*.*: Test that values are stored using the expected storage
29 # types-2.*.*: Check that values can be stored and retrieving using the
58 set values {
71 lappend values { X'00' blob blob blob blob }
74 # This code tests that the storage classes specified above (in the $values
75 # table) are correctly assigned when values are inserted using a statement
78 # INSERT INTO <table> VALUE(<values>);
81 foreach val $values {
93 # This code tests that the storage classes specified above (in the $values
100 foreach val $values {
[all …]
H A Dmisc4.test144 insert into a values('01','data01');
145 insert into a values('+1','data+1');
147 insert into b values ('01',1);
148 insert into b values ('01',2);
149 insert into b values ('+1',3);
150 insert into b values ('+1',4);
180 insert into t4 values (1,2);
181 insert into t5 values (1,3);
H A Dsort.test225 insert into t3 values(5,NULL);
226 insert into t3 values(6,NULL);
227 insert into t3 values(3,NULL);
228 insert into t3 values(4,'cd');
229 insert into t3 values(1,'ab');
230 insert into t3 values(2,NULL);
447 insert into t8 values(1,2,3);
448 insert into t8 values(2,3,4);
450 insert into t9 values(2,4);
451 insert into t9 values(2,3);
[all …]
H A Dsavepoint6.test43 # start of the savepoint. The keys of the array are the x values. The
44 # values are the y values.
47 # x values, the array data values are y values.
154 # Proc to return random set of x values.
H A Dmain.test450 insert into T1 values(0.5);
451 insert into T1 values(0.5e2);
452 insert into T1 values(0.5e-002);
453 insert into T1 values(5e-002);
454 insert into T1 values(-5.0e-2);
455 insert into T1 values(-5.1e-2);
456 insert into T1 values(0.5e2);
457 insert into T1 values(0.5E+02);
458 insert into T1 values(5E+02);
459 insert into T1 values(5.0E+03);
H A Dtkt2942.test38 insert into t1 values (2);
39 insert into t1 values (1);
40 insert into t1 values (3);
41 insert into t1 values (4);
H A Dtkt3357.test24 insert into a(b_id, myvalue) values(1,'Test');
25 insert into a(b_id, myvalue) values(1,'Test2');
26 insert into a(b_id, myvalue) values(1,'Test3');
27 insert into b(bvalue) values('btest');
H A Dmalloctraceviewer.tcl112 set left [lindex [$O(tree) item $iLeft -values] 0]
113 set right [lindex [$O(tree) item $iRight -values] 0]
117 set left [lindex [$O(tree) item $iLeft -values] 1]
118 set right [lindex [$O(tree) item $iRight -values] 1]
171 $::O(tree) insert $parent_id end -id $stack -text $line -values $v
H A DselectC.test221 insert into t_distinct_bug values ('1', '1', 'a');
222 insert into t_distinct_bug values ('1', '2', 'b');
223 insert into t_distinct_bug values ('1', '3', 'c');
224 insert into t_distinct_bug values ('1', '1', 'd');
225 insert into t_distinct_bug values ('1', '2', 'e');
226 insert into t_distinct_bug values ('1', '3', 'f');
H A Dwithout_rowid4.test425 INSERT INTO tblB values(new.a, new.b);
429 INSERT INTO tblC values(new.a, new.b);
434 INSERT INTO tblA values(1, 2);
491 INSERT OR IGNORE INTO tbl values (new.a, 0, 0);
497 INSERT INTO tbl values (1, 2, 3);
503 INSERT OR ABORT INTO tbl values (2, 2, 3);
513 INSERT OR FAIL INTO tbl values (2, 2, 3);
523 INSERT OR REPLACE INTO tbl values (2, 2, 3);
529 INSERT OR ROLLBACK INTO tbl values (3, 2, 3);
542 INSERT INTO tbl values (4, 2, 3);
[all …]
H A Dtrigger2.test421 INSERT INTO tblB values(new.a, new.b);
425 INSERT INTO tblC values(new.a, new.b);
430 INSERT INTO tblA values(1, 2);
487 INSERT OR IGNORE INTO tbl values (new.a, 0, 0);
493 INSERT INTO tbl values (1, 2, 3);
499 INSERT OR ABORT INTO tbl values (2, 2, 3);
509 INSERT OR FAIL INTO tbl values (2, 2, 3);
519 INSERT OR REPLACE INTO tbl values (2, 2, 3);
525 INSERT OR ROLLBACK INTO tbl values (3, 2, 3);
538 INSERT INTO tbl values (4, 2, 3);
[all …]
H A Ddate3.test66 # EVIDENCE-OF: R-07289-49223 For numeric values outside of the range of
71 # EVIDENCE-OF: R-20795-34947 Other numeric values are out of range and
93 # time-values.
98 # with date/time values even in cases where it is not known if the
H A Drowvalue7.test52 } {1 {2 columns assigned 3 values}}
56 } {1 {3 columns assigned 2 values}}
66 } {1 {4 columns assigned 2 values}}
H A Dalter2.test34 # the M fields that are present are the values for the left-most M
337 # Test that types and values for columns added with default values
377 # Test that UPDATE trigger tables work with default values, and that when
378 # a row is updated the default values are correctly transfered to the
408 # Test that DELETE trigger tables work with default values, and that when
409 # a row is updated the default values are correctly transfered to the
/sqlite-3.40.0/src/
H A Din-operator.md18 two or or more values) or a subquery that returns one or more columns.
19 We use the term "vector" to mean an actually list of values or a
28 the RHS. If the RHS is a list of values, then the LHS must be a
32 NULL values can occur in either or both of the LHS and RHS.
34 NULL values then we say that it is a "total-NULL". If the LHS contains
35 some NULL values and some non-NULL values, then it is a "partial-NULL".
38 a total-NULL if it contains one or more rows that contain only NULL values.
39 The LHS is called "non-NULL" if it contains no NULL values. The RHS is
40 called "non-NULL" if it contains no NULL values in any row.
44 to the presence of NULL values. In some contexts (for example, when the IN
[all …]
/sqlite-3.40.0/ext/rtree/
H A Drtree2.test55 set values [list]
57 lappend values [expr int(rand()*1000)]
59 set values [join $values ,]
61 #puts "INSERT INTO t2 VALUES($ii, $values)"
62 set rc [catch {db eval "INSERT INTO t1 VALUES($ii, $values)"}]
66 db eval "INSERT INTO t2 VALUES($ii, $values)"
/sqlite-3.40.0/ext/fts3/
H A DREADME.content60 Errors related to attempting to retrieve column values other than docid
63 may be no error at all even if a statement does refer to column values
79 FTS4 to retrieve column values when required. If the nominated table does
103 -- the text values "i j" and "k l".
106 -- term matches the row with docid=3. It then retrieves the values
113 -- time containing the text values "xxx" and "yyy". This is because the
122 -- NULL values. NULL values are returned because FTS is unable to find
129 retrieve the column values of the row being deleted from the content table.
132 deleted. If the content table row cannot be found, or if it contains values
160 values in order to update the full-text index. And the INSERT trigger must
/sqlite-3.40.0/ext/rbu/
H A Drbu12.test183 # Also save the current values of "PRAGMA data-version" for [db1]
192 # Check the values of data-version have not magically changed.
199 # data-version values remain unchanged until the database contents are
200 # modified. At which point the values are incremented.
223 # this does not cause the data-version values to change.

12345678910