You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2020/11/10 20:23:00 UTC
[jira] [Commented] (IGNITE-12126) ODBC: SQLNumResultCols for prepared statement

    [ https://issues.apache.org/jira/browse/IGNITE-12126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17229501#comment-17229501 ] 

Ignite TC Bot commented on IGNITE-12126:
----------------------------------------

{panel:title=Branch: [pull/8404/head] Base: [master] : Possible Blockers (3)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Platform C++ CMake (Win x64 / Debug){color} [[tests 1 BuildFailureOnMessage |https://ci.ignite.apache.org/viewLog.html?buildId=5728239]]
* IgniteOdbcTest: ConnectionTestSuite: TestConnectionRestore - New test duration 67s is more that 1 minute

{color:#d04437}Platform C++ (Win x64 / Debug){color} [[tests 0 BuildFailureOnMessage |https://ci.ignite.apache.org/viewLog.html?buildId=5728241]]

{panel}
{panel:title=Branch: [pull/8404/head] Base: [master] : New Tests (1900)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Platform C++ CMake (Win x64 / Debug){color} [[tests 953|https://ci.ignite.apache.org/viewLog.html?buildId=5728239]]
* {color:#013220}IgniteOdbcTest: SqlNumericFunctionTestSuite: TestNumericFunctionFloor - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlNumericFunctionTestSuite: TestNumericFunctionLog - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlDateTimeFunctionTestSuite: TestCurrentDate - PASSED{color}
* {color:#013220}IgniteCoreTest: ClusterTestSuite: IgniteForCacheNodes - PASSED{color}
* {color:#013220}IgniteCoreTest: ClusterTestSuite: IgniteForClientNodes - PASSED{color}
* {color:#013220}IgniteCoreTest: CacheQueryTestSuite: TestFieldsQueryByteArrayInsertSelect - PASSED{color}
* {color:#013220}IgniteCoreTest: ClusterTestSuite: IgniteForDaemons - PASSED{color}
* {color:#013220}IgniteCoreTest: ClusterTestSuite: IgniteForHost - PASSED{color}
* {color:#013220}IgniteCoreTest: ClusterTestSuite: IgniteForOldest - PASSED{color}
* {color:#013220}IgniteCoreTest: ContinuousQueryTestSuite: TestBasic - PASSED{color}
* {color:#013220}IgniteCoreTest: ClusterTestSuite: IgniteForRandom - PASSED{color}
... and 942 new tests

{color:#00008b}Platform C++ (Win x64 / Debug){color} [[tests 931|https://ci.ignite.apache.org/viewLog.html?buildId=5728241]]
* {color:#013220}IgniteOdbcTest: SqlNumericFunctionTestSuite: TestNumericFunctionFloor - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlNumericFunctionTestSuite: TestNumericFunctionLog - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlDateTimeFunctionTestSuite: TestCurrentDate - PASSED{color}
* {color:#013220}IgniteCoreTest: CacheQueryTestSuite: TestFieldsQueryByteArrayInsertSelect - PASSED{color}
* {color:#013220}IgniteCoreTest: ContinuousQueryTestSuite: TestBasic - PASSED{color}
* {color:#013220}IgniteCoreTest: ContinuousQueryTestSuite: TestInitialQueryScan - PASSED{color}
* {color:#013220}IgniteOdbcTest: ApiRobustnessTestSuite: TestSQLGetStmtAttr - PASSED{color}
* {color:#013220}IgniteOdbcTest: ApplicationDataBufferTestSuite: TestPutStringToLong - PASSED{color}
* {color:#013220}IgniteCoreTest: ContinuousQueryTestSuite: TestInitialQuerySql - PASSED{color}
* {color:#013220}IgniteOdbcTest: ApplicationDataBufferTestSuite: TestPutStringToTiny - PASSED{color}
* {color:#013220}IgniteCoreTest: ContinuousQueryTestSuite: TestInitialQueryText - PASSED{color}
... and 920 new tests

{color:#00008b}Platform C++ (Win x64 / Release){color} [[tests 4|https://ci.ignite.apache.org/viewLog.html?buildId=5728243]]
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnScalePrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestSQLNumResultColsAfterSQLPrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnLengthPrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnPresicionPrepare - PASSED{color}

{color:#00008b}Platform C++ CMake (Win x64 / Release){color} [[tests 4|https://ci.ignite.apache.org/viewLog.html?buildId=5728245]]
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnScalePrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestSQLNumResultColsAfterSQLPrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnLengthPrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnPresicionPrepare - PASSED{color}

{color:#00008b}Platform C++ CMake (Linux){color} [[tests 4|https://ci.ignite.apache.org/viewLog.html?buildId=5699701]]
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnScalePrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestSQLNumResultColsAfterSQLPrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnLengthPrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnPresicionPrepare - PASSED{color}

{color:#00008b}Platform C++ CMake (Linux Clang){color} [[tests 4|https://ci.ignite.apache.org/viewLog.html?buildId=5699700]]
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnScalePrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestSQLNumResultColsAfterSQLPrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnLengthPrepare - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestColAttributesColumnPresicionPrepare - PASSED{color}

{panel}
[TeamCity *-&gt; Run :: CPP* Results|https://ci.ignite.apache.org/viewLog.html?buildId=5699704&amp;buildTypeId=IgniteTests24Java8_RunCpp]

> 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
>          Time Spent: 10m
>  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)