Vincent Uribe created DRILL-4436: ------------------------------------ Summary: Result data gets mixed up when various tables have a column "label" Key: DRILL-4436 URL: https://issues.apache.org/jira/browse/DRILL-4436 Project: Apache Drill Issue Type: Bug Affects Versions: 1.5.0 Environment: Drill 1.5.0 with Zookeeper on CentOS 7.0 Reporter: Vincent Uribe
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`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; Everything is fine. I guess something is wrong with the metadata... -- This message was sent by Atlassian JIRA (v6.3.4#6332)