[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6977) Extra lazy collection size query invalid postgresql syntax

[Gail Badner (JIRA)]

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

Gail Badner commented on HHH-6977:
----------------------------------

Is this still an issue in 4.0.1.Final? If so, please create a pull request (preferably) or attach a patch with an update to org.hibernate.test.extralazy.ExtraLazyTest that reproduces your issue.

Thanks
Gail

> Extra lazy collection size query invalid postgresql syntax 
> -----------------------------------------------------------
>
>                 Key: HHH-6977
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6977
>             Project: Hibernate ORM
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.6.0
>         Environment: PostgreSQL 9.1
>            Reporter: Dmitry Murashenkov
>
> Attempt to use extra-lazy collections with PostgreSQL ends with invalid syntax exception:
> ERROR:  subquery in FROM must have an alias
> The cause is that AbstractCollectionPersister.generateSelectSizeString fills sqlSelectSizeString query via SimpleSelect.toStatementString and it doesn't add an alias to query. Workaround is to append some alias in Dialect.appendLockHint, but not sure if it doesn't break other functionality.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira