Lines Matching refs:schema
26 CREATE VIRTUAL TABLE schema USING schema;
27 SELECT * FROM schema;
30 main schema 0 database {} 0 {} 0 \
31 main schema 1 tablename {} 0 {} 0 \
32 main schema 2 cid {} 0 {} 0 \
33 main schema 3 name {} 0 {} 0 \
34 main schema 4 type {} 0 {} 0 \
35 main schema 5 not_null {} 0 {} 0 \
36 main schema 6 dflt_value {} 0 {} 0 \
37 main schema 7 pk {} 0 {} 0 \
44 SELECT length(tablename) FROM schema GROUP by tablename;
49 SELECT tablename FROM schema GROUP by length(tablename);
51 } {schema}
54 SELECT length(tablename) FROM schema GROUP by length(tablename);
97 SELECT * FROM schema WHERE dflt_value IS NULL LIMIT 1
99 } {main schema 0 database {} 0 {} 0}
103 FROM schema a LEFT JOIN schema b ON a.dflt_value=b.dflt_value
106 } {main schema 0 database {} 0 {} 0 {} {} {} {} {} {} {} {} {}}
110 FROM schema a LEFT JOIN schema b ON a.dflt_value IS b.dflt_value
114 } {main schema 0 database {} 0 {} 0 {} {} {} {} {} {} {} {} {}}
129 execsql { CREATE VIRTUAL TABLE v_col USING schema }
158 } {/1 {malformed database schema.* already exists}/}