Re: ROW_COUNT() returns 0 on INSERT with MySQL ODBC 8.0.12

[Robert Jacob]

We have the same issue and I tested this with 8.0.12 and 8.0.13. Since there was no 8.0.11 32bit driver I can't say if that worked in 8, but it did work in 5.x releases - we kind of had a longer development break for MySQL platforms.

A code example:
--Constant Parameters(44908)
SELECT row_count(),application_option_id,create_time,create_user,modify_time,modify_user,timestamp
FROM g_application_option_5
WHERE application_option_id = ?
-- - - - - - - - - - - - - - - - - - - -
::SQLExecDirect()
Fetching(1)
GetData()
Values(0,44908,'2018-10-24 07:21:28.112',733,'2018-10-24 07:21:28.112',733,20181024072128)


The ODBC option does not make a difference here, we tested this too.