Bugs item #2827916, was opened at 2009-07-27 16:15 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2827916&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL "stable" >Status: Closed >Resolution: Fixed Priority: 3 Private: No Submitted By: Roberto Cornacchia (cornuz) Assigned to: Niels Nes (nielsnes) Summary: ambiguous ORDER BY clause not checked Initial Comment: In the following statement, the order by clause is ambiguous. I guess the current behaviour is to order on the first of the two ids, rather than issueing an error, as it is done for the target list. sql>select args.id, types.id from args, types order by id limit 10; +------+----+ | id | id | +======+====+ | 1210 | 9 | | 1210 | 8 | | 1210 | 6 | | 1210 | 7 | | 1210 | 3 | | 1210 | 5 | | 1210 | 2 | | 1210 | 0 | | 1210 | 4 | | 1210 | 1 | +------+----+ 10 tuples ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-08-07 14:01 Message: added test to src/test/BugTracker-2009/Tests/ambiguous_order_by.SF-2827916.sql fixed, ie we now strictly check for ambiguous column names ---------------------------------------------------------------------- Comment By: Martin Kersten (mlkersten) Date: 2009-08-06 13:34 Message: An error message would be welcome ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2827916&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
