Bug 331615

Summary: Implement BETWEEN..AND operator
Product: [Applications] KEXI Reporter: Barrie Backhurst <barrie.backhurst>
Component: QueriesAssignee: Roman Shtemberko <shtemberko>
Status: CLOSED FIXED    
Severity: wishlist CC: shtemberko, staniek
Priority: NOR Keywords: junior-jobs
Version: 2.7.5   
Target Milestone: 2.9   
Platform: unspecified   
OS: All   
Latest Commit: Version Fixed In: 2.9.0 Beta 2
Bug Depends on:    
Bug Blocks: 341736    

Description Barrie Backhurst 2014-02-28 14:08:29 UTC
The BETWEEN..AND operator is available in MSAccess, therefore it would improve parity and provide a more familiar user experience if implemented in Kexi

Reproducible: Always
Comment 1 Jarosław Staniek 2014-12-10 12:29:57 UTC
Added related wish https://bugs.kde.org/show_bug.cgi?id=341736
Comment 2 Roman Shtemberko 2014-12-15 11:24:18 UTC
Git commit 4a9827b1e52157fcefb700161ac80d4449be7ef1 by Roman Shtemberko.
Committed on 15/12/2014 at 11:22.
Pushed by rshtemberko into branch 'calligra/2.9'.

Added 'BETWEEN...AND' SQL operator support in kexi queries.

REVIEW:121428

M  +60   -2    libs/db/expression.cpp
M  +4    -0    libs/db/expression.h
M  +884  -1048 libs/db/parser/sqlparser.cpp
M  +79   -93   libs/db/parser/sqlparser.h
M  +8    -0    libs/db/parser/sqlparser.y
M  +224  -194  libs/db/parser/sqlscanner.cpp
M  +5    -0    libs/db/parser/sqlscanner.l
M  +1    -0    libs/db/parser/tokens.cpp

http://commits.kde.org/calligra/4a9827b1e52157fcefb700161ac80d4449be7ef1
Comment 3 Roman Shtemberko 2014-12-15 17:59:05 UTC
Git commit 42ac22a7ee184d0e0ee1d248ab95e39df41bdd45 by Roman Shtemberko.
Committed on 15/12/2014 at 17:58.
Pushed by rshtemberko into branch 'calligra/2.9'.

Added 'BETWEEN...AND' SQL operator support in kexi queries.

REVIEW:121428

M  +8    -2    libs/db/expression.cpp
M  +1    -0    libs/db/expression.h
M  +877  -1043 libs/db/parser/sqlparser.cpp
M  +80   -94   libs/db/parser/sqlparser.h
M  +8    -0    libs/db/parser/sqlparser.y
M  +214  -184  libs/db/parser/sqlscanner.cpp
M  +5    -0    libs/db/parser/sqlscanner.l

http://commits.kde.org/calligra/42ac22a7ee184d0e0ee1d248ab95e39df41bdd45
Comment 4 Jarosław Staniek 2014-12-15 18:34:09 UTC
For the record, the last commit relates to 'NOT BETWEEN...AND'.

Closing.