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)

Reply via email to