New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade to SQLite 3.26.0 #3470

Open
thomasnield opened this Issue Dec 6, 2018 · 1 comment

Comments

2 participants
@thomasnield
Copy link

thomasnield commented Dec 6, 2018

Can we please get an upgrade to the latest version of SQLite released? There's a lot of new features added to SQLite since then, primarily windowing functions.

@pawelsalawa

This comment has been minimized.

Copy link
Owner

pawelsalawa commented Dec 7, 2018

Apart from upgrading SQLite version SQLiteStudio should start supporting window functions. This will be tracked by a separate issue (#3471), aimed for 3.3.0 (while SQLite version upgrade will be done within 3.2.2).

Upgrading to 3.25.0 or newer requires modifications in TableModifier class, as 3.25 fixed few things in ALTER TABLE statement and referencing objects:

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.

A quick way to handle it is "PRAGMA legacy_alter_table" if there is not enough time to do it properly in 3.2.2.

@pawelsalawa pawelsalawa added this to the 3.2.2 milestone Dec 7, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment