Lines Matching refs:main

70   uses_temp_table { INSERT INTO b SELECT * FROM main }
76   uses_temp_table { INSERT INTO b SELECT (SELECT id FROM b), id1 FROM main }
79   uses_temp_table { INSERT INTO b SELECT id1, (SELECT id FROM b) FROM main }
84       SELECT * FROM main WHERE id = (SELECT id1 FROM b WHERE main.id = b.id) }
95     SELECT * FROM main WHERE id > 10 AND max(id1, (SELECT id FROM b)) > 10;
99 # UPDATE: Using a column from the outer query (main.id) in the GROUP BY
105 #     SELECT * FROM main 
106 #     WHERE id > 10 AND (SELECT count(*) FROM v2 GROUP BY main.id)
112     SELECT * FROM main 
113     WHERE id > 10 AND (SELECT count(*) FROM v2 GROUP BY main.id)
115 } {1 {no such column: main.id}}