Look... You reported that if you "set the property hibernate.globally_quoted_identifiers to true" that Hibernate "puts "`" around the "blob" keyword, while it should not". That is your report here. I pointed out that, in fact, Hibernate should quote (put "`" around) blob, not because it is a keyword but because you asked Hibernate to quote all identifiers and JPA says that columnDefinition falls into this category. I pointed all this out to you even including the spec sections and quoting the important snippets. You are the one who keeps confusing why that happens - it has nothing to do with "blob being a keyword". Any way, this works exactly as JPA says it should. You specify a columnDefinition and request "global quoting" and JPA says that global quoting should be applied to columnDefinition. Which brings us to my proposal. I mean really there is only 2 outcomes here. This is not a bug, so there is nothing to "fix". However, I personally believe that JPA is being too inclusive when it says that columnDefinition (and foreignKeyDefinition) should be quoted due to global quoting being requested. So the only 2 outcomes here are to either:
- Do nothing - reject this issue. Again this is not a bug
- Allow a configuration option that says that columnDefinition (and foreignKeyDefinition) should be excluded from global quote handling - which is what I proposed
|