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]
