[DRILL-2036] select * query returns wrong result when column name in json file changes case

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 1.0.0
• Component/s: Storage - JSON
• Assignee: Steven Phillips
• Reporter: Victoria Markman
• Created: 19/Jan/15 19:04
• Updated: 09/May/15 20:43
• Resolved: 09/May/15 20:43

Description

#Sun Jan 18 21:24:57 EST 2015
git.commit.id.abbrev=a418af1

test.json - column "city" has upper case C in the second row

{ "CustomerId": "100", "city": 10 }
{ "CustomerId": "101", "City": 20 }

Wrong result:

0: jdbc:drill:schema=dfs> select * from `test.json`;
+------------+------------+
| CustomerId |    city    |
+------------+------------+
| 100        | null       |
| 101        | 20         |
+------------+------------+
2 rows selected (0.077 seconds)

Issue Links

• depends upon: DRILL-2150 Create an abstraction for repeated value vectors.
• is duplicated by: DRILL-2425 Wrong results when identifier change cases within the same data file