[IGNITE-15075] Calcite. TRIM function doesn't support multicharacter trim

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite2-required calcite3-required
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Iurii Gerzhedovich
• Created: 07/Jul/21 14:42
• Updated: 22/Nov/21 13:55

Description

Most databases support syntaxis with a few characters for trimming, like a

SELECT trim(both '123' from '123PostgreSQL123');

Currently, we support only a single character for trimming. Will be good to support it.

Issue Links

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