Lines Matching refs:data

113   CREATE TABLE t1 (id INTEGER PRIMARY KEY, data TEXT);
114   INSERT INTO t1(id,data) VALUES(9,'nine-a');
115   INSERT INTO t1(id,data) VALUES(10,'ten-a');
116   INSERT INTO t1(id,data) VALUES(11,'eleven-a');
117   CREATE TABLE t2 (id INTEGER PRIMARY KEY, data TEXT);
118   INSERT INTO t2(id,data) VALUES(9,'nine-b');
119   INSERT INTO t2(id,data) VALUES(10,'ten-b');
120   INSERT INTO t2(id,data) VALUES(11,'eleven-b');
123     SELECT id,data FROM (
126     WHERE id=10 ORDER BY data
130   SELECT data FROM (
131      SELECT 'dummy', data FROM (
132        SELECT data FROM t1 UNION ALL SELECT data FROM t1
133      ) ORDER BY data
139   CREATE TABLE t3(id INTEGER, data TEXT);
140   CREATE TABLE t4(id INTEGER, data TEXT);
144   SELECT data, id FROM (
145     SELECT id, data FROM (
147     ) ORDER BY data