ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "AH (Jira)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-12126) ODBC: SQLNumResultCols for prepared statement
Date Fri, 30 Aug 2019 06:21:00 GMT
AH created IGNITE-12126:
---------------------------

             Summary: ODBC: SQLNumResultCols for prepared statement
                 Key: IGNITE-12126
                 URL: https://issues.apache.org/jira/browse/IGNITE-12126
             Project: Ignite
          Issue Type: Bug
          Components: odbc
    Affects Versions: 2.7.5
         Environment: Windows 7
            Reporter: AH


According to ODBC Programmer's Reference, SQLNumResultCols can be called successfully only
when the statement is in the prepared, executed, or positioned state.
However, it is not working when the statement is in the prepared state and not yet executed:
column count returned is 0.

 

Full Connect(Default)

Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3

Successfully connected to DSN 'Apache Ignite DSN'.
SQLExecDirect:
 In: Statementhandle = 0x005C3828, 
 StatementText = "SELECT * FROM M.I where 1 = 0", Statementlength = 37
 Return: SQL_SUCCESS=0
SQLNumResultCols:
 In: StatementHandle = 0x005C3828, ColumnCountPtr = 0x0061EDC8
 Return: SQL_SUCCESS=0
 Out: *ColumnCountPtr = 20


SQLPrepare:
 In: StatementHandle = 0x005C3828, 
 StatementText = "SELECT * FROM M.I where 1 = 0", TextLength = 37
 Return: SQL_SUCCESS=0
SQLExecute:
 In: StatementHandle = 0x005C3828
 Return: SQL_SUCCESS=0
SQLNumResultCols:
 In: StatementHandle = 0x005C3828, ColumnCountPtr = 0x0061EDC8
 Return: SQL_SUCCESS=0
 Out: *ColumnCountPtr = 20

 

Not working:

SQLPrepare:
 In: StatementHandle = 0x005C3828, 
 StatementText = "SELECT * FROM M.I where 1 = 0", TextLength = 37
 Return: SQL_SUCCESS=0
SQLNumResultCols:
 In: StatementHandle = 0x005C3828, ColumnCountPtr = 0x0061EDC8
 Return: SQL_SUCCESS=0
 Out: *ColumnCountPtr = 0



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

Mime
View raw message