MySQL Forums
Forum List  »  Connector/ODBC

Re: Prepared statements (server) return no results, client statements work
Posted by: Bogdan Degtyariov
Date: January 10, 2019 02:41AM

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:

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

Options: ReplyQuote

Written By
Re: Prepared statements (server) return no results, client statements work
January 10, 2019 02:41AM

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.