[IGNITE-13480] Issue in SQLGetData when deleting binary data

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.8.1
• Component/s: odbc
• Assignee: Unassigned
• Reporter: Abhay
• Created: 23/Sep/20 13:54
• Updated: 16/Jan/21 09:06

Description

When we select a large value in ODBC and column type is varchar then we get the response like this 

[SQLGetData.c][237][SQLGetData.c][237] Entry: Statement = 0x1bc9d90 Column Number = 1 Target Type = -2 SQL_C_BINARY Buffer Length = 4096 Target Value = 0x1bc1480 StrLen Or Ind = 0x7fffda3c96c0

[ODBC][722][1600757419.094829][SQLGetData.c][534] Exit:[SQL_SUCCESS]                 Buffer = [BINARYDATA...]                 Strlen Or Ind = 0x7fffda3c96c0 -> 4096

wherein it sends response as SQL_SUCCESS and strlen_or_ind as our buffer size = 4096 and not SQL_SUCCESS_WITH_INFO and correct size in strlen_or_ind whereas in MS SQL server it shows like this 

 

{{[ODBC][2254][1600867369.318414][SQLGetData.c][237]
Entry:
Statement = 0x1a771d0
Column Number = 1
Target Type = -2 SQL_C_BINARY
Buffer Length = 4096
Target Value = 0x1a90d00
StrLen Or Ind = 0x7fff0908ece0
[ODBC][2254][1600867369.318866][SQLGetData.c][545]
Exit:[SQL_SUCCESS_WITH_INFO]
Buffer = [BINARYDATA...]
Strlen Or Ind = 0x7fff0908ece0 -> 11936}}