[prev in list] [next in list] [prev in thread] [next in thread]
List: kde-bugs-dist
Subject: [kexi] [Bug 358636] <SELECT "a" + "b"> SQL queries don't work
From: Jarosław Staniek via KDE Bugzilla <bugzilla_noreply () k
Date: 2016-02-29 23:21:26
Message-ID: bug-358636-17878-kPBUnG7BLM () http ! bugs ! kde ! org/
[Download RAW message or body]
https://bugs.kde.org/show_bug.cgi?id=358636
Jarosław Staniek <staniek@kde.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Latest Commit|http://commits.kde.org/call |http://commits.kde.org/kdb/
|igra/2bb05472bca81d13565cf9 |f19ae68c17822b33097119974b2
|501ae04589d38e00a4 |ee01c0b93c534
Status|CLOSED |RESOLVED
--- Comment #3 from Jarosław Staniek <staniek@kde.org> ---
Git commit f19ae68c17822b33097119974b2ee01c0b93c534 by Jaroslaw Staniek.
Committed on 29/02/2016 at 23:16.
Pushed by staniek into branch 'master'.
Make <SELECT "a" + "b"> SQL queries work and fix <SELECT "a" || "b">
Summary:
- port from calligra.git
- <SELECT "a" + "b"> parses in Kexi>=2.9.7 but results in invalid (boolean)
type/value
- for convenience, if either argument is of text type, operator "+" is now
assumed to be identical to operator ||
- also fix SELECT "a" || "b" for MySQL (using CONCAT() is needed)
- add autotests and parser tests
https://phabricator.kde.org/T677
FIXED-IN:2.9.11
Test Plan:
Try test queries from the project attached at
https://bugs.kde.org/show_bug.cgi?id=358636.
Try other queries that use text columns instead of string constants.
Differential Revision: https://phabricator.kde.org/D867
(from calligra.git)
M +9 -2 autotests/ExpressionsTest.cpp
M +11 -0 autotests/parser/data/statements.txt
M +9 -1 src/KDbDriver.cpp
M +12 -1 src/KDbDriver.h
M +9 -1 src/drivers/mysql/MysqlDriver.cpp
M +7 -1 src/drivers/mysql/MysqlDriver.h
M +17 -2 src/expression/KDbBinaryExpression.cpp
M +1 -0 src/expression/KDbExpression.h
http://commits.kde.org/kdb/f19ae68c17822b33097119974b2ee01c0b93c534
--
You are receiving this mail because:
You are watching all bug changes.=
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic