Back to bug 1018146
| Who | When | What | Removed | Added |
|---|---|---|---|---|
| Brett Meyer | 2013-10-14 14:38:51 UTC | Status | NEW | MODIFIED |
| Target Release | --- | EAP 6.3.0 | ||
| Doc Text | Stems from https://hibernate.atlassian.net/browse/HHH-8476. sqlserver/sybase do not support tuples in subqueries (ex: "delete from Table1 where (col1, col2) in (select col1, col2 from Table2)"). The fix for HHH-8476 was skipped and logged where the tuples were not supported, but not all dialects had been audited. Operationally, nothing is "wrong" -- the HHH-8476 fix is simply throwing an exception rather than warning. Workaround: properly manage both sides of a many-to-many relationship before bulk deleting either side. | |||
| Doc Type | Bug Fix | Known Issue | ||
| Brett Meyer | 2013-10-23 15:26:27 UTC | Target Release | EAP 6.3.0 | EAP 6.2.0 |
| Target Milestone | --- | ER7 | ||
| Brett Meyer | 2013-10-23 15:27:46 UTC | Blocks | 1022581 | |
| Paul Gier | 2013-10-30 21:42:18 UTC | Status | MODIFIED | ON_QA |
| Martin Simka | 2013-11-08 11:05:05 UTC | Status | ON_QA | VERIFIED |
| Lucas Costi | 2013-11-25 06:16:56 UTC | CC | brmeyer, lcosti | |
| Flags | needinfo?(brmeyer) | |||
| Brett Meyer | 2013-11-25 13:42:43 UTC | Flags | needinfo?(brmeyer) | |
| Lucas Costi | 2013-11-26 03:40:00 UTC | Doc Text | Stems from https://hibernate.atlassian.net/browse/HHH-8476. sqlserver/sybase do not support tuples in subqueries (ex: "delete from Table1 where (col1, col2) in (select col1, col2 from Table2)"). The fix for HHH-8476 was skipped and logged where the tuples were not supported, but not all dialects had been audited. Operationally, nothing is "wrong" -- the HHH-8476 fix is simply throwing an exception rather than warning. Workaround: properly manage both sides of a many-to-many relationship before bulk deleting either side. | On Sybase and Microsoft SQL Server, HQL queries which had tuples in subqueries would throw exceptions. Both Sybase and Microsoft SQL Server do not support tuples in subqueries, such as the following query: `"delete from Table1 where (col1, col2) in (select col1, col2 from Table2)` This issue occurred because the Hibernate dialects for Sybase and Microsoft SQL Server did not configure the `supportsTuplesInSubqueries` property to `false`. In this release of JBoss EAP 6, the Hibernate dialects for Sybase and Microsoft SQL Server have been updated to accurately reflect the lack of support for tuples in subqueries. As a result, warnings should now be produced rather than throwing exceptions. |
| Lucas Costi | 2013-11-26 03:41:17 UTC | Doc Text | On Sybase and Microsoft SQL Server, HQL queries which had tuples in subqueries would throw exceptions. Both Sybase and Microsoft SQL Server do not support tuples in subqueries, such as the following query: `"delete from Table1 where (col1, col2) in (select col1, col2 from Table2)` This issue occurred because the Hibernate dialects for Sybase and Microsoft SQL Server did not configure the `supportsTuplesInSubqueries` property to `false`. In this release of JBoss EAP 6, the Hibernate dialects for Sybase and Microsoft SQL Server have been updated to accurately reflect the lack of support for tuples in subqueries. As a result, warnings should now be produced rather than throwing exceptions. | On Sybase and Microsoft SQL Server, HQL queries which had tuples in subqueries would throw exceptions. Both Sybase and Microsoft SQL Server do not support tuples in subqueries, such as the following query: `delete from Table1 where (col1, col2) in (select col1, col2 from Table2)` This issue occurred because the Hibernate dialects for Sybase and Microsoft SQL Server did not configure the `supportsTuplesInSubqueries` property to `false`. In this release of JBoss EAP 6, the Hibernate dialects for Sybase and Microsoft SQL Server have been updated to accurately reflect the lack of support for tuples in subqueries. As a result, warnings should now be produced rather than throwing exceptions. |
| Doc Type | Known Issue | Bug Fix | ||
| Russell Dickenson | 2013-12-03 04:30:08 UTC | Doc Text | On Sybase and Microsoft SQL Server, HQL queries which had tuples in subqueries would throw exceptions. Both Sybase and Microsoft SQL Server do not support tuples in subqueries, such as the following query: `delete from Table1 where (col1, col2) in (select col1, col2 from Table2)` This issue occurred because the Hibernate dialects for Sybase and Microsoft SQL Server did not configure the `supportsTuplesInSubqueries` property to `false`. In this release of JBoss EAP 6, the Hibernate dialects for Sybase and Microsoft SQL Server have been updated to accurately reflect the lack of support for tuples in subqueries. As a result, warnings should now be produced rather than throwing exceptions. | On Sybase and Microsoft SQL Server, HQL queries which had tuples in subqueries would throw exceptions. Neither Sybase nor Microsoft SQL Server support tuples in subqueries, such as the following query: `delete from Table1 where (col1, col2) in (select col1, col2 from Table2)` This issue occurred because the Hibernate dialects for Sybase and Microsoft SQL Server did not configure the `supportsTuplesInSubqueries` property to `false`. In this release of JBoss EAP 6, the Hibernate dialects for Sybase and Microsoft SQL Server have been updated to accurately reflect the lack of support for tuples in subqueries. As a result, warnings are now produced rather than throwing exceptions. |
| mark yarborough | 2013-12-15 16:19:55 UTC | Status | VERIFIED | CLOSED |
| Resolution | --- | CURRENTRELEASE | ||
| Last Closed | 2013-12-15 11:19:55 UTC | |||
| John Skeoch | 2015-09-01 04:00:34 UTC | CC | theute |
Back to bug 1018146