You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Abhay (Jira)" <ji...@apache.org> on 2020/09/23 13:55:00 UTC

[jira] [Created] (IGNITE-13480) Issue in SQLGetData when deleting binary data

Abhay created IGNITE-13480:
------------------------------

             Summary: Issue in SQLGetData when deleting binary data 
                 Key: IGNITE-13480
                 URL: https://issues.apache.org/jira/browse/IGNITE-13480
             Project: Ignite
          Issue Type: Bug
          Components: odbc
    Affects Versions: 2.8.1
            Reporter: Abhay


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}}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)