[DRILL-4436] Result data gets mixed up when various tables have a column "label"

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.0
• Fix Version/s: 1.16.0
• Component/s: Storage - JDBC

Environment

Drill 1.5.0 with Zookeeper on CentOS 7.0

• Assignee: Unassigned
• Reporter: Vincent Uribe
• Created: 25/Feb/16 16:26
• Updated: 03/Mar/19 13:03
• Resolved: 03/Mar/19 13:03

Description

We have two tables in a MySQL database:
CREATE TABLE `Gender` (
`genderId` bigint(20) NOT NULL AUTO_INCREMENT,
`label` varchar(15) NOT NULL,
PRIMARY KEY (`genderId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `Civility` (
`civilityId` bigint(20) NOT NULL AUTO_INCREMENT,
`abbreviation` varchar(15) NOT NULL,
`label` varchar(60) DEFAULT NULL
PRIMARY KEY (`civilityId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

With a query on these two tables with Gender.label as 'gender' and Civility.label as 'civility', we obtain, depending of the query :

• gender in civility
• civility in the gender
• NULL in the other column (gender or civility)

if we drop the table Gender and recreate it with like this:
CREATE TABLE `Gender` (
`genderId` bigint(20) NOT NULL AUTO_INCREMENT,
`label2` varchar(15) NOT NULL,
PRIMARY KEY (`genderId`)select * from Gender
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

Everything is fine.

I guess something is wrong with the metadata...