mikeburgh opened a new issue, #47060: URL: https://github.com/apache/doris/issues/47060
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.1.7 ### What's Wrong? If you execute multiple statements in one batch ```sql select 1; select 2; ``` The node drivers (mysql2, mariadb) only return the 2nd select's result. ### What You Expected? Both result sets to be returned. ### How to Reproduce? Run the following nodejs code ```javascript import mysql from "mysql2/promise"; async function main() { // Create the connection to database const connection = await mysql.createConnection({ host: "localhost", port: 9030, user: "root", password: "", database: "mysql", }); // A simple SELECT query try { const [results, fields] = await connection.query(`select 1; select 2;`); console.log(results); // results contains rows returned by server console.log(fields); // fields contains extra meta data about results, if available } catch (err) { console.log(err); } } main(); ``` ### Anything Else? The mysql2 driver outputs the following warnings in the above example: Warning: got packets out of order. Expected 1 but received 5 Warning: got packets out of order. Expected 2 but received 6 Warning: got packets out of order. Expected 3 but received 7 Warning: got packets out of order. Expected 4 but received 8 Warning: got packets out of order. Expected 5 but received 9 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
