Lines Matching refs:stat
17 set testprefix stat
34 do_execsql_test stat-0.0 {
39 do_catchsql_test stat-0.1a {
42 do_execsql_test stat-0.1b {
51 do_execsql_test stat-0.2 {
53 CREATE VIRTUAL TABLE temp.stat USING dbstat;
54 SELECT * FROM stat;
59 do_execsql_test stat-0.1 {
63 FROM stat;
67 do_test stat-1.0 {
75 do_test stat-1.1 {
78 FROM stat WHERE name = 't1';
81 do_test stat-1.2 {
84 FROM stat WHERE name = 'i1';
87 do_test stat-1.3 {
90 FROM stat WHERE name = 'sqlite_schema';
93 do_test stat-1.4 {
99 do_execsql_test stat-2.1 {
113 FROM stat WHERE name != 'sqlite_schema' ORDER BY name;
139 do_execsql_test stat-2.1agg {
150 do_execsql_test stat-2.2 {
153 SELECT pageno FROM stat EXCEPT SELECT pageno-1 FROM stat;
156 do_execsql_test stat-2.3 { DROP TABLE t3; VACUUM; } {}
158 do_execsql_test stat-3.1 {
163 FROM stat WHERE name != 'sqlite_schema' ORDER BY name;
184 do_execsql_test stat-3.2 {
193 do_execsql_test stat-4.1 {
197 FROM stat WHERE name = 't5' OR name = 'i5';
207 do_execsql_test stat-5.1 {
211 CREATE VIRTUAL TABLE temp.stat USING dbstat(aux1);
216 FROM stat WHERE name = 't1';
223 do_execsql_test stat-5.20 {
227 do_execsql_test stat-5.21 {
233 do_catchsql_test stat-6.1 {