quarkiverse/quarkus-jdbc-sqlite

error when creating unique constraint

Closed this issue · 2 comments

davinwang commented

error happens when declaring a unique constraint:

    @Column(name = "uk_column", unique = true)
    public String uk_column;

It reports

Error` executing `DDL` "alter table dt_table add constraint UKjlid30ljaxbdig1jijlrcqejh unique (uk_column)" via JDBC [[SQLITE_ERROR]

The right DDL should be

   create unique constraint UKjlid30ljaxbdig1jijlrcqejh on dt_table(uk_column)
alexeysharandin commented

Hi, looks like problem in Community Dialect and need to open issue for Hibernate Team.

davinwang commented