joao-p-pereira opened a new issue, #36912: URL: https://github.com/apache/arrow/issues/36912
### Describe the bug, including details regarding any error messages, version, and platform. When reading the result of a query that returns more than one RecordBatch, if it encounters an empty one, it appears to stop the reading process. However, in reality, there is still data present in the subsequent record batches. We tested this behavior using the driver with SQuirreL SQL Client and a Java program, and the result was the same. We have an internal Flight SQL command-line client built in Rust, which allows us to validate this observation. When we run the example query below, we can see that there are empty RecordBatches, but there are subsequent RecordBatches that contain data. ``` > query "select city from csv1 union select city from csv3" +------+ | city | +------+ +------+ +------+ | city | +------+ +------+ +------+ | city | +------+ +------+ +------+ | city | +------+ +------+ +------+ | city | +------+ +------+ +-------+ | city | +-------+ | Porto | +-------+ +--------+ | city | +--------+ | Lisboa | +--------+ +------+ | city | +------+ +------+ ``` Version: flight-sql-jdbc-driver version 11.0.0 ### Component(s) Java -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
