Sqlite 3.25 released (with window functions)

Small. Fast. Reliable.Choose any three.

Add support for window functions
Enhancements the ALTER TABLE command:
Add support for renaming columns within a table using
ALTER TABLE table RENAME COLUMN oldname TO newname.
Fix table rename feature so that it also updates references
to the renamed table in triggers and views.
Query optimizer improvements:
Avoid unnecessary loads of columns in an aggregate query that
are not within an aggregate function and that are not part
of the GROUP BY clause.
The IN-early-out optimization: When doing a look-up on a
multi-column index and an IN operator is used on a column
other than the left-most column, then if no rows match against
the first IN value, check to make sure there exist rows that
match the columns to the right before continuing with the
next IN value.
Use the transitive property to try to propagate constant
values within the WHERE clause. For


Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/l2k5BzzgtQk/3_25_0.html

Original article

Comments are closed.

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑

%d bloggers like this: