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]

Reply via email to