<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Query: Clicking 'Switch Design View On/Off' a few times messes up SQL JOINs" href="https://bugs.documentfoundation.org/show_bug.cgi?id=108375#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Query: Clicking 'Switch Design View On/Off' a few times messes up SQL JOINs" href="https://bugs.documentfoundation.org/show_bug.cgi?id=108375">bug 108375</a> from <a class="email" href="mailto:BridgeportContractor@gmail.com" title="Howard Johnson <BridgeportContractor@gmail.com>"> Howard Johnson</a> <pre>Because you can't edit any query in GUI mode, even if you don't change a single thing in the design, without it very often and quietly messing up your joins, resulting in silent data integrity consequences, I am requesting that this please be upgraded to MAJOR. For example, you can't even open a query, change nothing at all, then save the design, without fear of it having messes up your joins. So afterwards when you run the query, like in a report, the data is selected wrong and some records are left out, and you might not even notice it for some time!!! The painful workaround for now: Every single time you edit a query you have to manually check each and every join to make sure that it hasn't gotten messed up. For queries with one join this isn't too much of an issue, but for queries with 5 or 10 joins, this is a pain in the neck to have to do each time you try to edit the query. Other observations: * I also noticed that some times a Right or Left join gets changed to an inner join. * I have noticed that this bug occurs when the SQL is interpreted so it can be graphically visualized, either: a) when the query is opened to be edited graphically, or b) when the query is in SQL edit mode, and then switched to be edited graphically. * Fortunately the bug is not when the query is saved, but only when it is opened for edit in GUI mode. So at least there is a way to inspect and fix the design each time before it is saved.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>