[IGNITE-15609] Calcite. Error WHERE clause must be a condition.

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.15
• Component/s: sql
• Labels: calcite
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 27/Sep/21 09:38
• Updated: 04/Sep/24 16:04
• Resolved: 21/Oct/22 12:46

Description

statement ok
CREATE TABLE item(i_manufact INTEGER)

query I
SELECT * FROM item i1 WHERE (SELECT count(*) AS item_cnt FROM item WHERE (i_manufact = i1.i_manufact AND i_manufact=3) OR (i_manufact = i1.i_manufact AND i_manufact=3)) ORDER BY 1 LIMIT 100;
----

org.apache.calcite.runtime.CalciteContextException: From line 1, column 30 to line 1, column 167: WHERE clause must be a condition

	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:506)
	at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:917)
	at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:902)
	at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:5271)
	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateWhereOrOn(SqlValidatorImpl.java:4350)
	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateWhereClause(SqlValidatorImpl.java:4334)

/subquery/scalar/test_tpcds_correlated_subquery.test[_ignore]

tested with mysql, all ok there.

Issue Links

• Dependency: CALCITE-5154 Boolean clause is not recognized as boolean in Join-On's subquery.
• is part of: IGNITE-12248 Apache Calcite based query execution engine
• is related to: IGNITE-15593 Calcite. Fail on inner join on non-equality subquery.
• links to: GitHub Pull Request #1227
• links to: GitHub Pull Request #10340
• links to: GitHub PullRequest #10340