| /sqlite-3.40.0/test/ |
| H A D | randexpr1.test | 1187 …from t1 where f=(abs(coalesce((select t1.c from t1 where not (not exists(select 1 from t1 where a …
1190 …from t1 where f=(abs(coalesce((select t1.c from t1 where not (not exists(select 1 from t1 where a …
2213 …from t1 where coalesce((select coalesce((select max( -coalesce((select max(case when exists(select…
3515 …from t1 where -a in (select 11 from t1 union select -11 from t1)),e)) AS integer)) from t1) from…
4901 …from t1 where 19 between 13 and 13),(abs(case when c<=17 or f in (t1.a, -17,t1.f) then b else t1.c…
4904 …from t1 where 19 between 13 and 13),(abs(case when c<=17 or f in (t1.a, -17,t1.f) then b else t1.c…
4907 …from t1 where 19 between 13 and 13),(abs(case when c<=17 or f in (t1.a, -17,t1.f) then b else t1.c…
4979 …from t1 where 17>=19) or t1.c in (select min(19)-(cast(avg(f) AS integer)) from t1 union select ca…
4982 …from t1 where 17>=19) or t1.c in (select min(19)-(cast(avg(f) AS integer)) from t1 union select ca…
7349 …1.a from t1 where c in (select a from t1 union select t1.a*f from t1) and t1.b in (select (select …
[all …]
|
| H A D | trigger4.test | 35 select * from test1;
40 select * from test2;
48 select * from test1;
53 select * from test2;
65 select * from test1;
70 select * from test2;
78 select * from test1;
83 select * from test2;
107 select * from test1;
114 select * from test1;
[all …]
|
| H A D | null.test | 34 select * from t1;
42 select ifnull(a+b,99) from t1;
119 select a from t1 where b<10
164 select b from t1 union select c from t1 order by b;
169 select b from t1 union select c from t1 order by 1;
174 select b from t1 union select c from t1 order by t1.b;
179 select b from t1 union select c from t1 order by main.t1.b;
184 select b from t1 union select c from t1 order by t1.a;
189 select b from t1 union select c from t1 order by main.t1.a;
204 select a from t2;
[all …]
|
| H A D | lastinsert.test | 96 delete from t2;
110 select val1 from t2;
117 select val2 from t2;
124 select val3 from t2;
134 delete from t2;
149 select val1 from t2;
156 select val2 from t2;
163 select val3 from t2;
176 delete from t2;
219 delete from t2;
[all …]
|
| H A D | laststmtchanges.test | 121 select v1 from t2;
128 select v2 from t2;
150 delete from t2; delete from t2;
164 select v1 from t2;
171 select v2 from t2;
182 delete from t2; delete from t2;
188 delete from t1;
196 select v1 from t2;
203 select v2 from t2;
271 select n from n1;
[all …]
|
| H A D | bestindex7.test | 64 do_execsql_test 1.1 { select * from vt1 } {0 2}
65 do_execsql_test 1.2 { select * from vt1 WHERE a=0 } {0}
66 do_execsql_test 1.3 { select * from vt1 WHERE a=1 } {}
67 do_execsql_test 1.4 { select * from vt1 WHERE a=1 OR a=0} {0}
73 do_execsql_test 1.6 { select * from vt1 } {0 {}}
74 do_execsql_test 1.7 { select * from vt1 WHERE a=0 } {0}
75 do_execsql_test 1.8 { select * from vt1 WHERE a=1 } {}
76 do_execsql_test 1.9 { select * from vt1 WHERE a=1 OR a=0} {0}
77 do_execsql_test 1.10 { select * from vt1 WHERE a IN (2) } {}
78 do_execsql_test 1.10 { select * from vt1 WHERE a IN (0,1,2,3) } {0}
[all …]
|
| H A D | fts3ac.test | 26 # Create a table of sample email data. The data comes from email
32 CREATE VIRTUAL TABLE email USING fts3([from],[to],subject,body);
96 …from],[to],subject,body) VALUES('[email protected]', '[email protected]', 'Greater Hous…
237 E-Gas(Emergency Gas) will not be offered this winter as a service from AGLC.
239 chain) from other marketers up to the 6 p.m. Same Day 2 nomination cycle.
448 Privacy Program. To be removed from future offers,click here.
490 …from],[to],subject,body) VALUES('[email protected]', '[email protected]', 'Docume…
505 Subject: Documents for Mark Frevert (on EU developments and lessons from
774 INSERT INTO email([from],[to],subject,body) VALUES('[email protected]', '[email protected]', '', 'J…
786 1) "Adj L_R" is the same data/format from the weekly strategy meeting.
[all …]
|
| H A D | fts2c.test | 26 # Create a table of sample email data. The data comes from email
32 CREATE VIRTUAL TABLE email USING fts2([from],[to],subject,body);
96 …from],[to],subject,body) VALUES('[email protected]', '[email protected]', 'Greater Hous…
237 E-Gas(Emergency Gas) will not be offered this winter as a service from AGLC.
239 chain) from other marketers up to the 6 p.m. Same Day 2 nomination cycle.
448 Privacy Program. To be removed from future offers,click here.
490 …from],[to],subject,body) VALUES('[email protected]', '[email protected]', 'Docume…
505 Subject: Documents for Mark Frevert (on EU developments and lessons from
774 INSERT INTO email([from],[to],subject,body) VALUES('[email protected]', '[email protected]', '', 'J…
786 1) "Adj L_R" is the same data/format from the weekly strategy meeting.
[all …]
|
| H A D | fts1c.test | 26 # Create a table of sample email data. The data comes from email
32 CREATE VIRTUAL TABLE email USING fts1([from],[to],subject,body);
96 …from],[to],subject,body) VALUES('[email protected]', '[email protected]', 'Greater Hous…
237 E-Gas(Emergency Gas) will not be offered this winter as a service from AGLC.
239 chain) from other marketers up to the 6 p.m. Same Day 2 nomination cycle.
448 Privacy Program. To be removed from future offers,click here.
490 …from],[to],subject,body) VALUES('[email protected]', '[email protected]', 'Docume…
505 Subject: Documents for Mark Frevert (on EU developments and lessons from
774 INSERT INTO email([from],[to],subject,body) VALUES('[email protected]', '[email protected]', '', 'J…
786 1) "Adj L_R" is the same data/format from the weekly strategy meeting.
[all …]
|
| H A D | tkt2192.test | 42 select * from records where type = 'D/D';
46 from direct_debits
52 from direct_debits
58 from direct_debits
66 from direct_debits where description like '%VISA%'
72 select 'Energy' as expense, date, value from energy
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
87 select * from jan join nov on (jan.expense = nov.expense);
[all …]
|
| H A D | countofview.test | 28 select c from t2 union all select f from t3 limit 1 offset 1
32 select count(*) from (
33 select c from t2 union all select f from t3 limit 1 offset 1
38 select count(*) from (
39 select c from t2 union all select f from t3
|
| H A D | pragma.test | 359 SELECT rowid, * from t2;
375 } {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2}}
384 …ow 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2} {row 1 …
389 …} {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2} {r…
403 …ow 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2} {row 1 …
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}}
564 # called from saveCursorPosition() if content is removed from the
1562 select * from sqlite_master;
1581 select * from sqlite_master;
[all …]
|
| H A D | join4.test | 35 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
52 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
58 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
66 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
71 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
76 select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
81 select * from t1 left outer join t2 on t1.a=t2.x and t2.z>='ok'
87 select * from t1 left outer join t2 on t1.a=t2.x where t2.z IN ('ok')
92 select * from t1 left outer join t2 on t1.a=t2.x and t2.z IN ('ok')
|
| H A D | capi2.test | 20 # Return the text values from the current row pointed at by STMT as a list.
157 sqlite3_prepare $DB {select bogus from sqlite_master} -1 TAIL
163 sqlite3_prepare $DB {select bogus from } -1 TAIL
623 # counter (Test result changes from 0 to 4).
746 check_origins {select * from (select * from view1)}
749 check_origins {select * from (select * from (select * from view1))}
755 check_origins {select * from (select * from (select * from view1))}
783 check_origins {select * from (select * from view2)}
786 check_origins {select * from (select * from (select * from view2))}
792 check_origins {select * from (select * from (select * from view2))}
[all …]
|
| H A D | randexpr1.tcl | 61 {(select AGG from t1)}
65 {coalesce((select max(EXPR) from t1 where BOOL),EXPR)}
69 {coalesce((select EXPR from t1 where BOOL),EXPR)}
101 {EXPR in (select EXPR from t1 union select EXPR from t1)}
105 {EXPR in (select AGG from t1 union select AGG from t1)}
109 {exists(select 1 from t1 where BOOL)}
113 {not exists(select 1 from t1 where BOOL)}
|
| H A D | shell3.test | 19 # shell3-1.*: Basic tests for running SQL statments from command line.
20 # shell3-2.*: Basic tests for running SQL file from command line.
44 # shell3-1.*: Basic tests for running SQL statments from command line.
47 # Run SQL statement from command line
74 # shell3-2.*: Basic tests for running SQL file from command line.
77 # Run SQL file from command line
122 SELECT * from t1 limit 1;
123 SELECT * from t2 limit 1;
|
| H A D | vtab7.test | 12 # of this test is reading and writing to the database from within a
40 # code in this file arranges for a Tcl script to be executed from within
81 # Write to an existing database table from within an xSync callback.
105 # Create a database table from within xSync callback.
116 # Drop a database table from within xSync callback.
134 # Write to an attached database from xSync().
148 SELECT * from stuff;
155 # The following tests test that writing to the database from within
169 # virtual table from within an xSync() callback.
|
| H A D | select7.test | 31 select * from t1 where x like 'a__'
32 intersect select * from t1 where x like '_m_'
33 intersect select * from t1 where x like '__x';
85 SELECT P.pk from PHOTO P WHERE NOT EXISTS (
86 SELECT T2.pk from TAG T2 WHERE T2.fk = P.pk
88 SELECT T3.pk from TAG T3 WHERE T3.fk = P.pk AND T3.name LIKE '%foo%'
100 SELECT P.pk from PHOTO P WHERE NOT EXISTS (
101 SELECT T2.pk from TAG T2 WHERE T2.fk = P.pk
103 SELECT T3.pk from TAG T3 WHERE T3.fk = P.pk AND T3.name LIKE '%foo%'
|
| H A D | misc4.test | 153 from a, (select key,sum(period) from b group by key) as x
166 select * from ab, (select b from ab) as x where x.b = ab.a;
172 # Ticket #1036. When creating tables from a SELECT on a view, use the
182 create view myview as select t4.a a from t4 inner join t5 on t4.a=t5.a;
183 create table problem as select * from myview;
191 create table t6 as select * from t4, t5;
192 select * from t6;
|
| H A D | sort.test | 231 select a from t3 order by b, a;
236 select a from t3 order by b, a desc;
241 select a from t3 order by b desc, a;
246 select a from t3 order by b desc, a desc;
253 select a from t3 order by b, a;
258 select a from t3 order by b, a desc;
263 select a from t3 order by b desc, a;
268 select a from t3 order by b desc, a desc;
316 } {1 2 11 12 1 11 12 2} ;# text from t4.b and numeric from v4.a
321 } {1 2 11 12 1 11 12 2} ;# numeric from t4.a and text from v4.b
[all …]
|
| H A D | thread1.test | 106 # 4: Check db write failed from main thread.
107 # 5: Unlock from thread A.
109 # 7: Check db write failed from main thread.
110 # 8: Unlock from thread B.
112 # 10: Finalize the write from thread C
113 # 11: Check db write succeeded from main thread.
|
| H A D | ioerr5.test | 13 # memory from a pager that is in the error-state, SQLite does not
38 # call to sqlite3_malloc() when translating from the supplied UTF-16 to
98 # from there the pager immediately discards all cached data and
100 # from happening, leaving the pager stuck in PAGER_ERROR state.
125 # from UTF-16 text. To do this, SQLite will need to reclaim memory
126 # from the pager that is in error state. Including that associated
137 # memory from the pager in error state.
|
| H A D | subselect.test | 48 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
51 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
54 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
57 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)}
72 execsql {SELECT b from t1 where a = coalesce((SELECT a FROM t1 WHERE b=5),1)}
86 SELECT y from t2
91 # Try something useful. Delete every entry from t2 where the
|
| /sqlite-3.40.0/tool/ |
| H A D | replace.tcl | 10 set from [lindex $argv 1]
13 if {[string length $from]==0} {exit 2}
18 exact {set line [string map [list $from $to] $line]}
19 regsub {regsub -all -- $from $line $to line}
20 include {if {[regsub -all -- $from $line $to line]==0} continue}
|
| /sqlite-3.40.0/ext/wasm/ |
| H A D | README.md | 47 from the top of the sqlite3 build tree:
73 That will open the system's browser and run the index page, from which
77 from 2022-09-26 or newer so that it recognizes the `--enable-sab`
88 * Use a [version of althttpd][althttpd] from
98 in HTTP reply headers and that the request must come from "localhost".
99 Since the web-server is on a different machine from
|