Bug 134108 - Editing Base Query generated in SQL view is messed up in design view
Summary: Editing Base Query generated in SQL view is messed up in design view
Status: RESOLVED DUPLICATE of bug 133997
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-18 12:48 UTC by tj_trevor.jones
Modified: 2020-07-08 10:10 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Original Query in SQL View (116 bytes, text/plain)
2020-06-18 12:49 UTC, tj_trevor.jones 		Details
Query generated in Design View (45.88 KB, image/png)
2020-06-18 12:50 UTC, tj_trevor.jones 		Details
Query I was expecting to find in Design View (27.81 KB, image/png)
2020-06-18 12:51 UTC, tj_trevor.jones 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description tj_trevor.jones 2020-06-18 12:48:07 UTC 
Description:
When switching from SQL view to Design view in the Query editor it took no notice of brackets.

Steps to Reproduce:
1.Click on Create Query in SQL View
2.Create query as oer attached SQLView document.
3.Click on Switch Design View on off
4.Query is presented as in the attached DesignViewActual screen shot

Actual Results:
See screen shot- DesignViewActual

Expected Results:
See screen shot- DesignViewExpected


Reproducible: Always


User Profile Reset: No



Additional Info:
Followed the intention of the SQL by interpreting the brackets
Comment 1 tj_trevor.jones 2020-06-18 12:49:25 UTC 
Created attachment 162155 [details]
Original Query in SQL View
Comment 2 tj_trevor.jones 2020-06-18 12:50:37 UTC 
Created attachment 162156 [details]
Query generated in Design View
Comment 3 tj_trevor.jones 2020-06-18 12:51:23 UTC 
Created attachment 162157 [details]
Query I was expecting to find in Design View
Comment 4 Robert Großkopf 2020-07-03 20:04:47 UTC 
Pleas add an example database for the query created in SQL-view and changed in GUI-Mode to see the difference.

What you espect couldn't be the same as the plain text expressed: 
SELECT * FROM "Table1" WHERE ( ("FieldA" = :AskA OR "FieldA" IS NULL) AND ("FieldB" = :AskB AND "FieldB" IS NULL) )
Inside the first brackets I see 'OR', inside the second brackets I see 'AND'. What you expect is the content with 'OR' in both brackets.

... and this was content of
https://bugs.documentfoundation.org/show_bug.cgi?id=133997
Comment 5 Alex Thurgood 2020-07-07 17:09:25 UTC 
Isn't this a DUP of bug 133997, now closed ?
Comment 6 Robert Großkopf 2020-07-08 10:10:17 UTC 
Think this bug could be closed as a duplicate. The feature-request for this is bug 134049.

*** This bug has been marked as a duplicate of bug 133997 ***