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: 7 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: Gavin King (oneovthafew) Date: 2003-01-25 00:24 Message: Logged In: YES user_id=384580 The patches are useless; they consist mainly of whitespace changes. And they are missing the essential bit (the new CaseFragment concrete classes). How about if you just skip patch and simploy zip up the three files: CaseFragment.java ANSICaseFragment.java DecodeCaseFragment.java and submit them. I can fill in the rest of the details. Thanks Gavin ---------------------------------------------------------------------- Comment By: Gavin King (oneovthafew) Date: 2003-01-24 01:45 Message: Logged In: YES user_id=384580 Excellent, I will integrate this ASAP (which may not be immediately, since I am super-busy). But thanks, this is a very useful feature! :) ---------------------------------------------------------------------- Comment By: Simon Harris (haruki_zaemon) Date: 2003-01-23 20:55 Message: Logged In: YES user_id=146770 Some minor changes. ---------------------------------------------------------------------- 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: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
