[DRILL-2283] Internal VARCHAR(1) breaks INFO._SCHEMA table string comparison

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Metadata
• Labels: no_verified_test
• Assignee: Parth Chandra
• Reporter: Daniel Barclay
• Created: 21/Feb/15 00:44
• Updated: 04/May/15 22:23
• Resolved: 25/Feb/15 01:08

Description

In org.apache.drill.exec.store.ischema.InfoSchemaTable, method getRelDataType(...) calls a version of RelDataTypeFactory.createSqlType(...) that sets the type of strings to VARCHAR(1) rather than VARCHAR(<some big number>).

This breaks string comparison. (For example, "DATA_TYPE = 'IN'" returns true when the INFORMATION_SCHEMA.COLUMNS.DATA_TYPE value is "INTEGER".)