[dba-issues] [Issue 98115] "Edit" is a different SQL from "Edit in SQL View"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98115 User amy2008 changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from amy2...@openoffice.org Fri Mar 27 08:10:28 + 2009 --- Verified in DEV310m7 on WinXP. Now, there is no difference in having clause. Well done. Closing Li Meiying - 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 98115] "Edit" is a different SQL from "Edit in SQL View"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98115 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Wed Jan 28 10:43:17 + 2009 --- verified in CWS dba31h find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba31h - 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 98115] "Edit" is a different SQL from "Edit in SQL View"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98115 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from o...@openoffice.org Mon Jan 26 07:08:43 + 2009 --- 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: 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 98115] "Edit" is a different SQL from "Edit in SQL View"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98115 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from o...@openoffice.org Mon Jan 19 06:56:35 + 2009 --- Fixed in cws dba31h - 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 98115] "Edit" is a different SQL from "Edit in SQL View"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98115 --- Additional comments from o...@openoffice.org Mon Jan 19 06:35:26 + 2009 --- Open the query in edit mode results in: SELECT "Code", AVG( "Price" ), COUNT( "Price" ) FROM "table1" AS "table1" GROUP BY "Code" HAVING ( ( COUNT( "Price" ) >= 4 ) ) ORDER BY "Code" ASC and switching from design in edit mode results in SELECT "Code", AVG( "Price" ), COUNT( "Price" ) FROM "table1" AS "table1" GROUP BY "Code" HAVING ( ( AVG( "Price" ) >= 4 ) ) ORDER BY "Code" ASC The difference is in the having clause. COUNT or AVG - 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 98115] "Edit" is a different SQL from "Edit in SQL View"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98115 User fs changed the following: What|Old value |New value Priority|P3|P2 Target milestone|--- |OOo 3.1 --- Additional comments from f...@openoffice.org Sat Jan 17 20:52:52 + 2009 --- returning incorrect query results is a P2, and should be fixed for the next release, if possible. fs->atjensen: please don't be that shy in assigning targets - if you don't assign one, the issue has a good chance to be overlooked, if you do, the worst thing which can happen is that it will be corrected :) - 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 98115] "Edit" is a different SQL from "Edit in SQL View"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98115 --- Additional comments from atjen...@openoffice.org Thu Jan 15 23:29:11 + 2009 --- This seems to have to do with the Colmn names returned in the result set. If you open the query and add anlias for the two columns using Averge and Count funcitons the problems disappear in all cases. Running the query directly or opening in SQL view return the correct SQL statement and result set. - 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 98115] "Edit" is a different SQL from "Edit in SQL View"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98115 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' Assigned to|dbaneedsconfirm |oj --- Additional comments from atjen...@openoffice.org Thu Jan 15 23:19:39 + 2009 --- assign to developer - 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 98115] "Edit" is a different SQL from "Edit in SQL View"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98115 User atjensen changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from atjen...@openoffice.org Thu Jan 15 23:19:00 + 2009 --- Confirmed using OOO300_m15 (3.0.1 RC2), DEV300_m37 and OOo 2.4.1 / Ubuntu Results are the same for all 3 releases Open the bug doc Execute the query "query1" by double clicking - the result set returned is NOT correct Open query1 for edit then execute it - the result set is correct With the query still open turn the Designer view off and execute - Result set returned is correct Close the query Open the query "Edit in SQL view" and execute it - the result set returned is NOT correct - 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