]
Steve Ebersole reassigned HHH-3880:
-----------------------------------
Assignee: Steve Ebersole
"AS"-alias Bug under Postgresql
-------------------------------
Key: HHH-3880
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3880
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.3.1
Environment: Hibernate Core 3.3.1
PostgreSQL 8.3
Reporter: dnalos
Assignee: Steve Ebersole
I have reporte this problem in forum, but it rebuilding now, so i create a jira task.
We use org.hibernate.id.enhanced.SequenceStyleGenerator to generate our id. The tests
running under mysql and hsql, but not under postgres.
And we find a small bug in org.hibernate.id.enhanced.TableStructure, the constructor of
this class maked e.g. the select script:
select next_val id_val from hibernate_sequence for update
But in Postgresql neds "as" between next_val and id_val. See this sentence from
PostgreSQL (
http://sql-info.de/en/postgresql/postgres-gotchas.html#1_1):
In the SQL92 standard, the optional keyword AS is just noise and can be omitted without
affecting the meaning. The PostgreSQL parser requires this keyword when renaming output
columns because the type extensibility features lead to parsing ambiguities in this
context. AS is optional in FROM items, however.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: