[DRILL-2648] CONVERT_FROM gives no specific message with called with bad type value

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Daniel Barclay
• Created: 01/Apr/15 04:39
• Updated: 02/Apr/15 16:44
• Resolved: 02/Apr/15 16:44

Description

Invoking CONVERT_FROM like this:

SELECT CONVERT_FROM(CAST(NULL AS INTEGER), '') FROM INFORMATION_SCHEMA.CATALOGS;

yields errors with no useful information (nothing specific to the problem):

0: jdbc:drill:zk=local> SELECT CONVERT_FROM(CAST(NULL AS INTEGER), '') FROM INFORMATION_SCHEMA.CATALOGS;
Query failed: AssertionError:

Error: exception while executing query: Failure while executing query. (state=,code=0)
0: jdbc:drill:zk=local>

Invoking CONFIRM_FROM with a bad type string should yield a message saying that the type string was unrecognized (and eventually should list all valid type strings that Drill knows).

Issue Links

• is duplicated by: DRILL-2609 convert_from should throw an appropriate error when an invalid data type is used as the second argument