I think that the databases that do not support having columns in the order that are not in the select are lame. There is no reason why it can not figure out which column it will need to sort and add these to the select under the covers. This is simply a complaint of mine. Jeremy has already changed our sql generator to generate the sql so the "lame" database implementations will work.
-dain
On Monday, February 10, 2003, at 02:24 AM, KRALIK Vladimir wrote:
I think, this is another problem. Message say :ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target listWhich 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 DESCTarget : 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
------------------------------------------------------- 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
