You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Yury Gerzhedovich (Jira)" <ji...@apache.org> on 2023/04/20 13:15:00 UTC

[jira] [Created] (IGNITE-19331) Sql. CAST with Boolean operations is failed.

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)