search

aws / amazon-redshift-odbc-driver

Apache License 2.0
18 stars 7 forks source link

Regression. Invalid streaming cursor state. Unable to open 2 SQLHSTMT in the same SQLHDBC when using certain queries #4

Open rescr1pt opened 1 year ago

rescr1pt commented 1 year ago

Driver version

AmazonRedshiftODBC64-2.0.0.1.msi

Redshift version

PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.44126

Client Operating System

Windows/Linux

Table schema

dev

Problem description

  1. Expected behaviour: Expected to work as described in the API
  2. Actual behaviour: Invalid streaming cursor state
  3. Error message/stack trace: [HY000] [Redshift][ODBC Driver]Invalid streaming cursor state (0)
  4. Any other details that can be helpful:

I had a problem in application using this version of the driver. I wrote a simple test to simplify the reproduction. This is a regression problem, in the old version of the "AmazonRedshiftODBC64-1.4.62.1000" driver works fine. Reproduction is very simple. Need to open 2 statements with a specific queries within 1 session and the driver breaks.

redshift_bug.txt Attached test file

Brooke-white commented 1 year ago

Hi @rescr1pt , thank you for taking the time to open this issue, my apologies for the delay in response. We really appreciate you providing a reproduction of the issue as it's a big help to our team. I've notified the team of this issue and will update here as more information is available.