We're updating the issue view to help you get more done. 

Add support to opt columnDefinitions out of globally-quoted-identifiers

Description

I'm developing a project using spring boot and hibernate as a JPA provider for MySql.

Since I've some problems defining unique indexes due to reserved words I set the property hibernate.globally_quoted_identifiers to true.

This solves that problem but creates another when using columnDefinitions because hibernate put quotes on them too.

For example if I add columnDefinition="blob" then hibernate tries to execute this DDL:

1 create table `name` (`id` integer not null auto_increment, `myfield` `blob`, primary key (`id`))

i.e.: it puts "`" around the "blob" keyword, while it should not.

Environment

Spring Boot with Spring Data JPA

Status

Assignee

Steve Ebersole

Reporter

Alessandro Polverini

Fix versions

Labels

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

5.0.0.Final
4.3.7
5.0.2

Priority

Major