Lines Matching refs:log

24   execsql {CREATE TABLE d1(n int, log int);}
36     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;
52   execsql {SELECT * FROM t1 ORDER BY log}
59     CREATE TABLE t1(log int, cnt int);
61        SELECT log, count(*) FROM d1 GROUP BY log
62        EXCEPT SELECT n-1,log FROM d1;
67     SELECT * FROM t1 ORDER BY log;
73     CREATE TABLE t1(log int, cnt int);
76        SELECT log, count(*) FROM d1 GROUP BY log
77        INTERSECT SELECT n-1,log FROM d1;
82     SELECT * FROM t1 ORDER BY log;
91     CREATE TABLE t1(log int, cnt int);
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;
97   lappend r [execsql {SELECT cnt FROM t1 WHERE log=3}]
98   lappend r [execsql {SELECT log FROM t1 WHERE cnt=4 ORDER BY log}]