[ https://issues.apache.org/jira/browse/BEAM-4704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17123276#comment-17123276 ]
Beam JIRA Bot commented on BEAM-4704: ------------------------------------- This issue is P2 but has been unassigned without any comment for 60 days so it has been labeled "stale-P2". If this issue is still affecting you, we care! Please comment and remove the label. Otherwise, in 14 days the issue will be moved to P3. Please see https://beam.apache.org/contribute/jira-priorities/ for a detailed explanation of what these priorities mean. > String operations yield incorrect results when executed through SQL shell > ------------------------------------------------------------------------- > > Key: BEAM-4704 > URL: https://issues.apache.org/jira/browse/BEAM-4704 > Project: Beam > Issue Type: Bug > Components: dsl-sql > Reporter: Kenneth Knowles > Priority: P2 > Labels: stale-P2 > Time Spent: 1h > Remaining Estimate: 0h > > {{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: > {code:sql} > BeamSQL> select TRIM(LEADING 'eh' FROM 'hehe__hehe'); > +------------+ > | EXPR$0 | > +------------+ > | hehe__hehe | > +------------+ > {code} > {code:sql} > BeamSQL> select TRIM(TRAILING 'eh' FROM 'hehe__hehe'); > +------------+ > | EXPR$0 | > +------------+ > | hehe__heh | > +------------+ > {code} > {code:sql} > BeamSQL> select TRIM(BOTH 'eh' FROM 'hehe__hehe'); > +------------+ > | EXPR$0 | > +------------+ > | hehe__heh | > +------------+ > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)