SQLite

Check-in [17198a1206]
Login

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

Overview
Comment:Merge implementation of SQL window functions from the exp-window-functions into trunk.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 17198a1206e2fbc9e555881468e8c6980b00e25b5b78a6798a6264ca7384f1ca
User & Date: dan 2018-06-30 20:15:58.324
References
2021-01-21
16:02
Fix a problem caused by using an SQL variable in an OVER clause within a trigger program. Edit: The problem appears to have existed ever since window functions landed on trunk (check-in [17198a1206e2fbc9]) on 2018-06-30, version 3.25.0. (check-in: 02264ab6a0 user: dan tags: trunk)
Context
2018-06-30
20:26
Avoid a warning in fts5.c due to not using generated routine sqlite3Fts5ParserFallback(). (check-in: 65ff5144a5 user: dan tags: trunk)
20:15
Merge implementation of SQL window functions from the exp-window-functions into trunk. (check-in: 17198a1206 user: dan tags: trunk)
20:00
Fix a minor problem in the code for determining whether or not an SQL statement is SQLITE_TOOBIG. (Closed-Leaf check-in: 763e6c9e2b user: dan tags: exp-window-functions)
2018-06-21
23:53
Improved context for error_log message coming from sqlite3_prepare(). (check-in: fea7ade649 user: drh tags: trunk)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to Makefile.in.
Changes to Makefile.msc.
Changes to main.mk.
Changes to src/alter.c.
Changes to src/analyze.c.
Changes to src/attach.c.
Changes to src/btree.c.
Changes to src/btree.h.
Changes to src/expr.c.
Changes to src/func.c.
Changes to src/main.c.
Changes to src/parse.y.
Changes to src/resolve.c.
Changes to src/select.c.
Changes to src/sqlite.h.in.
Changes to src/sqliteInt.h.
Changes to src/test1.c.
Changes to src/test_config.c.
Changes to src/test_tclsh.c.
Added src/test_window.c.
Changes to src/tokenize.c.
Changes to src/vdbe.c.
Changes to src/vdbe.h.
Changes to src/vdbeInt.h.
Changes to src/vdbeapi.c.
Changes to src/vdbemem.c.
Changes to src/walker.c.
Added src/window.c.
Changes to test/permutations.test.
Added test/pg_common.tcl.
Added test/window1.test.
Added test/window2.tcl.
Added test/window2.test.
Added test/window3.tcl.
Added test/window3.test.
Added test/window4.tcl.
Added test/window4.test.
Added test/window5.test.
Added test/window6.test.
Added test/windowfault.test.
Changes to tool/lempar.c.
Changes to tool/mkkeywordhash.c.
Changes to tool/mksqlite3c-noext.tcl.
Changes to tool/mksqlite3c.tcl.