I think, this is another problem. Message say :
> >> ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in
> >> target list
Which mean, that columns used in "ORDER BY"-expression are not used in
"TARGET".
So in that select :
> >> SELECT DISTINCT t0_s.rec_num FROM sample_request t0_s,
> >> sample_request_line_item t1_li WHERE (t1_li.fulfillment_status =
> >> 'Shipped'
> >> AND t1_li.followup_date <= '2003-02-04 20:00:00.000000000+00' AND
> >> (t1_li.customer_prospect_feedback IS NULL OR
> >> t1_li.customer_prospect_feedback = '')) AND
> >> (t0_s.rec_num=t1_li.parentRequest) ORDER BY
> >> t0_s.date_of_request DESC
Target : DISTINCT t0_s.rec_num
Order by : t0_s.date_of_request
I've experience with INFORMIX, and this select is wrong for INFORMIX.
vlk
> -----Original Message-----
> From: Dain Sundstrom [mailto:[EMAIL PROTECTED]]
> Sent: 8. februara 2003 16:47
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] JBoss Generating Some Bad SQL
>
>
> We have the same problem with Oracle. I personally think
> this is a bug
> with both of the databases.
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
