[
https://issues.apache.org/jira/browse/IGNITE-29157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18130379#comment-18130379
]
Ignite TC Bot commented on IGNITE-29157:
----------------------------------------
{panel:title=Branch: [pull/13698/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13698/head] Base: [master] : New Tests
(37)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 3{color} [[tests
37|https://ci2.ignite.apache.org/viewLog.html?buildId=9432779]]
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testArrayOfRowsReusedByJoin - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testArrayElement(String, Object)[2] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testArrayElement(String, Object)[3] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testArrayElement(String, Object)[1] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testArrayElement(String, Object)[6] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testArrayOfRowsWithDifferentFieldTypes -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testArrayElement(String, Object)[4] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testArrayElement(String, Object)[5] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testRowField(String, Object)[1] - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testRowField(String, Object)[2] - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
NestedResultTypesIntegrationTest.testArrayOfRows(String, Object)[5] -
PASSED{color}
... and 26 new tests
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9431957&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9431957
rerunBuildIds=9432779{color}
> SQL Calcite: Convert nested SQL values to external Java types in query results
> ------------------------------------------------------------------------------
>
> Key: IGNITE-29157
> URL: https://issues.apache.org/jira/browse/IGNITE-29157
> Project: Ignite
> Issue Type: Bug
> Reporter: Vladislav Pyatkov
> Assignee: Vladislav Pyatkov
> Priority: Major
> Labels: calcite, ignite-2, sql
> Time Spent: 1h
> Remaining Estimate: 0h
>
> The Calcite query engine converts scalar result columns to external Java
> types, but does not apply equivalent conversions to values nested inside
> {{ROW}}, {{ARRAY}}, and {{MAP}}.
> For example:
> {code:sql}
> SELECT DATE '2026-01-01';
> -- Returns java.sql.Date.
> SELECT ARRAY[DATE '2026-01-01'];
> -- Returns a List containing Integer 20454.
> SELECT ROW(DATE '2026-01-01', 42);
> -- Returns Object[] with Integer 20454 in the first field.
> SELECT MAP['date', DATE '2026-01-01'];
> -- Returns a Map containing Integer 20454 as the value.
> {code}
> The same issue affects time, timestamp, interval, and binary values: internal
> representations are exposed to the caller.
> h3. Definition of done
> * Values inside ROW, ARRAY, and MAP are recursively converted to external
> Java types.
> * NULL values and source containers are preserved.
> * Values requiring no conversion retain the existing fast path.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
