[Libreoffice-bugs] [Bug 108375] Query: Clicking 'Switch Design View On/Off' a few times messes up SQL JOINs

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108375

--- Comment #3 from Howard Johnson <BridgeportContractor at gmail.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170728/b212a2be/attachment.html>