P3 Description
TRIM is defined to trim all the characters in the first string from the string-to-be-trimmed. Calcite has an incorrect implementation of this. We use our own fixed implementation. But when executed through the SQL shell, the results do not match what we get from the PTransform path. Here two test cases that pass on master but are incorrect in the shell:
BeamSQL> select TRIM(LEADING 'eh' FROM 'hehe__hehe'); +------------+ | EXPR$0 | +------------+ | hehe__hehe | +------------+
BeamSQL> select TRIM(TRAILING 'eh' FROM 'hehe__hehe'); +------------+ | EXPR$0 | +------------+ | hehe__heh | +------------+
BeamSQL> select TRIM(BOTH 'eh' FROM 'hehe__hehe'); +------------+ | EXPR$0 | +------------+ | hehe__heh | +------------+
Attachments
Issue Links
- links to
