To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97948 Issue #|97948 Summary|Query gives wrong result when alias names clash with f |ield names Component|Database access Version|OOo 3.0 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ptoye
------- Additional comments from pt...@openoffice.org Sun Jan 11 16:32:56 +0000 2009 ------- Queries seem to give the wrong answer when an alias name clashes with a field name (which is itself aliased). In the query SELECT "MainTable"."Id", "Rooms"."Collation" AS "LCollation", "Rooms_1"."Collation" AS "Collation" FROM "Rooms" AS "Rooms", "MainTable" AS "MainTable", "Rooms" AS "Rooms_1" WHERE "Rooms"."ID" = "MainTable"."List location" AND "MainTable"."Location" = "Rooms_1"."ID" ORDER BY "Collation" ASC it sorts by "Rooms"."Collation" and not "Rooms_1"."Collation" as required. Renaming the alias for "Rooms_1"."Collation" to "CollationA" solves the problem. This is an acceptable workaround, but as I understand it, the original query should sort as required. Or OO should give a warning at least. I'm attaching a database to show the problem. This might be tied up with issue 50175. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org