You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Yaroslav Molochkov (Jira)" <ji...@apache.org> on 2020/11/30 14:14:00 UTC
[jira] [Updated] (IGNITE-12126) ODBC: SQLNumResultCols for prepared
statement
[ https://issues.apache.org/jira/browse/IGNITE-12126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yaroslav Molochkov updated IGNITE-12126:
----------------------------------------
Fix Version/s: (was: 2.9.1)
2.10
> 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
> Fix For: 2.10
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> 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)