[DRILL-742] TO_NUMBER functions fail with "UnsupportedOperationException" error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: Krystal
• Reporter: Krystal
• Created: 14/May/14 18:52
• Updated: 01/Apr/16 15:41
• Resolved: 05/Jun/14 16:02

Description

Below are some examples of to_number functions that failed to execute:

select to_number('987,966', '999999') from voter where voter_id=10;
select to_number('98.966', '99.999') from voter where voter_id=10;
select to_number('$2,900.00', 'L9G999D99') from voter where voter_id=10;
select to_number('00123456789', '00999999999') from voter where voter_id=10;
select to_number('$2,900.00', 'L9G999D99') from voter where voter_id=10;