[GEODE-7240] Prevent Usage of Aggregates within WHERE clause

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.11.0
• Component/s: querying
• Labels: GeodeCommons
• Assignee: Juan Ramos
• Reporter: Juan Ramos
• Created: 24/Sep/19 21:07
• Updated: 30/Dec/19 18:48
• Resolved: 15/Oct/19 08:56

Description

Aggregate functions shouldn't be allowed as part of the WHERE clause.
Currently, instead of rejecting the query, we throw a ClassCastException while trying to evaluate the condition:

org.apache.geode.cache.query.TypeMismatchException: Unable to use a relational comparison operator to compare an instance of class ' org.apache.geode.cache.query.internal.aggregate.XXX ' with an instance of ' java.lang.XXX '
	at org.apache.geode.cache.query.internal.types.TypeUtils$ComparisonStrategy.get(TypeUtils.java:144)
	at org.apache.geode.cache.query.internal.types.TypeUtils.compare(TypeUtils.java:499)
	at org.apache.geode.cache.query.internal.CompiledComparison.evaluate(CompiledComparison.java:137)
	at org.apache.geode.cache.query.internal.CompiledSelect.evaluate(CompiledSelect.java:438)
	at org.apache.geode.cache.query.internal.CompiledSelect.evaluate(CompiledSelect.java:53)
	at org.apache.geode.cache.query.internal.DefaultQuery.executeUsingContext(DefaultQuery.java:432)
	at org.apache.geode.cache.query.internal.DefaultQuery.execute(DefaultQuery.java:267)
	at org.apache.geode.cache.query.internal.DefaultQuery.execute(DefaultQuery.java:199)

Issue Links

• is a child of: GEODE-6906 Review OQL Aggregate Functions
• links to: GitHub Pull Request #4103