[dba-issues] [Issue 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from o...@openoffice.org Mon Nov 2 08:14:58 + 2009 --- Please verify in cws dba32i. 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Mon Nov 2 08:28:40 + 2009 --- verified in CWS dba32i 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%2Fdba32i - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 User msc changed the following: What|Old value |New value Status|RESOLVED |REOPENED Resolution|FIXED | --- Additional comments from m...@openoffice.org Fri Oct 30 08:30:31 + 2009 --- Not fixed. If I execute the query QReport I get a 2 row result. Then open the query in design view and move a table container to modify the query. close the query and save it. execute the query - an empty result is displayed - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 User msc changed the following: What|Old value |New value Assigned to|msc |oj Status|REOPENED |NEW --- Additional comments from m...@openoffice.org Fri Oct 30 08:31:24 + 2009 --- reassign back to the 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from o...@openoffice.org Fri Oct 30 13:56:40 + 2009 --- Fixed in cws dba32i - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from o...@openoffice.org Wed Oct 28 06:59:22 + 2009 --- Please verify. Thanks. The query SELECT * FROM T WHERE ( ( :pX = X ) OR ( :pX IS NULL ) ) AND ( ( :pY = Y ) OR ( :pY IS NULL ) ) is now normalized to SELECT * FROM T AS T WHERE ( X = :pX AND Y = :pY OR X = :pX AND :pY IS NULL OR Y = :pY AND :pX IS NULL OR :pY IS NULL AND :pX IS NULL ) to be displayable in the query design. - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 User fs changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Keywords| |regression Target milestone|--- |OOo 3.2 --- Additional comments from f...@openoffice.org Thu Oct 22 09:28:52 + 2009 --- confirming, assigning, nominating as 3.2 blocker. For the record: The issue is already fixed in CWS dba33a, though I don't find the issue for it. However, instead of marking this as duplicate, I think we should fix it for 3.2 (dba33a is targeted for 3.3 only). - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 User fs changed the following: What|Old value |New value OtherIssuesDependingOnTh| |9 is| | - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 --- Additional comments from o...@openoffice.org Thu Oct 22 11:49:07 + 2009 --- @fs: No, it isn't fixed in dba33a. I just tested it with the newest instsets. - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from o...@openoffice.org Fri Oct 23 05:18:15 + 2009 --- Fixed in cws dba32i - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from atjen...@openoffice.org Tue Oct 20 00:11:52 + 2009 --- Confirmed w/ DEV320m_1, Ubuntu This looks like a duplicate, IIRC, from a recent issue dealing with AND/OR statements like this...have to find it. Will confirm this to new for the moment, but not assign to a developers until I can check for that possible duplicate. - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 Issue #|105959 Summary|Query designer corrupts valid query Component|Database access Version|current Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Fri Oct 16 11:50:22 + 2009 --- I'll attach a database with 2 queries. Open any of them in SQL view, close, then open in design view, do some null-edit(append space) in any view and store. Either query gets modified in a way that it can not return the same row set as the initial version. Short description copied from the input form: - This is how I defined Q: SELECT * FROM T WHERE ( ( :pX = X ) OR ( :pX IS NULL ) ) AND ( ( :pY = Y ) OR ( :pY IS NULL ) ) - This is what the designer makes of it when you opened it in design view and then switch to SQL view: SELECT * FROM T WHERE(X = :pX AND Y = :pY OR X = :pX OR Y = :pY) Saving anything based on this version would break the intention. - Same problem with the counterpart QReport reading the criteria directly from table F where FID=0: SELECT T.* FROM T, F WHERE F.FID=0 AND((T.X = F.FX)OR(F.FX IS NULL)) AND((T.Y = F.FY)OR(F.FY IS NULL)) - This is what the designer makes of it when you opened it in design view and then switch to SQL view: SELECT T.* FROM F, T WHERE ( F.FID = 0 AND T.X = F.FX AND F.FX IS NULL AND T.Y = F.FY OR F.FY IS NULL ) - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 --- Additional comments from ville...@openoffice.org Fri Oct 16 11:51:55 + 2009 --- Created an attachment (id=65401) DB with queries violated by the designer - 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 105959] Query designer corrupts v alid query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 --- Additional comments from ville...@openoffice.org Fri Oct 16 12:18:14 + 2009 --- By the way: What is wrong with the V column in my form? It's a numeric field with 5 decimals and it shows only 0.0 although the field has random numbers between 0 and 1. Oh, and the main form works as intended when the numeric fields are replaced with formatted fields. I did not know that numeric fields are not nullable. - 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
