Bug 341736 - Implement NOT BETWEEN..AND operator
Summary: Implement NOT BETWEEN..AND operator
Status: CLOSED FIXED
Alias: None
Product: KEXI
Classification: Applications
Component: Queries (show other bugs)
Version: 2.9 Alpha
Platform: unspecified All
: LO wishlist
Target Milestone: 2.9
Assignee: Roman Shtemberko
URL:
Keywords: junior-jobs
Depends on: 331615
Blocks:
  Show dependency tree / graph
 
Reported: 2014-12-10 12:27 UTC by Jarosław Staniek
Modified: 2014-12-15 18:35 UTC (History)
5 users (show)

See Also:
Latest Commit:
Version Fixed In: 2.9.0 Beta 2

Attachments
Add an attachment

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