Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
9 check-ins related to "with-generated-as"
|
2021-02-16
| ||
| 16:32 | Trying to get the new AS MATERIALIZE syntax of CTEs to work. There are still performance and memory management issues. This is a WIP check-in. (check-in: bf0fd9b2 user: drh tags: as-materialize) | |
| 00:48 | Change the syntax from "GENERATED AS" to "AS MATERIALIZED" so as to match the syntax of PostgreSQL 12+. (Closed-Leaf check-in: 78dcddd9 user: drh tags: with-generated-as) | |
|
2021-02-15
| ||
| 17:51 | Merge the LIKE operator fix from trunk. (check-in: 8c861878 user: drh tags: with-generated-as) | |
| 17:02 | Fix an issue with the LIKE operator when it includes the "ESCAPE '_'" clause. Ticket [c0aeea67d58ae0fd]. (check-in: 27d41179 user: drh tags: trunk) | |
| 14:55 | Merge minor fixes from trunk. (check-in: d876b287 user: drh tags: with-generated-as) | |
| 14:32 | Add tests for sqlite3_column_count(). (check-in: 7cc65ae5 user: dan tags: trunk) | |
|
2021-02-13
| ||
| 23:46 | If the GENERATED keyword occurs before the AS keyword in a common table expression (CTE) definition, then that CTE becomes an "optimization barrier". For now, that means the CTE is always materialized. It also means that query flattener or pushdown optimizations that cross the CTE boundary are omitted. (check-in: 186ec18b user: drh tags: with-generated-as) | |
| 18:14 | Fix incorrect test name labels in the select1.test script. (check-in: 179c79ea user: drh tags: trunk) | |
|
2021-02-12
| ||
| 21:07 | Parsing of DML statements in a WITH clause. But at this point, it just generates an error about "not yet supported". (Leaf check-in: 964ff68d user: drh tags: dml-in-cte) | |