Lines Matching refs:tmp

52   WITH tmp AS ( SELECT * FROM t1 ) SELECT x FROM tmp;
56   WITH tmp(a) AS ( SELECT * FROM t1 ) SELECT a FROM tmp;
61     WITH tmp(a) AS ( SELECT * FROM t1 ) SELECT a FROM tmp
86   WITH tmp(a) AS (SELECT * FROM t1),
87        tmp(a) AS (SELECT * FROM t1)
88   SELECT * FROM tmp;
89 } {1 {duplicate WITH table name: tmp}}
103   WITH tmp  AS ( SELECT * FROM t3 ),
104        tmp2 AS ( WITH tmp AS ( SELECT * FROM t4 ) SELECT * FROM tmp )
109   WITH tmp  AS ( SELECT * FROM t3 ),
110        tmp2 AS ( WITH xxxx AS ( SELECT * FROM t4 ) SELECT * FROM tmp )
115   WITH tmp AS ( SELECT * FROM t3 ),
116   SELECT * FROM tmp;