You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Vincent Uribe (JIRA)" <ji...@apache.org> on 2016/02/25 17:27:18 UTC
[jira] [Created] (DRILL-4436) Result data gets mixed up when
various tables have a column "label"
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)