https://bugs.freedesktop.org/show_bug.cgi?id=82427
Priority: medium
Bug ID: 82427
Assignee: [email protected]
Summary: EDITING: Query design view generates SQL syntax error
on NOT LIKE
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.6.2 release
Component: Database
Product: LibreOffice
Created attachment 104389
--> https://bugs.freedesktop.org/attachment.cgi?id=104389&action=edit
Query editor screenshot before editing criterion
I have a simple query on one (MySQL 5.1) table:
SELECT `District`, `AppNumber`, `Added`, `Parish`, `Address`, `Postcode`,
`Proposal`, `KeyWords`, `Validated` FROM `planningApps`.`applications` AS
`applications` WHERE `KeyWords` LIKE '%L%' AND NOT `KeyWords` LIKE '%X%'
It runs as expected from the query list and from SQL view (from which the above
text is copied). Also works from SQL view with the more normal ..... AND
`Keywords` NOT LIKE '%X%'
After viewing in GUI Design View, I cannot run it, save it or view in SQL view
without a SQL syntax error message "Error code: 1000 SQL syntax error". The
problem is around the NOT LIKE - if I edit that criterion by deleting NOT and
pasting it back, base surrounds the whole thing with quotes - 'NOT LIKE
''*X*''' and generates SQL ...AND `Keywords` = 'NOT LIKE ''*X*''' in SQL view.
Works as expected in ooBase.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
