[dba-issues] [Issue 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 User msc changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from m...@openoffice.org Wed Feb 25 09:00:31 + 2009 --- Hi, this is fixed in master OOO310_m2. I close this issue now. Bye Marc - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Wed Feb 11 13:50:50 + 2009 --- verified in CWS dba31i 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%2Fdba31i - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 User mechtilde changed the following: What|Old value |New value Status whiteboard| |dba31i - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from o...@openoffice.org Wed Feb 11 07:54:32 + 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 User fs changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |fs Keywords|needhelp, regression, rele|regression, release_blocke |ase_blocker |r Target milestone|--- |OOo 3.1 --- Additional comments from f...@openoffice.org Tue Feb 3 10:59:04 + 2009 --- Thanks to the HSQL version you sent me, I was able to reproduce this with MySQL. Attached is an SQL script to create and populate the necessary tables in a MySQL database, and a database document accessing those tables. The query contained in the DB doc shows the problem: In OOo 3.0, it produces a non-empty result, in DV300.m40, it 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: 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 User fs changed the following: What|Old value |New value CC|''|'oj' Status|NEW |STARTED --- Additional comments from f...@openoffice.org Tue Feb 3 11:01:12 + 2009 --- the problem here is that the parameter is not recognized as date parameter anymore, but treated as string. This can also be observed in the parameter dialog: In 3.0, an input such as 1.1.2000 is changed to #01.01.2000#, which is a correct date notation. In m40, it is changed to '1.1.2000', which indicates it is treated as string, not as date. - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 User fs changed the following: What|Old value |New value CC|'oj' |'' Assigned to|fs|oj Status|STARTED |NEW --- Additional comments from f...@openoffice.org Tue Feb 3 11:22:06 + 2009 --- fs-oj: as talked about: OSQLParseTreeIterator::traverseParameters does not properly extract the column name / table range of the parameter columns, thus the subsequent traverseParameter does not find the respective column, and falls back to assuming a string parameter. Seems to be a regression of fixing issue 91208. - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 --- Additional comments from f...@openoffice.org Tue Feb 3 10:56:49 + 2009 --- Created an attachment (id=59852) SQL script to create the needed table structure in a MySQL database - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 --- Additional comments from f...@openoffice.org Tue Feb 3 13:46:02 + 2009 --- extended test case complex.dbaccess.Parser with method 'checkParameterTypes', to catch this kind of errors in the future. - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 --- Additional comments from f...@openoffice.org Tue Feb 3 10:57:30 + 2009 --- Created an attachment (id=59853) 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: 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from o...@openoffice.org Tue Feb 3 11:42:33 + 2009 --- Fixed in cws dba31i. - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 --- Additional comments from mechti...@openoffice.org Mon Feb 2 13:13:35 + 2009 --- I know :( I've not enough time to look for it :-( - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 --- Additional comments from f...@openoffice.org Mon Feb 2 13:00:34 + 2009 --- ping - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 --- Additional comments from f...@openoffice.org Wed Dec 17 13:14:41 + 2008 --- I tried to use this query with an example HSQL DB. But this doesn't work. What do you mean with it doesn't work here? Is it that the problem does not happen with HSQLDB? - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 --- Additional comments from f...@openoffice.org Wed Dec 17 13:13:16 + 2008 --- the table structure for the two tables Uberweisung and Konten would be helpful in reproducing the problem. Alternatively, if you can strip down this query to a shorter one, which also fails ... - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 --- Additional comments from mechti...@openoffice.org Tue Dec 16 21:26:44 + 2008 --- I tried to use this query with an example HSQL DB. But this doesn't work. It seems that this is a Problem of using mysql with JDBC. - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 User mechtilde changed the following: What|Old value |New value OtherIssuesDependingOnTh| |95768 is| | Keywords|needhelp, regression |needhelp, regression, rele | |ase_blocker - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 Issue #|97159 Summary|Query doesn't work any more Component|Database access Version|DEV300m35 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|mechtilde --- Additional comments from mechti...@openoffice.org Thu Dec 11 21:25:29 + 2008 --- A query working more than 3 1/2 year doesn't work any more with version DEV300_m35 SELECT `Konten`.`Kontonummer`, `Konten`.`Kontoname`, SUM( `Uberweisung`.`SollEUR` ), SUM( `Uberweisung`.`HabenEUR` ) FROM `Hauptbuch2008`.`Uberweisung` AS `Uberweisung`, `Hauptbuch2008`.`Konten` AS `Konten` WHERE `Uberweisung`.`Kontenbezeichnung` = `Konten`.`ID` AND `Uberweisung`.`Uberweisungsdatum` = :Anfangsdatum AND `Uberweisung`.`Uberweisungsdatum` = :Enddatum GROUP BY `Konten`.`Kontonummer`, `Konten`.`Kontoname` HAVING ( ( `Konten`.`Kontonummer` 'Null' ) ) If I execute the query the parameters are not observed. The parameter should collect all informations e.g for one month but this is ignored At this time I have no idea to give more information Please ask for them. - 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 97159] Query doesn't work any mor e
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97159 User mechtilde changed the following: What|Old value |New value Keywords| |needhelp, regression - 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