SQLite

Check-in [0171e3bb4f]
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
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 0171e3bb4f663a9414b0e8b64c87b5d0683855b5
User & Date: dan 2014-01-17 15:15:10.270
Context
2014-01-17
15:27
Fix a compiler warning in selectPopWith(). (check-in: c8eb11635a user: drh tags: trunk)
15:15
Add support for common table expressions (WITH clauses). (check-in: 0171e3bb4f user: dan tags: trunk)
14:59
Fix some problems to do with WITH clauses and name resolution. (Closed-Leaf check-in: 6a549187ed 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: 16bd54783a user: drh tags: trunk)
Changes
Unified Diff Side-by-Side Diff 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.