Re: [JBoss-dev] [ jboss-Bugs-591835 ] Include ORDER BY cols in SELECTclause

Mon, 28 Oct 2002 13:03:41 -0800

if you read carefully the above bug you will see that it's a oracle issue, the solution here will not generate any orderby, but when it's used (jboss-ql order by) it uses the fields in orderby clause in the select [fiels] where ...

Hunter Hillegas wrote:
Will this be something that is configurable per datasource type or mandated
in JBossCMP as the default? Will there be any way to tell JBoss *not* to add
these order bys in the event we don't want them?

Hunter
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Mon, 28 Oct 2002 11:57:13 -0800
To: [EMAIL PROTECTED]
Subject: [JBoss-dev] [ jboss-Bugs-591835 ] Include ORDER BY cols in SELECT
clause

Bugs item #591835, was opened at 2002-08-06 22:46
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=591835&group_id=2
2866

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: Emerson Cargnin (echofloripa)
Date: 2002-10-28 17:57

Message:
Logged In: YES user_id=378942

the workaround is useless if I use a dynamic-ql, correct me
if I'm wrong

----------------------------------------------------------------------

Comment By: Emerson Cargnin (echofloripa)
Date: 2002-10-15 16:23

Message:
Logged In: YES user_id=378942

For oracle users, this is really a showstopper bug. I'll try
to undertand to (maybe) try to solve that : ) obs: i think
it'll take too long to me to take this : )

----------------------------------------------------------------------

Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-08-23 22: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=2
2866


-------------------------------------------------------
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



-------------------------------------------------------
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



--
xxxxxxxxxxxxxxxxxxxxxxxxxxxx
| Emerson Cargnin          |
| Analista de Sistemas Sr. |
| Tel : (051) 3358-4959    |
| SICREDI Servi�os         |
| Porto Alegre - Brasil    |
|xxxxxxxxxxxxxxxxxxxxxxxxxx|



-------------------------------------------------------
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

Reply via email to