Bugs item #669070, was opened at 2003-01-17 01:30 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=669070&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: Duplicate alias generated for 2 different columns in select Initial Comment: I have a table containing (among others) the following two columns: addressCountryOrRegionCode; and phoneNumberCountryOrRegionCode mapped to properties: countryOrRegionCode; and countryOrRegionCode in two components: Address; and PhoneNumber respectively. The select statement is generated as follows: Hibernate: SELECT Perso0.partyId AS partyId, Perso0_1.firstGivenName as irstGivenName1_, Perso0_1.lastGivenName as lastGivenName1_, Perso0_1.otherNames as otherNames1_, Perso0_1.dateOfBirth as dateOfBirth1_, Perso0.versionId as versionId0_, Perso0.addressStreet as addressStreet0_, Perso0.addressCity as addressCity0_, Perso0.addressStateOrProvince as ateOrProvince0_, Perso0.addressZipOrPostalCode as pOrPostalCode0_, Perso0.addressCountryOrRegionCode as yOrRegionCode0_, Perso0.phoneNumberCountryOrRegionCode as yOrRegionCode0_, Perso0.phoneNumberCityOrAreaCode as ityOrAreaCode0_, Perso0.phoneNumberLocalNumber as erLocalNumber0_, Perso0.loginName as loginName0_ FROM Party Perso0 INNER JOIN Person Perso0_1 ON Perso0.partyId=Perso0_1.personId WHERE Perso0.partyId = ? As you can see, the table column names are different but the generated aliases are the same. ---------------------------------------------------------------------- >Comment By: Gavin King (oneovthafew) Date: 2003-01-17 20:01 Message: Logged In: YES user_id=384580 I disabled the new "feature" in CVS, so this bug will no longer occur. ---------------------------------------------------------------------- Comment By: Gavin King (oneovthafew) Date: 2003-01-17 19:44 Message: Logged In: YES user_id=384580 We are aware of this issue. I'm not quite sure how to address it. This problem only occurs in the current CVS, due to a new feature that allows long column names for databases which restrict alias lengths. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428708&aid=669070&group_id=40712 ------------------------------------------------------- This SF.NET email is sponsored by: Thawte.com - A 128-bit supercerts will allow you to extend the highest allowed 128 bit encryption to all your clients even if they use browsers that are limited to 40 bit encryption. Get a guide here:http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0030en _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
