davidhcoe opened a new issue, #1447:
URL: https://github.com/apache/arrow-adbc/issues/1447
For example, while executing multi-statement: “DROP TABLE IF EXISTS
TESTTABLE;CREATE TABLE TESTTABLE(intcol INT);INSERT INTO TESTTABLE VALUES
(123);INSERT INTO TESTTABLE VALUES (456);SELECT * FROM TESTTABLE WHERE
INTCOL=123;SELECT * FROM TESTTABLE WHERE INTCOL=456;SELECT * FROM TESTTABLE
WHERE INTCOL=456;DROP TABLE TESTTABLE;”
We can get a result in AdbcDataReader like this:
“Multiple statements executed successfully.”
Meanwhile, ADO.NET driver or ODBC driver able to get 2 result sets from 2
SELECT queries, like this:
INTCOL
123
INTCOL
456
This capability should be achieved via reader.NextResult() and
reader.Read(), sample code as below:
do
{
while (reader.Read())
{
//read data into result set
}
yield return resultSet;
} while (reader.NextResult());
--
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]