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

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.