[KYLIN-5272] The "case when" command may cause the field value to be different from the user's expectation.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v2.2.0, v2.6.3
• Component/s: Query Engine
• Assignee: Unassigned
• Reporter: GuKe
• Created: 23/Sep/22 08:49
• Updated: 02/Oct/22 01:57

Description

When using "Case then" to set a fixed character value for a field, Kylin uses Spaces to complete the length of string to 32. This will cause the field to display characters that are actually different from the user's expected values, causing query errors, Example a failed Join operation.