apache / apache/pinot

coalesce function is unable to compare the value from a String field against a string literal

Open
#10,165 3 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 55m
Merged PRs (30d)
182

Description

coalesce function is unable to compare the value from a String field against a string literal

PR https://github.com/apache/pinot/pull/9958 enables coalesce to support string literals but still coalesce is unable to compare a string field value against a string literal. For example:

select coalesce(my_string_field,'1234') from my_table limit 1

doesn't work, gives an error
Caused by: java.lang.IllegalArgumentException: Argument types have to be the same.

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the issue with `select coalesce(my_string_field,'1234') from my_table limit 1` and trace the coalesce argument type validation. Done means a String field can be compared with a string literal without the "Argument types have to be the same" error, while existing coalesce behavior remains intact.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.