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: bf0fd9b23a 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: 78dcddd969 user: drh tags: with-generated-as) | |
|
2021-02-15
| ||
| 17:51 | Merge the LIKE operator fix from trunk. (check-in: 8c8618780a 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: 27d4117980 user: drh tags: trunk) | |
| 14:55 | Merge minor fixes from trunk. (check-in: d876b287e1 user: drh tags: with-generated-as) | |
| 14:32 | Add tests for sqlite3_column_count(). (check-in: 7cc65ae571 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: 186ec18b24 user: drh tags: with-generated-as) | |
| 18:14 | Fix incorrect test name labels in the select1.test script. (check-in: 179c79ea0d 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: 964ff68d8f user: drh tags: dml-in-cte) | |