https://bugs.documentfoundation.org/show_bug.cgi?id=172981
Bug ID: 172981
Summary: QUERIES: Switching from sql view to design view and
back some functions give an error
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 207965
--> https://bugs.documentfoundation.org/attachment.cgi?id=207965&action=edit
Open queries in SQL view. Switch to design view and try to get back to SQL
view.
Open the attached HSQLDB database. There is only one example table and many
examples of queries. Queries would only differ in functions, which are used.
Example:
SELECT "ID", "Forename", "Surname", "Birthdate", "Height", "Class" FROM
"tbl_Person" WHERE LOWER("Surname") LIKE '%a%'
When opening this query in SQL view and turning to design view it works well.
Switching back to design view is impossible. It gives an error:
SQL Status: S1000
Error code: 1000
SQL syntax error
Same query with function LCASE instead of LOWER will work well.
Have only tested many function for string content with HSQLDB. Will try to
expand the example database to see which functions will work / won't work.
Expected behavior: All content, which could be shown in design view well,
should be executed well in design view.
--
You are receiving this mail because:
You are the assignee for the bug.
