Details
-
Bug
-
Resolution: Fixed
-
P2: Important
-
5.15.8
-
Win 10, MySQL version 8.0.26, 8.0.28
-
9d27c07e2 (dev), d2b6c2f7e (tqtc/lts-6.2), 1bf394a4c (tqtc/lts-5.15), 5ed99a42a (6.4)
Description
Using prepared statements with a table that contains JSON type doesn't seem to work. While QSqlQuery prepare call itself returns "true" and subsequent exec call also succeeds the result will not contain any rows whatsoever. If the query is executed directly the problem does not occur. Also as soon as the JSON is removed from the table the prepared statements start working.
Steps to reproduce the problem:
- set up a table in database (check the attached .sql)
- fill in the hostname, dbname etc
- run the attached project => (using prepared statement) no results or errors printed out
- run the attached project with "-w" => (using just exec) results found and printed out
Attachments
Issue Links
- resulted in
-
QTBUG-109832 QMYSQL plugin no longer works with older supported versions of MySQL/MariaDB
- Closed