[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-01-29 19:48:41
Message-ID: bug-358636-17878-F5IB94UoBE () 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
                   |                            |igra/2bb05472bca81d13565cf9
                   |                            |501ae04589d38e00a4
         Resolution|---                         |FIXED
             Status|ASSIGNED                    |RESOLVED
   Version Fixed In|                            |2.9.11

--- Comment #2 from Jarosław Staniek <staniek@kde.org> ---
Git commit 2bb05472bca81d13565cf9501ae04589d38e00a4 by Jaroslaw Staniek.
Committed on 29/01/2016 at 19:43.
Pushed by staniek into branch 'calligra/2.9'.

Kexi: Make <SELECT "a" + "b"> SQL queries work and fix <SELECT "a" || "b">

Summary:
- <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)

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.

Reviewers: piggz, wicik

Subscribers: Kexi-Devel-list

Projects: #kexi, #calligra:_3.0

Differential Revision: https://phabricator.kde.org/D867

M  +7    -2    kexi/kexidb/drivers/mysql/mysqldriver.cpp
M  +6    -1    kexi/kexidb/drivers/mysql/mysqldriver.h
M  +6    -1    libs/db/driver.cpp
M  +10   -1    libs/db/driver.h
M  +20   -2    libs/db/expression.cpp

http://commits.kde.org/calligra/2bb05472bca81d13565cf9501ae04589d38e00a4

-- 
You are receiving this mail because:
You are watching all bug changes.=
[prev in list] [next in list] [prev in thread] [next in thread]