-
-
Notifications
You must be signed in to change notification settings - Fork 569
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
Unique index cannot have indexed expression? #4986
Comments
I'm not entirely sure why this was implemented, but it is likely, that the last mentioned precondition was misinterpreted by me at the time of implementation. Note for bugfix implementation: Function that needs fixing is |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Details
Hi,
when I open
Create index
dialog and try to create Unique index using expression I get notification that "Unique index cannot have indexed expression...", see picture below:I searched through official SQLite3 documentation, but could not find this information that it's not allowed.
In
Create Index
documenation page, there is a note on indexes with expressions:As noted above, only specific expressions are not allowed, not all expressions.
Under Indexes On Expressions documentation there is a sentence which refers to UNIQUE constraint within
CREATE TABLE
statement, not withinCREATE INDEX
:Am I missing something?
Operating system
Win 10
SQLiteStudio version
3.4.4
The text was updated successfully, but these errors were encountered: