[IGNITE-15080] Calcite. Functions extends string parameters by trailing spaces

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Epic Link: Improve SQL quality in AI3. Part1
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Iurii Gerzhedovich
• Created: 08/Jul/21 13:14
• Updated: 11/Jul/24 09:58

Description

I discovered the strange behavior of functions with several string parameters, which then returns one of these parameters. In this case, the returned parameter string is expanded with trailing spaces to the length of the longest string.

query T
SELECT COALESCE(COALESCE(null, 'world'), 'blabla')
----
world  - result is 'world ' - so we have extra trailing spaces from max length string parameter'blabla'

query I
SELECT DECODE(102, 101, 'IBM', 102, 'GRIDGAIN', 103, 'Hewlett Packard','BALL')
----
GRIDGAIN   - result is 'GRIDGAIN       ' - so we have extra traiing spaces from max length string parameter 'Hewlett Packard'

see src/test/sql/function/generic/test_decode.test_ignore

see src/test/sql/function/generic/test_coalesce.test_ignore

Issue Links

• is part of: IGNITE-14535 Caclite SQL engine capabilities