Bug report #13938

Extra space in "IS NOT" operator makes the expression return wrong selection

Added by Giovanni Manghi over 1 year ago. Updated about 1 year ago.

Status:Closed Start Date:12/02/2015
Priority:Normal Due date:
Assigned to:- % Done:

0%

Category:Expressions
Target version:-
Platform: Pull Request or Patch supplied:No
Platform version: Affected version:2.8.3
Status info: Causes crash or corruption:No
Resolution: Tag:

Description

Description to follow.

Associated revisions

Revision 5d989abd6fbce0b95282aa5d4c6185d145570620
Added by Jürgen Fischer about 1 year ago

fix parsing of IS NOT and NOT LIKE, NOT ILIKE and dumping of IS (NOT ...) (fixes #13938)

History

Updated by Nyall Dawson over 1 year ago

  • Status changed from Open to Feedback

Setting to feedback just in case the extra detail doesn't come ;)

Updated by Sebastian Dietrich over 1 year ago

@Giovanni Manghi:
Good catch!

If I may add the extra detail here:

1 IS NOT 2
evaluates to 1
1 IS  NOT 2
evaluates to 0
1 IS (NOT 2)
evaluates to 0, too

Updated by Giovanni Manghi over 1 year ago

  • Status changed from Feedback to Open

that's it.

Updated by Jürgen Fischer about 1 year ago

  • Status changed from Open to Closed

Also available in: Atom