[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kmymoney-devel
Subject:    [kmymoney4] [Bug 365615] SQL syntax error reported opening MySQL database
From:       Christian David via KDE Bugzilla <bugzilla_noreply () kde ! org>
Date:       2016-07-31 9:41:29
Message-ID: bug-365615-123840-TEL2pOGE7M () http ! bugs ! kde ! org/
[Download RAW message or body]

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

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

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

--- Comment #3 from Christian David <christian-david@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.=
[prev in list] [next in list] [prev in thread] [next in thread]