ROW_COUNT() returns 0 on INSERT with MySQL ODBC 8.0.12
Posted by:
Ben Lu
Date: October 02, 2018 11:10AM
I recently switched my application (C++) to use the latest MySQL ODBC connector 8.0.12 from ODBC 3.51. After the switch, I found out that ROW_COUNT() always return 0 on updates. For example, in my application, it inserted a new row to a table (I verified that the row was inserted), then using the same db connection object, it immediately did a "select ROW_COUNT()". The query returned 0 instead of 1. If I switched back to ODBC 3.51 and tried the same thing, it would return 1. I couldn't find any report on this issue. Any insight is greatly appreciated. Thanks!
Subject
Written By
Posted
ROW_COUNT() returns 0 on INSERT with MySQL ODBC 8.0.12
October 02, 2018 11:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.