Bug 341736

Summary: Implement NOT BETWEEN..AND operator
Product: [Applications] KEXI Reporter: Jarosław Staniek <staniek>
Component: QueriesAssignee: Roman Shtemberko <shtemberko>
Status: CLOSED FIXED    
Severity: wishlist CC: adam, barrie.backhurst, inksi, shtemberko, staniek
Priority: LO Keywords: junior-jobs
Version: 2.9 Alpha   
Target Milestone: 2.9   
Platform: unspecified   
OS: All   
Latest Commit: Version Fixed In: 2.9.0 Beta 2
Sentry Crash Report:
Bug Depends on: 331615    
Bug Blocks:    

Description Jarosław Staniek 2014-12-10 12:27:36 UTC
Following up the "Implement BETWEEN..AND operator" wish https://bugs.kde.org/show_bug.cgi?id=331615, implement NOT BETWEEN..AND operator.
Comment 1 Jarosław Staniek 2014-12-10 12:29:22 UTC
Meaning of "x NOT BETWEEN y AND z" is "NOT (x BETWEEN y AND z)"

Backends, including SQLite, support it out of the box.

Technically, another token is needed, and a parser rule.
Comment 2 Jarosław Staniek 2014-12-15 18:35:47 UTC
Git commit 42ac22a7ee184d0e0ee1d248ab95e39df41bdd45 by Roman Shtemberko. 
Committed on 15/12/2014 at 17:58. 
Pushed by rshtemberko into branch 'calligra/2.9'.