Details
-
Bug
-
Resolution: Done
-
P2: Important
-
5.6.0
-
Ubuntu 16.04 with both libmysqlclient.so.16 and libmysqlclient.so.20 installed.
Description
In my application I have a MySql database table that models a boolean as a tinyint(1).
If I use QSqlQuery::exec(mySqlStatement) then QSqlQuery::record() returns a record where QSqlRecord::value(index) returns a QVariant(bool) for such tiniyint(1) columns.
But if I use QSqlQuery::exec() on a prepared statement (QSqlQuery::prepare(mySqlStatement)) then QSqlRecord::value(index) returns a QVariant(char) instead.
This bug is new to Qt 5.6. I tested it with QT 5.4.2 and Qt 5.5.1 (without changing anything but the Qt version).
Attachments
Issue Links
- is duplicated by
-
QTBUG-55153 QSqlQuery no results when using TINYINT
-
- Closed
-
For Gerrit Dashboard: QTBUG-53397 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
168748,2 | Never return char variants when reading prepared MySQL statements | 5.6 | qt/qtbase | Status: MERGED | +2 | 0 |