[IGNITE-15559] Calcite. CAST with Boolean operations is failed.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.15
• Component/s: sql
• Labels: calcite
• Release Note: SQL Calcite: Fixed CAST error from numbers to boolean
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Aleksey Plekhanov
• Reporter: Evgeny Stanilovsky
• Created: 22/Sep/21 13:22
• Updated: 20/Apr/23 13:24
• Resolved: 02/Dec/22 07:24

Description

SqlRunner tests are failed

/sql/test_boolean_cast.test_ignore

query T
SELECT CAST(CAST('1' AS float) AS BOOLEAN)
----
true

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)

Issue Links

• is duplicated by: IGNITE-19331 Sql. CAST with Boolean operations is failed.
• is part of: IGNITE-18753 Sql. Conversion to relational algebra failed to preserve datatypes.
• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #10412