[
https://issues.apache.org/jira/browse/IGNITE-29129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18125787#comment-18125787
]
Ignite TC Bot commented on IGNITE-29129:
----------------------------------------
{panel:title=Branch: [pull/13677/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13677/head] Base: [master] : New Tests
(5)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 3{color} [[tests
4|https://ci2.ignite.apache.org/viewLog.html?buildId=9401103]]
* {color:#013220}IgniteCalciteTestSuite3:
integration.DataTypesTest[1].testOtherTypeCastToVarchar()[1] - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
SystemViewsIntegrationTest.testClassColumn - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
integration.DataTypesTest[2].testOtherTypeCastToVarchar()[2] - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
integration.DataTypesTest[3].testOtherTypeCastToVarchar()[3] - PASSED{color}
{color:#00008b}Calcite SQL 1{color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=9401021]]
* {color:#013220}IgniteCalciteTestSuite: OtherTypeTest.testJavaTypeConversion -
PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9401136&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9401136
rerunBuildIds=9403024,9403026,9403028{color}
> SQL Calcite: Fix CAST to VARCHAR for unmapped Java types
> --------------------------------------------------------
>
> Key: IGNITE-29129
> URL: https://issues.apache.org/jira/browse/IGNITE-29129
> Project: Ignite
> Issue Type: Bug
> Reporter: Kirill Tkalenko
> Assignee: Kirill Tkalenko
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> A {{CAST}} to {{VARCHAR}} failure was found in the {{SYS.TABLE_COLUMNS}}
> system view. Unmapped Java types should use Ignite’s {{OtherType}} and
> support the same conversion as an explicit {{OTHER}} column:
> {code:java}
> CREATE TABLE T (ID INT PRIMARY KEY, VAL OTHER);
> INSERT INTO T VALUES (1, 'hello'), (2, 42), (3, NULL);
> SELECT ID, CAST(VAL AS VARCHAR)
> FROM T
> ORDER BY ID; {code}
> Expected results: {{{}(1, 'hello'){}}}, {{{}(2, '42'){}}}, {{{}(3, NULL){}}}.
> The system view failure became consistently reproducible after IGNITE-29045
> removed a type-cache collision.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
