rcprcp opened a new issue, #83:
URL: https://github.com/apache/arrow-java/issues/83

   ### Describe the bug, including details regarding any error messages, 
version, and platform.
   
   Tested on Arrow Flight JDBC 15, 15.02 and with a locally-built Arrow Flight 
SQL JDBC Driver 17.0.0-SNAPSHOT. 
   
   When using a JDBC statement to execute an UPDATE, the getUpdateCount() 
method seems to always return -1.  This seems to be incorrect.  The 
getUpdateCount() should return the number of rows UPDATEd.
   
   For a data source, we're using the [Voltron docker 
container](https://hub.docker.com/r/voltrondata/flight-sql)
   
   In this debugger image, you can see the return counts from the 
getUpdateCount() and from the actual result set (the update returns one row, 
with one column, that indicates the number of UPDATEd rows. 
   
   <img width="1621" alt="Screenshot 2024-05-20 at 14 10 23" 
src="https://github.com/apache/arrow-java/assets/17998205/5189462f-e608-42fb-8996-61c871da6360";>
   
   Here is a screen grab of the output data: 
   <img width="1459" alt="Screenshot 2024-05-20 at 14 11 39" 
src="https://github.com/apache/arrow-java/assets/17998205/61f24a80-ee23-4e98-9bed-a281c233237d";>
   
   And, in this screengrab, I used the Postgres driver to update a table in 
postgres:latest Docker image: 
   <img width="1574" alt="Screenshot 2024-05-07 at 17 30 55" 
src="https://github.com/apache/arrow-java/assets/17998205/bb7dcbfe-370a-4b5d-a1d3-6414e4b3b9ef";>
   
   The data in the Postgres table is different, but the getUpdateCount() method 
returned 1 which is correct for that data. 
   The test program I used is checked into this Github repo:   
[ZD128958](https://github.com/rcprcp/ZD128958)
   
   Thank you!
   
   ### 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: issues-unsubscr...@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to