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/12/02 15:37:00 UTC
[jira] [Commented] (IGNITE-13793) ODBC: Implement SQLRowCount for select queries

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

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

{panel:title=Branch: [pull/8525/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/8525/head] Base: [master] : New Tests (1924)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Platform C++ (Win x64 / Debug){color} [[tests 949|https://ci.ignite.apache.org/viewLog.html?buildId=5770873]]
* {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 938 new tests

{color:#00008b}Platform C++ CMake (Win x64 / Debug){color} [[tests 971|https://ci.ignite.apache.org/viewLog.html?buildId=5770880]]
* {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 960 new tests

{color:#00008b}Platform C++ CMake (Linux){color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=5770879]]
* {color:#013220}IgniteOdbcTest: QueriesTestSuite: TestAffectedRowsOnSelect - PASSED{color}

{color:#00008b}Platform C++ (Win x64 / Release){color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=5770874]]
* {color:#013220}IgniteOdbcTest: QueriesTestSuite: TestAffectedRowsOnSelect - PASSED{color}

{color:#00008b}Platform C++ CMake (Linux Clang){color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=5770878]]
* {color:#013220}IgniteOdbcTest: QueriesTestSuite: TestAffectedRowsOnSelect - PASSED{color}

{color:#00008b}Platform C++ CMake (Win x64 / Release){color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=5770881]]
* {color:#013220}IgniteOdbcTest: QueriesTestSuite: TestAffectedRowsOnSelect - PASSED{color}

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

> ODBC: Implement SQLRowCount for select queries
> ----------------------------------------------
>
>                 Key: IGNITE-13793
>                 URL: https://issues.apache.org/jira/browse/IGNITE-13793
>             Project: Ignite
>          Issue Type: Improvement
>          Components: odbc
>    Affects Versions: 2.9
>            Reporter: Igor Sapego
>            Assignee: Igor Sapego
>            Priority: Major
>             Fix For: 2.10
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> SQLRowCount() should return estimation of row count of the query. Currently, we can not provide any estimations of this kind, but we still need to implement this function as sometimes some third-party software uses it. It is proposed to use some kind of constant value, e.g. page size.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)