[ https://issues.apache.org/jira/browse/BEAM-4704?focusedWorklogId=144067&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-144067 ]
ASF GitHub Bot logged work on BEAM-4704: ---------------------------------------- Author: ASF GitHub Bot Created on: 13/Sep/18 20:19 Start Date: 13/Sep/18 20:19 Worklog Time Spent: 10m Work Description: apilloud commented on issue #6389: [BEAM-4704] Disable enumerable rules, use direct runner URL: https://github.com/apache/beam/pull/6389#issuecomment-421139460 run java precommit ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 144067) Time Spent: 40m (was: 0.5h) > 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: Major > Time Spent: 40m > 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 (v7.6.3#76005)