Uploaded image for project: 'Hibernate ORM'
  1. HHH-9491

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

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.3.7, 5.0.0.Final, 5.0.2
    • Fix Version/s: 5.1.0
    • Environment:
      Spring Boot with Spring Data JPA
    • Last commented by a user?:
      true
    • Sprint:

      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:

      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.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 0.95h
                0.95h