To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95224 Issue #|95224 Summary|cannot GROUP BY alias in graphical query design Component|Database access Version|OOo 3.0 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|SRB Assigned to|oj Reported by|fs
------- Additional comments from [EMAIL PROTECTED] Mon Oct 20 18:45:42 +0000 2008 ------- - open the attached database document - open the two contained queries ("distribution per month" and "distribution per month (working)") in SQL view => notice the two statements only differ in their GROUP BY clause, where the second query groups by an expression (HOUR( "occurrences"."Zeit" )) which also appears in the SELECT list, and the first query groups by the *alias* for this expression - switch the second query ("distribution per month (working)") to graphical mode => this works as expected - switch the second query ("distribution per month") to graphical mode => an error pops up saying "Columns can only be compared using '='." and "The column 'Stunde' is unknown." => The graphical query design is not able to cope with a GROUP BY clause containing the alias of a SELECTed expression Note that OOo's parser can well cope with this - executing the query works like a charm, just displaying it in the graphical view doesn't. --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]