Bugs item #591835, was opened at 2002-08-06 20:46 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=591835&group_id=22866
>Category: JBossCMP >Group: v3.2 Status: Open Resolution: Accepted Priority: 5 Submitted By: Stephen Coy (scoy) >Assigned to: Dain Sundstrom (dsundstrom) Summary: Include ORDER BY cols in SELECT clause Initial Comment: Some databases, Oracle in particular, require that columns named in an ORDER BY clause be included in the SELECT clause when SELECT DISTINCT is used. Here is some text from current Oracle documentation: Restrictions on the order_by_clause: * If you have specified the DISTINCT operator in this statement, then this clause cannot refer to columns unless they appear in the select list. * An order_by_clause can contain no more than 255 expressions. This can be worked around using on-find loading with load groups, but it sure would be useful if JBoss managed it for us. ---------------------------------------------------------------------- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-08-23 20:00 Message: Logged In: YES user_id=251431 This is really a bug. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=591835&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
