Home
last modified time | relevance | path

Searched refs:log (Results 1 – 25 of 115) sorted by relevance

12345

/sqlite-3.40.0/test/
H A Dselect3.test44 SELECT min(n),min(log),max(n),max(log),sum(n),sum(log),avg(n),avg(log)
55 execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
58 execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
61 execsql {SELECT log, avg(n) FROM t1 GROUP BY log ORDER BY log}
64 execsql {SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log}
67 execsql {SELECT log, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
137 execsql {SELECT log, count(*) FROM t1 GROUP BY log HAVING log>=4 ORDER BY log}
192 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
197 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
213 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
[all …]
H A Dselect4.test39 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
113 SELECT DISTINCT log FROM t1 ORDER BY log
147 SELECT DISTINCT log FROM t1 ORDER BY log
208 SELECT DISTINCT log FROM t1 ORDER BY log
272 SELECT DISTINCT log FROM t1 ORDER BY log
424 SELECT log, count(*) as cnt FROM t1 GROUP BY log
432 SELECT log, count(*) FROM t1 GROUP BY log
507 } {n 1 log 0 n 2 log 1 n 3 log 2 n 4 log 2 n 5 log 3}
513 } {n 6 log 3 n 7 log 3}
519 } {n 1 log 0 n 2 log 1}
[all …]
H A DtriggerD.test63 SELECT * FROM log
68 DELETE FROM log;
70 SELECT * FROM log
75 DELETE FROM log;
77 SELECT * FROM log
112 DELETE FROM log;
114 SELECT * FROM log;
119 DELETE FROM log;
121 SELECT * FROM log
126 DELETE FROM log;
[all …]
H A Dschema4.test55 SELECT x, a, b FROM log;
59 DELETE FROM log;
69 SELECT x, a, b FROM log;
76 DELETE FROM log;
80 SELECT x, a, b FROM log;
96 DELETE FROM log;
129 SELECT * FROM log;
136 DELETE FROM log;
139 SELECT * FROM log;
162 DELETE FROM log;
[all …]
H A Dinsert2.test36 CREATE TABLE t1(log int, cnt int);
41 EXPLAIN INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
45 INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
61 SELECT log, count(*) FROM d1 GROUP BY log
67 SELECT * FROM t1 ORDER BY log;
76 SELECT log, count(*) FROM d1 GROUP BY log
82 SELECT * FROM t1 ORDER BY log;
92 CREATE INDEX i1 ON t1(log);
94 INSERT INTO t1 SELECT log, count() FROM d1 GROUP BY log;
95 SELECT * FROM t1 ORDER BY log;
[all …]
H A Dwherelimit2.test38 CREATE TABLE log(op, a);
51 SELECT * FROM log; DELETE FROM log;
57 SELECT * FROM log; DELETE FROM log;
63 SELECT * FROM log; DELETE FROM log;
69 SELECT * FROM log; DELETE FROM log;
278 proc log {args} { lappend ::log {*}$args }
279 db func log log
291 set ::log {}
293 set ::log
297 set ::log {}
[all …]
H A Dfunc7.test28 SELECT round(ln(5),2), log(100.0), log(100), log(2,'256');
31 SELECT ln(-5), log(-5,100.0);
58 SELECT log(100.0)
70 SELECT log(2.0, 64.0)
207 # SELECT round(log(2),7), log(-2);
209 # log() means natural logarithm in MySQL
211 SELECT log(2,65536), log(10,100), quote(log(1,100)), quote(log(0,100));
H A Dupfrom2.test62 SELECT * FROM log;
79 DELETE FROM log;
83 SELECT * FROM log;
91 DELETE FROM log;
98 SELECT * FROM log;
113 DELETE FROM log;
122 SELECT * FROM log;
151 DELETE FROM log;
166 DELETE FROM log;
178 DELETE FROM log;
[all …]
H A De_changes.test143 CREATE TABLE log(x);
169 SELECT count(*) FROM log
239 CREATE TABLE log(log);
308 CREATE TABLE log(x);
323 SELECT * FROM log;
340 CREATE TABLE log(x);
375 SELECT * FROM log;
379 DELETE FROM log;
381 SELECT * FROM log;
385 DELETE FROM log;
[all …]
H A Doserror.test27 lappend ::log $msg
59 set ::log [list]
78 lindex $::log 0
88 set ::log [list]
92 do_re_test 1.2.2 { lindex $::log 0 } {^os_unix.c:\d+: \(\d+\) open\(.*dir.db\) - }
97 set ::log [list]
101 do_re_test 1.3.2 { lindex $::log 0 } {^os_unix.c:\d+: \(\d+\) open\(.*test.db\) - }
106 set ::log [list]
111 lindex $::log 0
119 set ::log [list]
[all …]
H A DtriggerF.test22 foreach {tn sql log} {
27 INSERT INTO log VALUES(old.a || old.b || (SELECT count(*) FROM t1));
33 INSERT INTO log VALUES(old.a || old.b || (SELECT count(*) FROM t1));
39 INSERT INTO log VALUES(old.a || old.b || (SELECT count(*) FROM t1));
42 INSERT INTO log VALUES(old.a || old.b || (SELECT count(*) FROM t1));
51 CREATE TABLE log(t);
67 SELECT * FROM log ORDER BY rowid;
68 } $log
H A Dtrigger6.test32 CREATE TABLE log(a, b, c);
34 INSERT INTO log VALUES(1, new.x, new.y);
37 INSERT INTO log VALUES(2, new.x, new.y);
53 SELECT * FROM log;
59 DELETE FROM log;
66 SELECT * FROM log;
71 DELETE FROM log;
78 SELECT * FROM log;
H A Dwithout_rowid4.test237 DELETE FROM log;}
303 DROP TABLE log;
343 DROP TABLE log;
351 CREATE TABLE log (a);
366 SELECT * FROM log;
371 DROP TABLE log;
383 CREATE TABLE log (a);
400 SELECT * FROM log;
404 SELECT * FROM log;
408 SELECT * FROM log;
[all …]
H A Dtrigger2.test233 DELETE FROM log;}
299 DROP TABLE log;
339 DROP TABLE log;
347 CREATE TABLE log (a);
362 SELECT * FROM log;
367 DROP TABLE log;
379 CREATE TABLE log (a);
396 SELECT * FROM log;
400 SELECT * FROM log;
404 SELECT * FROM log;
[all …]
H A DtriggerC.test83 SELECT * FROM log;
91 DELETE FROM log;
93 SELECT * FROM log;
101 DELETE FROM log;
103 SELECT * FROM log;
410 CREATE TABLE log(t);
466 foreach {n insert log} {
549 DELETE FROM log;
553 } [join $log " "]
882 SELECT * FROM log;
[all …]
H A Dreturning1.test204 CREATE TABLE log(op, r, a, b);
224 SELECT * FROM log;
235 CREATE TEMP TABLE log(op,x,y);
237 INSERT INTO log(op,x,y) VALUES('I1',new.a,new.b);
240 INSERT INTO log(op,x,y) VALUES('D1',old.a,old.b);
263 SELECT * FROM log;
264 DELETE FROM log;
270 SELECT * FROM log;
271 DELETE FROM log;
279 SELECT * FROM log;
[all …]
H A Dwin32lock.test29 lappend ::log $msg
54 set ::log {}
66 if {[info exists ::log] && $::log!=""} {
68 regsub {\d+} $::log # x
103 set ::log {}
115 if {[info exists ::log] && $::log!=""} {
117 regsub {\d+} $::log # x
H A Dwalslow.test131 # Test large log summaries.
133 # In this case "large" usually means a log file that requires a wal-index
135 # is large enough for a log file that contains approximately 13100 frames.
138 # 4.1.*: This test case creates a very large log file within the
139 # file-system (around 200MB). The log file does not contain
141 # opened and queried, and that the invalid log file causes no
144 # 4.2.*: Test that a process may create a large log file and query
145 # the database (including the log file that it itself created).
147 # 4.3.*: Test that if a very large log file is created, and then a
149 # to query the database (and the very large log) using the
/sqlite-3.40.0/ext/wasm/
H A Ddemo-123.js40 const log = (...args)=>logHtml('',...args); function
49 log("transient db =",db.filename);
59 log("Create a table...");
71 log("Insert some data using exec()...");
111 log("row ",++this.counter,"=",row);
138 log("row ",++this.counter,"b =",row);
160 log("Create a scalar UDF...");
178 log("Result column names:",columnNames);
231 log("That's all, folks!");
278 print: log,
[all …]
H A Ddemo-jsstorage.js23 const logC = console.log.bind(console)
33 const log = function(...args){ function
59 log("db.storageSize():",db.storageSize());
62 log("kvvfs",db.filename+"Storage cleared:",sz,"entries.");
79 console.log("saveSql =",saveSql,theStore);
80 log("DB (re)initialized.");
87 log("DB rows:");
92 callback: (v)=>log(v)
99 log("size.storageSize(",dbStorage,") says", db.storageSize(),
102 log("Storage backend:",db.filename);
[all …]
H A Ddemo-worker1.js27 const log = console.log.bind(console);
29 log.apply(this, args);
99 log("Posting",eventType,"message to worker dbId="+(DbState.id||'default')+':',msg);
108 log("open result",ev);
111 log("exec result",ev);
114 log("export result",ev);
234 log("export result:",ev);
289 log("open result",ev);
322 log("Message:",ev);
342 log("Init complete, but async init bits may still be running.");
[all …]
H A Dtest-opfs-vfs.js19 const log = (...args)=>console.log(logPrefix,...args); function
23 log("tryOpfsVfs()");
32 log("OPFS VFS:",pVfs, oVfs);
43 log("db file:",db.filename);
47 log("Persistent data found. sqlite_schema entry count =",n);
60 log("count(*) from t =",db.selectValue("select count(*) from t"));
77 log("Done!");
H A Ddemo-worker1-promiser.js22 const log = console.log.bind(console);
24 log.apply(this, args);
78 log('sqlite3.config subset:', r);
92 log("then open result",r);
168 log("exec() result row:",ev);
190 log("exec() result row:",ev);
218 log("exec() result row:",ev);
269 log("Init complete, but async init bits may still be running.");
/sqlite-3.40.0/ext/rtree/
H A DrtreeG.test24 test_sqlite3_log [list lappend ::log]
25 set ::log [list]
29 set ::log {}
33 do_test rtreeG-1.1log {
34 set ::log
42 do_test rtreeG-1.2log {
43 set ::log
51 do_test rtreeG-1.3log {
52 set ::log
58 do_test rtreeG-1.4log {
[all …]
/sqlite-3.40.0/ext/session/
H A Dsession3.test36 test_sqlite3_log log
39 proc log {code msg} { lappend ::log $code $msg }
48 set ::log {}
53 set ::log
60 set ::log {}
65 set ::log
78 set ::log {}
83 set ::log

12345