[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-3880) org.hibernate.id.enhanced.TableStructure missing "as" keyword in select statment column renames; required for PostgreSQL

org.hibernate.id.enhanced.TableStructure missing "as" keyword in select statment column renames; required for PostgreSQL ------------------------------------------------------------------------------------------------------------------------ Key: HHH-3880 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3880 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.3.1 Environment: Hibernate Core 3.3.1 PostgreSQL 8.3 Reporter: dnalos Assignee: Steve Ebersole Fix For: 3.2.x, 3.3.x, 3.5 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.