Patches item #670213, was opened at 2003-01-18 20:58 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428710&aid=670213&group_id=40712
Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Simon Harris (haruki_zaemon) Assigned to: Nobody/Anonymous (nobody) Summary: Support decode in addition to ANSI-style case Initial Comment: Updated to allow the use of DECODE when ANSI-style case syntax is not supported. Added 2 methods to dialect.Dialect: supportsAnsiCase and supportsDecode which return true and false respectively for backwards compatibility. Overide 2 methods in dialiect.SAPDBDialect: supportsAnsiCase and supportsDecode to return false and true respectively. Updated 1 method in persiter.MultiTableEntityPersister: propertySelectClauseFragment to generate decode if possible when ANSI-style case is not supported. ---------------------------------------------------------------------- >Comment By: Simon Harris (haruki_zaemon) Date: 2003-01-23 00:04 Message: Logged In: YES user_id=146770 Patch for same ---------------------------------------------------------------------- Comment By: Simon Harris (haruki_zaemon) Date: 2003-01-22 23:32 Message: Logged In: YES user_id=146770 Updated source files to use the latest H2 structure. I ran my own tests and the code works but I notice there is a bug in the new HB2 code somewhere using left outer joins. The following sql (1:1 association between party and membership, party has 2 join-subclasses person and company) returns 3 rows when it should only return 1: Membe1_.id as id0, Membe1_.versionId as versionId0, Membe1_.status as status0, Membe1_.expiryDate as expiryDate0, Party2_.partyId as partyId1, decode (Party2_.partyId, Party2__1.personId, 1, Party2__2.companyId, 2, Party2_.partyId, 0 ) as clazz_1, Party2_.versionId as versionId0_1, Party2_.addressStreet as addressStreet0_1, Party2_.addressCity as addressCity0_1, Party2_.addressStateOrProvince as addressStateOrProvince0_1, Party2_.addressZipOrPostalCode as addressZipOrPostalCode0_1, Party2_.addressISOCountryCode as addressISOCountryCode0_1, Party2_.phoneNumberISOCountryCode as phoneNumberISOCountryCode0_1, Party2_.phoneNumberCityOrAreaCode as phoneNumberCityOrAreaCode0_1, Party2_.phoneNumberLocalNumber as phoneNumberLocalNumber0_1, Party2_.loginName as loginName0_1, Party2__1.firstGivenName as firstGivenName1_1, Party2__1.lastGivenName as lastGivenName1_1, Party2__1.otherNames as otherNames1_1, Party2__1.dateOfBirth as dateOfBirth1_1, Party2__1.lastGivenNameSoundex as lastGivenNameSoundex1_1, Party2__2.companyName as companyName2_1, Party2__2.abn as abn2_1, Perso0_.partyId as partyId2, Perso0__1.firstGivenName as firstGivenName1_2, Perso0__1.lastGivenName as lastGivenName1_2, Perso0__1.otherNames as otherNames1_2, Perso0__1.dateOfBirth as dateOfBirth1_2, Perso0__1.lastGivenNameSoundex as lastGivenNameSoundex1_2, Perso0_.versionId as versionId0_2, Perso0_.addressStreet as addressStreet0_2, Perso0_.addressCity as addressCity0_2, Perso0_.addressStateOrProvince as addressStateOrProvince0_2, Perso0_.addressZipOrPostalCode as addressZipOrPostalCode0_2, Perso0_.addressISOCountryCode as addressISOCountryCode0_2, Perso0_.phoneNumberISOCountryCode as phoneNumberISOCountryCode0_2, Perso0_.phoneNumberCityOrAreaCode as phoneNumberCityOrAreaCode0_2, Perso0_.phoneNumberLocalNumber as phoneNumberLocalNumber0_2, Perso0_.loginName as loginName0_2 FROM Party Perso0_, Person Perso0__1, Membership Membe1_, Party Party2_, Person Party2__1, Company Party2__2 WHERE Perso0_.partyId=? and Perso0_.partyId=Membe1_.id(+) and Membe1_.id=Party2_.partyId(+) and Party2_.partyId=Party2__1.personId(+) and Party2_.partyId=Party2__2.companyId(+) ---------------------------------------------------------------------- Comment By: Simon Harris (haruki_zaemon) Date: 2003-01-19 10:09 Message: Logged In: YES user_id=146770 Attached both cvs diff and files in whole. Comment on the diff is wrong. I wrote for 2 files but actually it is for 3 files. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2003-01-19 09:52 Message: Logged In: NO Unfortunately, your patch never made it into the patch manager! (No Files Currently Attached) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428710&aid=670213&group_id=40712 ------------------------------------------------------- This SF.net email is sponsored by: Scholarships for Techies! Can't afford IT training? All 2003 ictp students receive scholarships. Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more. www.ictp.com/training/sourceforge.asp _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
