aws / aws/amazon-redshift-odbc-driver
Regression. Invalid streaming cursor state. Unable to open 2 SQLHSTMT in the same SQLHDBC when using certain queries
- Dominant language
- C
- Stars
- 25
- Forks
- 17
- PR merge metrics
- No merged PRs in 30d
Description
## 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
3. Actual behaviour: Invalid streaming cursor state
4. Error message/stack trace: [HY000] [Redshift][ODBC Driver]Invalid streaming cursor state (0)
5. 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](https://github.com/aws/amazon-redshift-odbc-driver/files/10276417/redshift_bug.txt)
Attached test file
Contributor guide
Research direction
Start with the attached redshift_bug.txt reproduction and compare behavior between AmazonRedshiftODBC64-2.0.0.1 and 1.4.62.1000 on Windows/Linux. Reproduce opening two SQLHSTMT statements within one SQLHDBC using the specified queries; done means both statements open and execute without the Invalid streaming cursor state error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- c, postgres, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 32/100