[Libreoffice-bugs] [Bug 60217] error message limited to a dot when mysql native connector is used

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=60217

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |serval2412 at yahoo.fr

--- Comment #14 from Julien Nabet <serval2412 at yahoo.fr> ---
Here's part of the bt of the root cause:
#0  0x00007fffc0031145 in sql::SQLString::SQLString(char const*)
(this=0x7fffffff0aa0, other=0x55555892c0a7 "")
    at
/home/julien/lo/libreoffice/workdir/UnpackedTarball/mysql-connector-cpp/cppconn/sqlstring.h:57
#1  0x00007fffc009b1ae in
sql::mysql::NativeAPI::MySQL_NativeConnectionWrapper::error()
(this=0x55555892bfc0)
    at
/home/julien/lo/libreoffice/workdir/UnpackedTarball/mysql-connector-cpp/driver/nativeapi/mysql_native_connection_wrapper.cpp:149
#2  0x00007fffc0096986 in
sql::mysql::util::throwSQLException(sql::mysql::NativeAPI::NativeConnectionWrapper&)
(proxy=...)
    at
/home/julien/lo/libreoffice/workdir/UnpackedTarball/mysql-connector-cpp/driver/mysql_util.cpp:51
#3  0x00007fffc0093e0f in sql::mysql::MySQL_Statement::get_resultset()
(this=0x555558a189c0)
    at
/home/julien/lo/libreoffice/workdir/UnpackedTarball/mysql-connector-cpp/driver/mysql_statement.cpp:113
#4  0x00007fffc009423a in
sql::mysql::MySQL_Statement::executeQuery(sql::SQLString const&)
(this=0x555558a189c0, sql=...)
    at
/home/julien/lo/libreoffice/workdir/UnpackedTarball/mysql-connector-cpp/driver/mysql_statement.cpp:166
#5  0x00007fffc059afd5 in
connectivity::mysqlc::OCommonStatement::executeQuery(rtl::OUString const&)
(this=0x5555581b6810, sql="DELETE FROM test")
    at /home/julien/lo/libreoffice/mysqlc/source/mysqlc_statement.cxx:151
#6  0x00007fffca9d5572 in OStatement::executeQuery(rtl::OUString const&)
(this=0x555558a21de0, _rSQL="DELETE FROM test")
    at /home/julien/lo/libreoffice/dbaccess/source/core/api/statement.cxx:453


Since Mysql connector doesn't indicate an error, I wonder if we shouldn't test
the query in mysqlc_statement.cxx to check if it contains a "select type" only
(or perhaps it'd be simpler to check it doesn't contain update or delete).
I suppose since these keywords may be included in some table names, we should
use a parser.(I don't know how to do it but hope there may be something
simpler).
May https://gerrit.libreoffice.org/#/c/55960/ change things here?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180623/e9e54e52/attachment.html>