Bug 80916 - EDITING: quotes get around the whole expression after it is entered
Summary: EDITING: quotes get around the whole expression after it is entered
Status: RESOLVED DUPLICATE of bug 82427
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.2.5.2 release
Hardware: x86 (IA32) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-07-04 14:52 UTC by johnnak12
Modified: 2014-08-16 02:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 ***