[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3880) "AS"-alias Bug under Postgresql

[dnalos (JIRA)]

"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


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: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira