[Kexi-devel] [Differential] [Request, 56 lines] D867: Kexi: Make <SELECT "a" + "b"> SQL queries work and fix <SELECT "a" || "b">

[staniek (Jarosław Staniek)]

staniek created this revision.
staniek added reviewers: piggz, wicik.
staniek added a subscriber: Kexi-Devel-list.
Herald added projects: Kexi, Calligra: 3.0.

REVISION 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
  BUG:358636
  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.

REPOSITORY
  rCALLIGRA Calligra

BRANCH
  calligra/2.9

REVISION DETAIL
  https://phabricator.kde.org/D867

AFFECTED FILES
  kexi/kexidb/drivers/mysql/mysqldriver.cpp
  kexi/kexidb/drivers/mysql/mysqldriver.h
  libs/db/driver.cpp
  libs/db/driver.h
  libs/db/expression.cpp

EMAIL PREFERENCES
  https://phabricator.kde.org/settings/panel/emailpreferences/

To: staniek, piggz, wicik
Cc: Kexi-Devel-list, staniek