content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
Content-Length: 978

Hello,
    I found that Bind can not use procedure in MySQL dlz driver. I have
checked the code of MySQL drivers. Due the procedure will always attach a
extra result set which is used to indicate the procedure status. And The
driver of Bind dlz just always fetch one result set from MySQL, so the
fellow instruction can not be execute with a "Commands out of sync" error.
    In order to fix this problem, we should use "mysql_next_result" to skip
this useless extra result. I will attach the related webpage of this issue
below.

Sincerely


[1]https://bugs.mysql.com/bug.php?id=71044
[2]
https://stackoverflow.com/questions/17115919/mysql-commands-out-of-sync-error-c-connector
[3]
https://stackoverflow.com/questions/29220713/c-mysql-connector-error-2014-commands-out-of-sync-when-using-call
[4]
https://www.linuxquestions.org/questions/linux-server-73/can-bind-dlz-work-with-the-mysql-stored-procedure-857719/
[5]https://sourceforge.net/p/bind-dlz/mailman/message/31133579/