[ https://issues.apache.org/jira/browse/IGNITE-12126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Igor Sapego reassigned IGNITE-12126: ------------------------------------ Assignee: Igor Sapego > 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 > Assignee: Igor Sapego > Priority: Major > > 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.4#803005)