Searched refs:CTE (Results 1 – 5 of 5) sorted by relevance
| /sqlite-3.40.0/tool/ |
| H A D | mkkeywordhash.c | 143 # define CTE 0 macro
145 # define CTE 0x00040000 macro
258 { "MATERIALIZED", "TK_MATERIALIZED", CTE, 12 },
282 { "RECURSIVE", "TK_RECURSIVE", CTE, 3 },
318 { "WITH", "TK_WITH", CTE, 4 },
|
| /sqlite-3.40.0/test/ |
| H A D | normalize.test | 30 WHERE d IN (WITH t(a) AS (VALUES(5)) /* CTE */
40 WHERE d IN (WITH t(a) AS (VALUES(5)) /* CTE */
146 WHERE d IN (WITH t(a) AS (VALUES(5)) /* CTE */
157 WHERE d IN (WITH t(a) AS (VALUES(5)) /* CTE */
|
| H A D | with1.test | 852 # 2015-05-27: Do not allow rowid usage within a CTE
1014 # EXPLAIN QUERY PLAN on a self-join of a CTE
1048 # Two different CTE tables with the same name appear in within a single FROM
1075 # Make sure crazy nexted CTE joins terminate with an error quickly.
1144 # Do not allow the generated name of a CTE be "true" or "false" as
1181 # DISTINCT cannot be ignored in a UNION ALL recursive CTE
|
| H A D | with6.test | 56 # Even though the CTE is not materialized, the self-join optimization
255 # 2022-04-22: Do not allow flattening of a MATERIALIZED CTE into
|
| H A D | with3.test | 202 # Avoid manifesting the same CTE multiple times.
|