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 [email protected] Fri Oct 16 11:50:22 +0000 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: [email protected] For additional commands, e-mail: [email protected]
