[dba-issues] [Issue 95224] cannot GROUP BY alias in g raphical query design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95224 User oleghitekschool changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from oleghiteksch...@openoffice.org Sun Apr 12 20:06:22 + 2009 --- The Issue checked and closed by HitekSchool interns, Group 1 - as part of an Issue Hunting Party. - 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
[dba-issues] [Issue 95224] cannot GROUP BY alias in g raphical query design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95224 --- Additional comments from vladimir_hiteksch...@openoffice.org Fri Apr 10 00:56:44 + 2009 --- Issue 95224 has been fixed in master version OOo-dev 3.1 .0 (OOO310m9 Build:9396) for Windows XP and can be closed. - 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
[dba-issues] [Issue 95224] cannot GROUP BY alias in g raphical query design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95224 User oj changed the following: What|Old value |New value Assigned to|oj|msc Target milestone|OOo 3.x |OOo 3.1 --- Additional comments from [EMAIL PROTECTED] Fri Nov 28 08:12:16 + 2008 --- Please verify. Thanks. - 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]
[dba-issues] [Issue 95224] cannot GROUP BY alias in g raphical query design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95224 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Tue Nov 11 08:52:31 + 2008 --- Fixed in cws dba31f - 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]
[dba-issues] [Issue 95224] cannot GROUP BY alias in g raphical query design
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 + 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]
[dba-issues] [Issue 95224] cannot GROUP BY alias in g raphical query design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95224 --- Additional comments from [EMAIL PROTECTED] Mon Oct 20 18:46:25 + 2008 --- Created an attachment (id=57324) document to reproduce the bug case - 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]
[dba-issues] [Issue 95224] cannot GROUP BY alias in g raphical query design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95224 User fs changed the following: What|Old value |New value Target milestone|--- |OOo 3.x - 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]