2:13 p.m.
Sybase - Insert into temp table is in inverted order
-----------------------------------------------------
Key: HHH-3509
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.4.sp1
Environment: Branch_3_2_4_SP1_CP with Sybase 15
Reporter: Juraci Paixao Krohling
As per Sybase documentation [1], this is the supported way to create temp tables based on
the results of a select:
select type, "Total_amount" = sum(advance)
into #whatspent
from titles
group by type
But Hibernate [2] is generating:
insert into #Vehicle select vehicle0_.id as id from ( select id, vin, owner, 3 as clazz_
from SUV union select id, vin, owner, 4 as clazz_ from Pickup union select id, vin, owner,
1 as clazz_ from Car union select id, vin, owner, 2 as clazz_ from Truck ) vehicle0_
[1]
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
[2] BulkManipulationTest#testTempTableGenerationIsolation
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:45 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3509) Sybase - Insert into temp table is in inverted order
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509?page=c...
]
Juraci Paixao Krohling commented on HHH-3509:
---------------------------------------------
Affected tests:
org.hibernate.test.hql.BulkManipulationTest.testBooleanHandling
org.hibernate.test.hql.BulkManipulationTest.testDeleteOnDiscriminatorSubclass
org.hibernate.test.hql.BulkManipulationTest.testDeleteOnJoinedSubclass
org.hibernate.test.hql.BulkManipulationTest.testDeleteOnMappedJoin
org.hibernate.test.hql.BulkManipulationTest.testDeleteRestrictedOnManyToOne
org.hibernate.test.hql.BulkManipulationTest.testDeleteSyntaxWithCompositeId
org.hibernate.test.hql.BulkManipulationTest.testDeleteUnionSubclassAbstractRoot
org.hibernate.test.hql.BulkManipulationTest.testDeleteUnionSubclassConcreteSubclass
org.hibernate.test.hql.BulkManipulationTest.testDeleteUnionSubclassLeafSubclass
org.hibernate.test.hql.BulkManipulationTest.testDeleteWithMetadataWhereFragments
org.hibernate.test.hql.BulkManipulationTest.testInsertAcrossMappedJoinFails
org.hibernate.test.hql.BulkManipulationTest.testInsertIntoSuperclassPropertiesFails
org.hibernate.test.hql.BulkManipulationTest.testInsertWithManyToOne
org.hibernate.test.hql.BulkManipulationTest.testInsertWithMismatchedTypes
org.hibernate.test.hql.BulkManipulationTest.testSimpleDeleteOnAnimal
org.hibernate.test.hql.BulkManipulationTest.testSimpleInsert
org.hibernate.test.hql.BulkManipulationTest.testSimpleNativeSQLInsert
org.hibernate.test.hql.BulkManipulationTest.testTempTableGenerationIsolation
org.hibernate.test.hql.BulkManipulationTest.testUpdateOnAnimal
org.hibernate.test.hql.BulkManipulationTest.testUpdateOnComponent
org.hibernate.test.hql.BulkManipulationTest.testUpdateOnDiscriminatorSubclass
org.hibernate.test.hql.BulkManipulationTest.testUpdateOnImplicitJoinFails
org.hibernate.test.hql.BulkManipulationTest.testUpdateOnMammal
org.hibernate.test.hql.BulkManipulationTest.testUpdateOnManyToOne
org.hibernate.test.hql.BulkManipulationTest.testUpdateSetNullOnDiscriminatorSubclass
org.hibernate.test.hql.BulkManipulationTest.testUpdateSetNullOnJoinedSubclass
org.hibernate.test.hql.BulkManipulationTest.testUpdateSetNullUnionSubclass
org.hibernate.test.hql.BulkManipulationTest.testUpdateWithWhereExistsSubquery
org.hibernate.test.hql.ScrollableCollectionFetchingTest.testScrollingJoinFetchesForward
org.hibernate.test.hql.ScrollableCollectionFetchingTest.testScrollingJoinFetchesPositioning
org.hibernate.test.hql.ScrollableCollectionFetchingTest.testScrollingJoinFetchesReverse
org.hibernate.test.hql.WithClauseTest.testWithClauseFailsWithFetch
org.hibernate.test.hql.WithClauseTest.testWithClause
org.hibernate.test.hql.ASTParserLoadingTest.testCollectionFetchWithDistinctionAndLimit
org.hibernate.test.onetomany.OneToManyTest.testOneToManyLinkTable
org.hibernate.test.subclassfilter.JoinedSubclassFilterTest.testFiltersWithJoinedSubclass
Sybase - Insert into temp table is in inverted order
-----------------------------------------------------
Key: HHH-3509
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.4.sp1
Environment: Branch_3_2_4_SP1_CP with Sybase 15
Reporter: Juraci Paixao Krohling
As per Sybase documentation [1], this is the supported way to create temp tables based on
the results of a select:
select type, "Total_amount" = sum(advance)
into #whatspent
from titles
group by type
But Hibernate [2] is generating:
insert into #Vehicle select vehicle0_.id as id from ( select id, vin, owner, 3 as clazz_
from SUV union select id, vin, owner, 4 as clazz_ from Pickup union select id, vin, owner,
1 as clazz_ from Car union select id, vin, owner, 2 as clazz_ from Truck ) vehicle0_
[1]
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
[2] BulkManipulationTest#testTempTableGenerationIsolation
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:14 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3509) Sybase - Insert into temp table is in inverted order
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509?page=c...
]
Gail Badner commented on HHH-3509:
----------------------------------
Hibernate actually creates the temp table using "create table #blah(....)".
I believe the problem is due to tempdb not being properly configured to allow DDL in
transactions. Hibernate swallows the exception on the create statement, so an exception is
thrown on the insert statement instead.
Sybase - Insert into temp table is in inverted order
-----------------------------------------------------
Key: HHH-3509
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.4.sp1
Environment: Branch_3_2_4_SP1_CP with Sybase 15
Reporter: Juraci Paixao Krohling
As per Sybase documentation [1], this is the supported way to create temp tables based on
the results of a select:
select type, "Total_amount" = sum(advance)
into #whatspent
from titles
group by type
But Hibernate [2] is generating:
insert into #Vehicle select vehicle0_.id as id from ( select id, vin, owner, 3 as clazz_
from SUV union select id, vin, owner, 4 as clazz_ from Pickup union select id, vin, owner,
1 as clazz_ from Car union select id, vin, owner, 2 as clazz_ from Truck ) vehicle0_
[1]
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
[2] BulkManipulationTest#testTempTableGenerationIsolation
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:14 a.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-3509) Sybase - Insert into temp table is in inverted order
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509?page=c...
]
Gail Badner reassigned HHH-3509:
--------------------------------
Assignee: Gail Badner
Sybase - Insert into temp table is in inverted order
-----------------------------------------------------
Key: HHH-3509
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.4.sp1
Environment: Branch_3_2_4_SP1_CP with Sybase 15
Reporter: Juraci Paixao Krohling
Assignee: Gail Badner
As per Sybase documentation [1], this is the supported way to create temp tables based on
the results of a select:
select type, "Total_amount" = sum(advance)
into #whatspent
from titles
group by type
But Hibernate [2] is generating:
insert into #Vehicle select vehicle0_.id as id from ( select id, vin, owner, 3 as clazz_
from SUV union select id, vin, owner, 4 as clazz_ from Pickup union select id, vin, owner,
1 as clazz_ from Car union select id, vin, owner, 2 as clazz_ from Truck ) vehicle0_
[1]
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
[2] BulkManipulationTest#testTempTableGenerationIsolation
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:49 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3509) Sybase - Insert into temp table is in inverted order
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509?page=c...
]
Gail Badner commented on HHH-3509:
----------------------------------
Juca,
These tests are all succeeding now that tempdb is properly configured to allow DDL in
transactions.
Gail
Sybase - Insert into temp table is in inverted order
-----------------------------------------------------
Key: HHH-3509
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.4.sp1
Environment: Branch_3_2_4_SP1_CP with Sybase 15
Reporter: Juraci Paixao Krohling
Assignee: Gail Badner
As per Sybase documentation [1], this is the supported way to create temp tables based on
the results of a select:
select type, "Total_amount" = sum(advance)
into #whatspent
from titles
group by type
But Hibernate [2] is generating:
insert into #Vehicle select vehicle0_.id as id from ( select id, vin, owner, 3 as clazz_
from SUV union select id, vin, owner, 4 as clazz_ from Pickup union select id, vin, owner,
1 as clazz_ from Car union select id, vin, owner, 2 as clazz_ from Truck ) vehicle0_
[1]
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
[2] BulkManipulationTest#testTempTableGenerationIsolation
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:25 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3509) Sybase - Insert into temp table is in inverted order
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509?page=c...
]
Gail Badner commented on HHH-3509:
----------------------------------
Juca, can this be resolved?
Sybase - Insert into temp table is in inverted order
-----------------------------------------------------
Key: HHH-3509
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.4.sp1
Environment: Branch_3_2_4_SP1_CP with Sybase 15
Reporter: Juraci Paixao Krohling
Assignee: Gail Badner
As per Sybase documentation [1], this is the supported way to create temp tables based on
the results of a select:
select type, "Total_amount" = sum(advance)
into #whatspent
from titles
group by type
But Hibernate [2] is generating:
insert into #Vehicle select vehicle0_.id as id from ( select id, vin, owner, 3 as clazz_
from SUV union select id, vin, owner, 4 as clazz_ from Pickup union select id, vin, owner,
1 as clazz_ from Car union select id, vin, owner, 2 as clazz_ from Truck ) vehicle0_
[1]
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
[2] BulkManipulationTest#testTempTableGenerationIsolation
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:08 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-3509) Sybase - Insert into temp table is in inverted order
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509?page=c...
]
Juraci Paixao Krohling resolved HHH-3509.
-----------------------------------------
Resolution: Fixed
I confirmed that all listed test cases are now passing for Sybase. So, I'm closing
this issue.
Sybase - Insert into temp table is in inverted order
-----------------------------------------------------
Key: HHH-3509
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.4.sp1
Environment: Branch_3_2_4_SP1_CP with Sybase 15
Reporter: Juraci Paixao Krohling
Assignee: Gail Badner
As per Sybase documentation [1], this is the supported way to create temp tables based on
the results of a select:
select type, "Total_amount" = sum(advance)
into #whatspent
from titles
group by type
But Hibernate [2] is generating:
insert into #Vehicle select vehicle0_.id as id from ( select id, vin, owner, 3 as clazz_
from SUV union select id, vin, owner, 4 as clazz_ from Pickup union select id, vin, owner,
1 as clazz_ from Car union select id, vin, owner, 2 as clazz_ from Truck ) vehicle0_
[1]
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
[2] BulkManipulationTest#testTempTableGenerationIsolation
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:30 p.m.
New subject: [Hibernate-JIRA] Reopened: (HHH-3509) Sybase - Insert into temp table is in inverted order
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509?page=c...
]
Gail Badner reopened HHH-3509:
------------------------------
Sybase - Insert into temp table is in inverted order
-----------------------------------------------------
Key: HHH-3509
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.4.sp1
Environment: Branch_3_2_4_SP1_CP with Sybase 15
Reporter: Juraci Paixao Krohling
Assignee: Gail Badner
As per Sybase documentation [1], this is the supported way to create temp tables based on
the results of a select:
select type, "Total_amount" = sum(advance)
into #whatspent
from titles
group by type
But Hibernate [2] is generating:
insert into #Vehicle select vehicle0_.id as id from ( select id, vin, owner, 3 as clazz_
from SUV union select id, vin, owner, 4 as clazz_ from Pickup union select id, vin, owner,
1 as clazz_ from Car union select id, vin, owner, 2 as clazz_ from Truck ) vehicle0_
[1]
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
[2] BulkManipulationTest#testTempTableGenerationIsolation
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:32 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-3509) Sybase - Insert into temp table is in inverted order
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509?page=c...
]
Gail Badner resolved HHH-3509.
------------------------------
Resolution: Rejected
Changed resolution to "Rejected" because this was due to a DB config issue, not
a Hibernate bug.
Sybase - Insert into temp table is in inverted order
-----------------------------------------------------
Key: HHH-3509
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3509
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.4.sp1
Environment: Branch_3_2_4_SP1_CP with Sybase 15
Reporter: Juraci Paixao Krohling
Assignee: Gail Badner
As per Sybase documentation [1], this is the supported way to create temp tables based on
the results of a select:
select type, "Total_amount" = sum(advance)
into #whatspent
from titles
group by type
But Hibernate [2] is generating:
insert into #Vehicle select vehicle0_.id as id from ( select id, vin, owner, 3 as clazz_
from SUV union select id, vin, owner, 4 as clazz_ from Pickup union select id, vin, owner,
1 as clazz_ from Car union select id, vin, owner, 2 as clazz_ from Truck ) vehicle0_
[1]
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
[2] BulkManipulationTest#testTempTableGenerationIsolation
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5818
days inactive
5959
days old
hibernate-issues@lists.jboss.org
8 comments
2 participants
participants (2)
-
Gail Badner (JIRA) -
Juraci Paixao Krohling (JIRA)