Re: Prepared statements (server) return no results, client statements work

[Bogdan Degtyariov]

Hi Graham,

The issue you have described looks like a bug in the ODBC Driver.
It might have something to do with the way the names are quoted with the double-quote symbol:

select * from "USERS" ...

rather than using the twig ` symbol

select * from `USERS` ...


The ODBC driver does not allow controlling of client_deprecate_eof function using any connection options. It uses the default value. I doubt it has anything to do with the issue.

Like indicated above, it must be the quotation symbol.
You mentioned that with "Prepare statements on client" enabled the result consisted of just one row. Was that the expected result or there should be more rows?

The option for preparing statements on the client side is mostly for keeping the compatibility with the older versions of MySQL Server.

Regardless of whether it works with the twig ` quotation or not this issue looks like a bug. Please report it here:

https://bugs.mysql.com/report.php

A short test program (C/C++/VB) or something to help reproduce the issue would be greatly appreciated.
Thanks.