Bug 80916

Summary: EDITING: quotes get around the whole expression after it is entered
Product: LibreOffice Reporter: johnnak12
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: lo_bugs
Priority: medium    
Version: 4.2.5.2 release   
Hardware: x86 (IA32)   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description johnnak12 2014-07-04 14:52:57 UTC
Entering a criteria in the query GUI using NOT LIKE:

if a criteria such as: not like '*a*' is entered in the gui interface,
quotes get put around the whole expression after it is entered.
e.g. 'not like '*a*''

It can be edited in the SQL view and it will work, but when going
back to the gui view, a syntax error message appears.

Using LIKE by itself in a criteria works okay.

This error did not occur in the 4.1.x versions of LibreOffice, but
did start in the 4.2.x versions.
Comment 1 Terrence Enger 2014-08-16 02:21:55 UTC

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