[dba-issues] [Issue 114299] Error with some valid que ries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114299 User r4zoli changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from r4z...@openoffice.org Sun Sep 19 07:05:18 + 2010 --- Invalid-> Closing. - 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 114299] Error with some valid que ries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114299 User r4zoli changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from r4z...@openoffice.org Sun Sep 19 07:04:42 + 2010 --- OOo Base UI parser not support all dialect of SQL in same level, the Run SQL directly option for that cases. Your query works in direct mode, I set this issue as invalid. - 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 114299] Error with some valid que ries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114299 --- Additional comments from pr...@openoffice.org Sun Sep 5 02:03:57 + 2010 --- r4zoli, I'm using MySQL 5.01 running on a SUSE x64 machine, with OO running on a Vista x64 machine, using ODBC. The query runs in Base if I check the "Run SQL command directly" button. - 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 114299] Error with some valid que ries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114299 User r4zoli changed the following: What|Old value |New value Priority|P2|P3 --- Additional comments from r4z...@openoffice.org Sat Sep 4 07:31:46 + 2010 --- Set priority back to P3, according: http://qa.openoffice.org/scdocs/ddIssues_EnterModify.html#priority - 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 114299] Error with some valid que ries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114299 User r4zoli changed the following: What|Old value |New value CC|''|'r4zoli' --- Additional comments from r4z...@openoffice.org Sat Sep 4 07:24:16 + 2010 --- What version of MySQL you used and what happens if you use JDBC or ODBC connector instead of native driver? Works with OOo Base UI or you use "Run SQL commands directly" option? Can you upload some dump script? (if not sensitive) - 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 114299] Error with some valid que ries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114299 Issue #|114299 Summary|Error with some valid queries Component|Database access Version|OOO320m12 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|prune --- Additional comments from pr...@openoffice.org Fri Sep 3 20:34:49 + 2010 --- The following query works on MySQL Workbench but gives an error in OpenOffice.org Base 3.2 (using the same database, of course): SELECT address, A.podID, adID, SUM(duration * IFNULL(startDate<='2010-02-24' AND endDate>='2010-02-24', 0)) FROM `cfm`.`adpod_schedule` AS A, `cfm`.`adpod` AS B WHERE startDate <= '2010-03-31' AND endDate >= '2010-01-06' AND A.podID=B.podID GROUP BY adID; In order to get it to work in Base, I had to replace SUM(duration * IFNULL(startDate<='2010-02-24' AND endDate>='2010-02-24', 0)) with SUM(duration * IFNULL(startDate <= '2010-02-24', 0) * IFNULL(endDate >= 2010-02-24', 0)) Quite annoying, as you can see. Interestingly, the IFNULL is colored green instead of blue as it should be, suggesting this is a parsing issue and there are problems with Base handling expressions within SUM(). - 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