[CALCITE-1979] Case When result type precision problem

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Won't Do
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Hequn Cheng
• Created: 10/Sep/17 06:02
• Updated: 22/Dec/17 02:26
• Resolved: 22/Dec/17 02:26

Description

Considering such query:

"SELECT a, case when c = 'Hi' then 'ARRIVAL' else 'DEPARTURE' end as cc, b FROM sourceTable"

The result type of case when will be BasicSqlType with precision 9. This makes "ARRIVAL" to "ARRIVAL " with two spaces behind. But what users want is just "ARRIVAL".

Also users may write the following query(with one space behind ARRIVAL):

"SELECT a, case when c = 'Hi' then 'ARRIVAL ' else 'DEPARTURE' end as cc, b FROM sourceTable"

The result type of case when will also be BasicSqlType with precision 9, which makes no differences to the first query.