From kde-bugs-dist  Mon Feb 29 23:21:26 2016
From: =?UTF-8?Q?Jaros=C5=82aw=20Staniek=20via=20KDE=20Bugzilla=20?=<bugzilla_noreply () k
Date: Mon, 29 Feb 2016 23:21:26 +0000
To: kde-bugs-dist
Subject: [kexi] [Bug 358636] <SELECT "a" + "b"> SQL queries don't work
Message-Id: <bug-358636-17878-kPBUnG7BLM () http ! bugs ! kde ! org/>
X-MARC-Message: https://marc.info/?l=kde-bugs-dist&m=145678809929600

https://bugs.kde.org/show_bug.cgi?id=3D358636

Jaros=C5=82aw 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=C5=82aw 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>=3D2.9.7 but results in invalid (boolea=
n)
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=3D358636.
    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

--=20
You are receiving this mail because:
You are watching all bug changes.=