Add SQL dialect for SQLite 3

Description

SQLite type affinity and limited support for altering table means that hibernate.hbm2ddl.auto cannot be set to modify nor create (I seem to recall that FK constraints are added after tables).
And when hibernate.hbm2ddl.auto is set to validate, Hibernate don't know that 'float', 'double', 'real' means the same thing for SQLite.
Also, there is no date/time datatype (See Time Strings). So a date can be stored in a column declared with text or float or integer or numeric affinity.

Environment

None

Activity

Show:
Christian Beikov
March 3, 2021, 6:22 PM

For reference, we are discussing the way forward for new Dialects in https://github.com/hibernate/hibernate-orm/discussions/3783

Vlad Mihalcea
April 3, 2016, 7:04 PM

Thanks for the PR. I'll review it and merge it upstream.

Assignee

Unassigned

Reporter

Gwenael Treguier

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

backportDecision

None

Components

Priority

Minor