[ https://issues.apache.org/jira/browse/DRILL-5424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Volodymyr Vysotskyi updated DRILL-5424: --------------------------------------- Labels: (was: ready-to-commit) > Fix IOBE for reverse function > ----------------------------- > > Key: DRILL-5424 > URL: https://issues.apache.org/jira/browse/DRILL-5424 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill > Affects Versions: 1.9.0 > Reporter: Volodymyr Vysotskyi > Assignee: Volodymyr Vysotskyi > Priority: Minor > Fix For: 1.11.0 > > > Query with reverse function fails: > {code:sql} > 0: jdbc:drill:zk=local> select reverse(a) from dfs.`/tmp/test.json`; > Error: SYSTEM ERROR: IndexOutOfBoundsException: index: 259, length: 1 > (expected: range(0, 256)) > {code} > for table with several long varchars. > {noformat} > cat /tmp/test.json > {"a": "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz"} > {"a": "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz"} > {"a": "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz"} > {"a": "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz"} > {"a": "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz"} > {noformat} > The same query works for the table with less row number: > {code:sql} > 0: jdbc:drill:zk=local> select reverse(a) from dfs.`/tmp/test2.json`; > +-------------------------------------------------------+ > | EXPR$0 | > +-------------------------------------------------------+ > | zyxwvutsrqponmlkjihgfedcbazyxwvutsrqponmlkjihgfedcba | > | zyxwvutsrqponmlkjihgfedcbazyxwvutsrqponmlkjihgfedcba | > | zyxwvutsrqponmlkjihgfedcbazyxwvutsrqponmlkjihgfedcba | > | zyxwvutsrqponmlkjihgfedcbazyxwvutsrqponmlkjihgfedcba | > +-------------------------------------------------------+ > {code} > {noformat} > cat /tmp/test2.json > {"a": "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz"} > {"a": "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz"} > {"a": "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz"} > {"a": "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz"} > {noformat} -- This message was sent by Atlassian JIRA (v6.3.15#6346)