Bugs item #2827916, was opened at 2009-07-27 18:15 Message generated for change (Tracker Item Submitted) made by cornuz 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: Open Resolution: None Priority: 5 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 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2827916&group_id=56967 ------------------------------------------------------------------------------ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
