[CAY-2810] Can't use custom operator expression with aggregate functions

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.2
• Fix Version/s: 4.2.1, 5.0-M1
• Component/s: Core Library, Database integration
• Environment: PostgreSQL
• Assignee: Nikita Timofeev
• Reporter: Nikita Timofeev
• Created: 05/Jul/23 13:22
• Updated: 06/Jul/23 16:05
• Resolved: 06/Jul/23 16:05

Description

Custom operators are not properly replaced by an alias in the group by section leading to the incorrect SQL.
For example selecting Entity.DATA.operator("->>", String.class, "field").alias("field") results in the following SQL GROUP BY t0.data ->> ? field

Note that functions are working fine in that case.