/ Check-in [0171e3bb]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add support for common table expressions (WITH clauses).
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 0171e3bb4f663a9414b0e8b64c87b5d0683855b5
User & Date: dan 2014-01-17 15:15:10
Context
2014-01-17
15:27
Fix a compiler warning in selectPopWith(). check-in: c8eb1163 user: drh tags: trunk
15:15
Add support for common table expressions (WITH clauses). check-in: 0171e3bb user: dan tags: trunk
14:59
Fix some problems to do with WITH clauses and name resolution. Closed-Leaf check-in: 6a549187 user: dan tags: common-table-expr
2014-01-16
15:31
Always use available indices to optimize LIKE operators even if the pattern of the LIKE operator has a COLLATE modifier. This fixes an ineffiency that was introduced into 3.7.15 by check-in [8542e6180d4] on 2012-12-08. check-in: 16bd5478 user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/btree.c.

Changes to src/build.c.

Changes to src/expr.c.

Changes to src/insert.c.

Changes to src/parse.y.

Changes to src/select.c.

Changes to src/sqlite.h.in.

Changes to src/sqliteInt.h.

Changes to src/tclsqlite.c.

Changes to src/test_config.c.

Changes to src/tokenize.c.

Changes to src/vdbe.c.

Changes to src/walker.c.

Changes to src/where.c.

Changes to test/auth.test.

Added test/with1.test.

Added test/with2.test.

Added test/withM.test.

Changes to tool/mkkeywordhash.c.