[kmymoney4] [Bug 365615] SQL syntax error reported opening MySQL database

[Thomas Baumgart via KDE Bugzilla]

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

Thomas Baumgart <thb at net-bembel.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
      Latest Commit|http://commits.kde.org/kmym |http://commits.kde.org/kmym
                   |oney/c0f003134059354e2bc2b1 |oney/20191b3d1b662cd8e0d577
                   |9ffa1b3ca7a98cbb19          |5799ff51a39cd68e47
   Version Fixed In|5.0                         |4.8.1

--- Comment #5 from Thomas Baumgart <thb at net-bembel.de> ---
Git commit 20191b3d1b662cd8e0d5775799ff51a39cd68e47 by Thomas Baumgart.
Committed on 14/08/2016 at 10:16.
Pushed by tbaumgart into branch '4.8'.

Renamed SQL column "order" to "userOrder" in some tables

The name "order" is a reserved keyword. It can be used as identifier
but only if it is escaped. Unfortunately the escape sequence is database
dependent. Added upgrade feature to convert database on open.

Accomplished compatability with DB layout version 10 as used in master.

This has yet been tested against SQLite but not MySQL.
FIXED-IN: 4.8.1

M  +1    -1    kmymoney/mymoney/storage/mymoneydatabasemgrtest.cpp
M  +20   -6    kmymoney/mymoney/storage/mymoneydbdef.cpp
M  +13   -4    kmymoney/mymoney/storage/mymoneydbdef.h
M  +47   -7    kmymoney/mymoney/storage/mymoneystoragesql.cpp
M  +2    -0    kmymoney/mymoney/storage/mymoneystoragesql.h

http://commits.kde.org/kmymoney/20191b3d1b662cd8e0d5775799ff51a39cd68e47

-- 
You are receiving this mail because:
You are the assignee for the bug.