[
https://issues.apache.org/jira/browse/IGNITE-29016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18108553#comment-18108553
]
Ignite TC Bot commented on IGNITE-29016:
----------------------------------------
{panel:title=Branch: [pull/13524/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13524/head] Base: [master] : New Tests
(7)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 3{color} [[tests
6|https://ci2.ignite.apache.org/viewLog.html?buildId=9310150]]
* {color:#013220}IgniteCalciteTestSuite3:
FunctionsTest.testEmptyStringIsNotNullByDefault - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
EmptyStringIsNullIntegrationTest.testStorage - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
EmptyStringIsNullIntegrationTest.testLiteralsAndComparisons - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
EmptyStringIsNullIntegrationTest.testUdfs - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
EmptyStringIsNullIntegrationTest.testExpressionAndAggregateResults -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
EmptyStringIsNullIntegrationTest.testNotNullConstraint - PASSED{color}
{color:#00008b}Calcite SQL 1{color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=9310068]]
* {color:#013220}IgniteCalciteTestSuite:
RexToLixTranslatorTest.testEmptyStringResultIsNormalizedOnce - PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9310183&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9310183
rerunBuildIds=9310346,9310348,9310350{color}
> SQL Calcite: Support treating empty strings as NULL
> ---------------------------------------------------
>
> Key: IGNITE-29016
> URL: https://issues.apache.org/jira/browse/IGNITE-29016
> Project: Ignite
> Issue Type: Improvement
> Reporter: Kirill Tkalenko
> Assignee: Kirill Tkalenko
> Priority: Major
> Labels: ignite-2
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Some databases support treating zero-length character strings as
> {{{}NULL{}}}: Oracle does this by default, while Db2 and H2 provide it
> through Oracle compatibility modes.
> [Oracle|https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Nulls.html],
>
> [Db2|https://www.ibm.com/docs/en/db2/12.1.x?topic=compatability-varchar2-nvarchar2],
> [H2|https://h2database.github.io/html/features.html#compatibility_modes].
> When enabled:
> * String literals, parameters and stored values {{''}} are treated as
> {{{}NULL{}}}.
> * Empty strings returned by expressions, built-in functions, UDFs and UDTFs
> become {{{}NULL{}}}.
> * Comparisons follow regular SQL {{NULL}} semantics.
> * A whitespace-only string such as {{' '}} remains unchanged.
> * Binary values and LOBs are not affected.
> The existing behavior should remain when the option is disabled.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
