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/12 21:12:00 UTC
[jira] [Commented] (IGNITE-13636) ODBC driver assigns SQL_BINARY type to DATE fields

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

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

{panel:title=Branch: [pull/8453/head] Base: [master] : Possible Blockers (2)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Platform C++ (Win x64 / Debug){color} [[tests 2|https://ci.ignite.apache.org/viewLog.html?buildId=5731476]]
* IgniteCoreTest: CacheTestSuite: TestRemoveAllKeys - History for base branch is absent.
* IgniteOdbcTest: ApiRobustnessTestSuite: TestSQLDriverConnect - New test duration 100s is more that 1 minute

{panel}
{panel:title=Branch: [pull/8453/head] Base: [master] : New Tests (1982)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Platform C++ (Win x64 / Debug){color} [[tests 948|https://ci.ignite.apache.org/viewLog.html?buildId=5731476]]
* {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 937 new tests

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

{color:#00008b}Platform C++ (Win x64 / Release){color} [[tests 16|https://ci.ignite.apache.org/viewLog.html?buildId=5731477]]
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeCurdate - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsIs - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralDateLegacy - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralDate - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsDateLegacy - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsDate - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeLiteral - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestTimeTypeColumnAttributeLiteral - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeField - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralTime - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestTimeTypeColumnAttributeField - PASSED{color}
... and 5 new tests

{color:#00008b}Platform C++ CMake (Win x64 / Release){color} [[tests 16|https://ci.ignite.apache.org/viewLog.html?buildId=5731484]]
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeCurdate - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsIs - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralDateLegacy - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralDate - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsDateLegacy - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsDate - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeLiteral - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestTimeTypeColumnAttributeLiteral - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeField - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralTime - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestTimeTypeColumnAttributeField - PASSED{color}
... and 5 new tests

{color:#00008b}Platform C++ CMake (Linux){color} [[tests 16|https://ci.ignite.apache.org/viewLog.html?buildId=5731482]]
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeCurdate - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsIs - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralDateLegacy - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralDate - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsDateLegacy - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsDate - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeLiteral - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestTimeTypeColumnAttributeLiteral - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeField - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralTime - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestTimeTypeColumnAttributeField - PASSED{color}
... and 5 new tests

{color:#00008b}Platform C++ CMake (Linux Clang){color} [[tests 16|https://ci.ignite.apache.org/viewLog.html?buildId=5731481]]
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeCurdate - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsIs - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralDateLegacy - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralDate - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsDateLegacy - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchFieldDateAsDate - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeLiteral - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestTimeTypeColumnAttributeLiteral - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestDateTypeColumnAttributeField - PASSED{color}
* {color:#013220}IgniteOdbcTest: SqlTypesTestSuite: TestFetchLiteralTime - PASSED{color}
* {color:#013220}IgniteOdbcTest: MetaQueriesTestSuite: TestTimeTypeColumnAttributeField - PASSED{color}
... and 5 new tests

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

> ODBC driver assigns SQL_BINARY type to DATE fields
> --------------------------------------------------
>
>                 Key: IGNITE-13636
>                 URL: https://issues.apache.org/jira/browse/IGNITE-13636
>             Project: Ignite
>          Issue Type: Bug
>          Components: odbc
>    Affects Versions: 2.9
>            Reporter: Igor Sapego
>            Assignee: Igor Sapego
>            Priority: Major
>              Labels: odbc
>             Fix For: 2.9.1
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> "The DATE types should not be reported as SQL_BINARY. They should be returned as SQL_DATE"
> {noformat}
> DATE_FIELD DataType SQL_BINARY, DecimalDigits 0, Nullable 2, ColumnSize 10, UnsignedNumber 1, is_output_column 
> {noformat}



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