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

[Christian David via KDE Bugzilla]

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

Christian David <christian-david at web.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |CONFIRMED

--- Comment #3 from Christian David <christian-david at web.de> ---
This bug is caused by mymoneydbdef.cpp, line 221. There I used “order” as
column name. This is okay if the identifier is quoted. Unfortunately the way of
quoting it is different between the databases (e.g.
https://www.postgresql.org/docs/7.3/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
vs https://dev.mysql.com/doc/refman/5.7/en/identifiers.html). I did not know
that :(

It should be safe to rename the identifier as we do not really use it, yet.
Alternatively we could adopt our query creator to this. However, I think this
is too much work for a minor benefit.

There is another case of this issue in line 162. If someone is working an this
bug, please assign it to yourself.

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