Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Improve SQLite support (don't add unique constraints via ALTER TABLE, set default for use_get_generated_keys to false)

Description

Better conform to SQLite/Xerial driver limitations.

  • Added getAlterTableToAddUniqueKeyCommand(), which always returns "", because SQLite does not support unique constraints in ALTER TABLE statements (see here).

  • Added getDefaultUseGetGeneratedKey(), which always returns false, as the Xerial driver does not support GET_GENERATED_KEYS.

I have created a corresponding PR.
Since this is about a community dialect, I understand that there won’t be a proper review etc., but I do hope the PR is applied, since right now SQLite support is broken (at least, if you want to use the automatically created DDL)
Thanks.

Activity

Show:
Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created September 22, 2023 at 2:50 PM
Updated November 23, 2023 at 2:48 PM
Resolved September 26, 2023 at 3:30 PM