[DRILL-4645] Regex_replace() function is broken

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Krystal
• Created: 28/Apr/16 21:44
• Updated: 30/Apr/16 13:55

Description

git.commit.id.abbrev=5705d45

select regexp_replace(cast(columns[2] as VARCHAR(4)), 'a', 'b') from `t1.csv` limit 2;
------------------------------------------------------------------

EXPR$0

------------------------------------------------------------------

org.apache.drill.exec.expr.fn.impl.CharSequenceWrapper@7a6e1b48

org.apache.drill.exec.expr.fn.impl.CharSequenceWrapper@7a6e1b48

------------------------------------------------------------------

Content of table t1.csv:

select * from `t1.csv`;
------------------------------

columns

------------------------------

["1","aaaaa","2015-01-01"]

["2","bbbbb","2015-01-02"]

["3","ccccc","2015-01-03"]

["4","","2015-01-04"]

["5","eeeee","2015-01-05"]

["6","fffff","2015-01-06"]

["7","ggggg","2015-01-07"]

["","hhhhh","2015-01-08"]

["9","iiiii",""]

["10","jjjjj","2015-01-10"]

------------------------------

Issue Links

• relates to: DRILL-4573 Zero copy LIKE, REGEXP_MATCHES, SUBSTR