Skip to content

Add UNIQUE(VALUE) and remove some non-standard keywords#3305

Merged
katzyn merged 6 commits intoh2database:masterfrom
katzyn:unique
Dec 27, 2021
Merged

Add UNIQUE(VALUE) and remove some non-standard keywords#3305
katzyn merged 6 commits intoh2database:masterfrom
katzyn:unique

Conversation

@katzyn
Copy link
Contributor

@katzyn katzyn commented Dec 26, 2021

  1. An implementation of Feature S291, “Unique constraint on entire row” from the SQL Standard.
  2. LIMIT is not a keyword any more in compatibility modes where it isn't supported as an alternative to FETCH.
  3. MINUS is not allowed any more is compatibility modes where it shouldn't be available and it is also not a keyword in these modes any more.
  4. INTERSECTS is not a keyword any more, there are no reasons to treat is as a keyword.
  5. UESCAPE documentation in the table of keywords is fixed, standards compatibility was specified incorrectly.
  6. Ugly word breaks in PDF version of documentation in this table are fixed.
  7. Documentation of SET MODE now includes two new compatibility modes available since H2 2.0.204.
  8. Documentation of some compatibility modes is improved.

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

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant