Bugs item #741486, was opened at 2003-05-22 06:36 Message generated for change (Comment added) made by loubyansky You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=741486&group_id=22866
Category: JBossCMP Group: v3.2 >Status: Closed >Resolution: Out of Date Priority: 5 Submitted By: Jeremy Boynes (jboynes) Assigned to: Alexey Loubyansky (loubyansky) Summary: LoadRelation uses same column twice Initial Comment: Under some circumstances, the sql generated by the LoadRelation command can contain the same column name twice. This is an issue for some databases, specifically Tandem's NonStop. This happens when the ReadAhead cache contains multiple primary keys for the source of an N->1 CMR navigation. The pk columns are added to the select list to ensure the rows being joined can be identitifed; if the PK columns are already in the select list due to a FK->PK mapping, they will be added twice. As far as I can tell, this is not a SQL spec violation (and it works on hsqldb) but does fail on the NonStop and may fail on other platforms. A workaround is disable read-ahead for the finder(s) that caused the pk's to be inserted in the read-ahead cache. ---------------------------------------------------------------------- >Comment By: Alexey Loubyansky (loubyansky) Date: 2004-08-08 17:12 Message: Logged In: YES user_id=543482 Couldn't reproduce with the 3.2.6rc2. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=741486&group_id=22866 ------------------------------------------------------- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
