[CASSANDRA-10296] Aggregates aren't resolved properly for reversed types

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.2
• Component/s: Legacy/CQL
• Severity: Normal
• Since Version: 2.2.0
• Assignee: Carl Yeksigian
• Reporter: Carl Yeksigian

Authors

Carl Yeksigian

Reviewers

Benjamin Lerer

• Created: 09/Sep/15 17:25
• Updated: 16/Apr/19 09:30
• Resolved: 11/Sep/15 09:28

Description

When using an aggregate, it won't resolve if the column is reversed.

CREATE TABLE t1 (pk int, ck int, PRIMARY KEY (pk, ck)) WITH CLUSTERING ORDER BY (ck DESC)
SELECT min(ck) FROM t1 WHERE pk = 1

results in the error:

Ambiguous call to function min (can be matched by following signatures: system.min : (varint) -> varint, system.min : (int) -> int, system.min : (blob) -> blob): use type casts to disambiguate

For aggregates, we should be treating a reversed type the same as we do a normal type.