[dba-issues] [Issue 83769] WHERE clause incorrectly c hanged in bug doc's query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83769 User atjensen changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from [EMAIL PROTECTED] Sun Jan 27 12:53:56 + 2008 --- Test with 680M4, XP - 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: [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 83769] WHERE clause incorrectly c hanged in bug doc's query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83769 User clu changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Tue Dec 11 10:16:08 + 2007 --- verified in cws - 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 83769] WHERE clause incorrectly c hanged in bug doc's query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83769 User oj changed the following: What|Old value |New value Assigned to|oj|clu --- Additional comments from [EMAIL PROTECTED] Mon Dec 3 08:46:05 + 2007 --- 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 83769] WHERE clause incorrectly c hanged in bug doc's query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83769 --- Additional comments from [EMAIL PROTECTED] Thu Nov 22 13:21:32 + 2007 --- Fixed in cws dba24d. No SingleSelectQueryComposer involved. - 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 83769] WHERE clause incorrectly c hanged in bug doc's query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83769 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Thu Nov 22 13:46:16 + 2007 --- . - 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 83769] WHERE clause incorrectly c hanged in bug doc's query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83769 Issue #|83769 Summary|WHERE clause incorrectly changed in bug doc's query Component|Database access Version|680m236 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|oj Reported by|fs --- Additional comments from [EMAIL PROTECTED] Mon Nov 19 21:44:19 + 2007 --- - open the bugdoc attached to issue 82233 (http://www.openoffice.org/nonav/issues/showattachment.cgi/48688/BirdDatabase.odb) - select Queries on the left hand side - in the context menu of query User1SightingsList, choose Edit in SQL View = Note the WHERE clause in the statement reads (whitespaces added for better readability) ( AOU Birdlist.EnglishName = Sightings.Bird Name AND Field Trips.ID = Sightings.Field Trip ID AND Locations.LocationName = Field Trips.Location ) AND (( Sightings.User1Voice = True ) OR ( Sightings.User1Sight = True ) ) - switch to graphical design view and back = note the WHERE clause now reads ( AOU Birdlist.EnglishName = Sightings.Bird Name AND Field Trips.ID = Sightings.Field Trip ID AND Locations.LocationName = Field Trips.Location ) AND ( ( Sightings.User1Voice = True AND Sightings.User1Sight = True ) ) The new clause clearly has a different meaning, and will produce a different result. What makes this issue bad is that the change happens silently: as soon as you change *anything* in the query (for instance the tab window layout, or a similar UI setting), and save the query, the statement becomes corrupted. - 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 83769] WHERE clause incorrectly c hanged in bug doc's query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83769 User fs changed the following: What|Old value |New value Target milestone|--- |OOo 2.4 --- Additional comments from [EMAIL PROTECTED] Mon Nov 19 21:46:07 + 2007 --- fs-oj: An unreliable parser/composer is a Bad Thing (TM) - this issue should be fixed for 2.4. When you fixed this, please add a test case to the SingleSelectQueryComposer test (and any other suitable test), to ensure this doesn't happen again. 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]