aws / aws/amazon-redshift-odbc-driver

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

Open
#4 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.