Yury Gerzhedovich created IGNITE-19331:
------------------------------------------
Summary: Sql. CAST with Boolean operations is failed.
Key: IGNITE-19331
URL: https://issues.apache.org/jira/browse/IGNITE-19331
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Yury Gerzhedovich
SqlRunner tests are failed
{noformat}
/sql/test_boolean_cast.test_ignore
{noformat}
{noformat}
query T
SELECT CAST(CAST('1' AS float) AS BOOLEAN)
----
true
{noformat}
{noformat}
Not expected result at: (test_try_cast.test:150). [row=0, col=0, expected=true,
actual=false]
at
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Query.checkEquals(SqlScriptRunner.java:635)
at
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Query.checkResultTuples(SqlScriptRunner.java:604)
at
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Query.checkResult(SqlScriptRunner.java:583)
at
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Query.execute(SqlScriptRunner.java:555)
at
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner.run(SqlScriptRunner.java:115)
at
org.apache.ignite.internal.processors.query.calcite.logical.ScriptTestRunner$1.run(ScriptTestRunner.java:219){noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
