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

[Steve Ebersole (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3880?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=33332#action_33332 ] 

Steve Ebersole commented on HHH-3880:
-------------------------------------

You are forcing this to use a table as the backing it looks like?  Normally SequenceStyleGenerator is going to utilize a sequence against org.hibernate.dialect.PostgreSQLDialect..  I need to see your configuration of the SequenceStyleGenerator

> "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