Might still be a problem with the parsing of the batch.
All examples are executed as a single batch:
This does deliver the right results.
This does deliver all the rows from mytable and the 1 at the end. Works.
This does deliver the first result "1" and after that a "AccessViolationException" gets returned.
The first SELECT delivers the right results, but the 2nd SELECT returns only the correct amount of rows but they are empty and trigger a NumberFormatException. Fields with INT datatype do work somehow.
A similar result with data from the information_schema is returned by these queries:
These statements do work with the mysql ODBC driver or executed on their own.