Message Title

Jan Martiška created an issue

HHH-9139

Issue Type:	Bug
Affects Versions:	4.2.12
Assignee:	Brett Meyer
Components:	core
Created:	23/Apr/14 5:49 AM
Priority:	Major
Reporter:	Jan Martiška

Bug introduced by the fix for

~~HHH-9078~~ .
In AbstractCollectionPersister's method generateSelectSizeString, it doesn't count with the fact that getTableName() can return a SQL subquery rather than a table name. In particular, this happens in the case of collection persister (OneToManyPersister) when the underlying element persister is a UnionSubclassEntityPersister (there might be more such cases).
The generated select size string then contains a SELECT from a table denoted by a subquery, but it fails on MSSQL, MySQL and PostgreSQL because these DBs require derived tables to have an alias.

Therefore, org.hibernate.test.unionsubclass.UnionSubclassTest.testUnionSubclass fails on these databases.

 
                                                    12:35:53,987 DEBUG SQL:104 - select count(bid) from ( select bid, ident, location, sex, salary, null as species, null as hive, 2 as clazz_ from employees union select bid, ident, location, sex, null as salary, null as species, null as hive, 1 as clazz_ from humans union select bid, ident, location, null as sex, null as salary, species, hive, 3 as clazz_ from aliens ) where location =?
12:35:54,171  WARN SqlExceptionHelper:144 - SQL Error: 1248, SQLState: 42000
12:35:54,172 ERROR SqlExceptionHelper:146 - Every derived table must have its own alias

To reproduce, run the mentioned test on MSSQL, MySQL or PostgreSQL.

Add Comment

This message was sent by Atlassian JIRA