To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105989 Issue #|105989 Summary|ORDER BY FunctionResult with file based DB Component|Database access Version|current Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy
------- Additional comments from [email protected] Sat Oct 17 16:29:58 +0000 2009 ------- Get a text database with a column of ISO-dates. SELECT YEAR( "Date" ) AS "Year", QUARTER( "Date" ) AS "Quarter", MONTH( "Date" ) AS "Month" FROM "Table1" AS "Table1" ORDER BY "Year" ASC fails to sort. Same with ORDER BY "Month". Surprisingly, ORDER BY "Quarter" includes the years and months. It is the same as ORDER BY "Year","Quarter","Month" --------------------------------------------------------------------- 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: [email protected] For additional commands, e-mail: [email protected]
