Lines Matching refs:cnt
81 WITH cnt(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM cnt LIMIT 1000)
82 INSERT INTO y1 SELECT i%10, i FROM cnt;
88 WITH cnt(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM cnt LIMIT 1)
89 SELECT * FROM cnt, y1 WHERE i=a
92 |--MATERIALIZE cnt
96 | `--SCAN cnt
97 |--SCAN cnt
102 WITH cnt(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM cnt LIMIT 1000000)
103 SELECT * FROM cnt, y1 WHERE i=a
106 |--MATERIALIZE cnt
110 | `--SCAN cnt
112 `--SEARCH cnt USING AUTOMATIC COVERING INDEX (i=?)