Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EA7BA18425 for ; Tue, 7 Jul 2015 22:31:04 +0000 (UTC) Received: (qmail 41908 invoked by uid 500); 7 Jul 2015 22:31:04 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 41880 invoked by uid 500); 7 Jul 2015 22:31:04 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 41870 invoked by uid 99); 7 Jul 2015 22:31:04 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Jul 2015 22:31:04 +0000 Date: Tue, 7 Jul 2015 22:31:04 +0000 (UTC) From: "Jinfeng Ni (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2053: ------------------------------ Attachment: 0003-DRILL-2053-Fix-incorrect-query-result-when-join-CTE-.patch > Column names are case sensitive if column is coming from WITH clause > -------------------------------------------------------------------- > > Key: DRILL-2053 > URL: https://issues.apache.org/jira/browse/DRILL-2053 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 0.8.0 > Reporter: Victoria Markman > Assignee: Jinfeng Ni > Priority: Critical > Fix For: 1.2.0 > > Attachments: 0003-DRILL-2053-Fix-incorrect-query-result-when-join-CTE-.patch > > > test.json > {code} > {"customerid":100,"customername":"AAA"} > {"customerid":101,"customername":"BBB"} > {"customerid":102,"customername":"CCC"} > {code} > Wrong result: > {code} > 0: jdbc:drill:schema=dfs> with a as ( select * from `test.json` ) select * from a, `test.json` b where a.CUSTOMERID = b.CUSTOMERID; > +------------+--------------+-------------+---------------+ > | customerid | customername | customerid0 | customername0 | > +------------+--------------+-------------+---------------+ > +------------+--------------+-------------+---------------+ > No rows selected (0.202 seconds) > {code} > Correct result, when column name matches the case of the column name in the json file: > {code} > 0: jdbc:drill:schema=dfs> with a as ( select * from `test.json` ) select * from a, `test.json` b where a.customerid = b.customerid; > +------------+--------------+-------------+---------------+ > | customerid | customername | customerid0 | customername0 | > +------------+--------------+-------------+---------------+ > | 100 | AAA | 100 | AAA | > | 101 | BBB | 101 | BBB | > | 102 | CCC | 102 | CCC | > +------------+--------------+-------------+---------------+ > 3 rows selected (0.204 seconds) > {code} > Correct result when column does not match case, but is coming directly from the table: > {code} > 0: jdbc:drill:schema=dfs> with a as ( select * from `test.json` ) select * from a, `test.json` b where a.customerid = b.customerID; > +------------+--------------+-------------+---------------+ > | customerid | customername | customerid0 | customername0 | > +------------+--------------+-------------+---------------+ > | 100 | AAA | 100 | AAA | > | 101 | BBB | 101 | BBB | > | 102 | CCC | 102 | CCC | > +------------+--------------+-------------+---------------+ > 3 rows selected (0.197 seconds) > {code} > If you change case of a column name that comes from subquery (WITH clause), this is where it goes all wrong: > {code} > 0: jdbc:drill:schema=dfs> with a as ( select * from `test.json` ) select * from a, `test.json` b where a.Customerid = b.customerid; > +------------+--------------+-------------+---------------+ > | customerid | customername | customerid0 | customername0 | > +------------+--------------+-------------+---------------+ > +------------+--------------+-------------+---------------+ > No rows selected (0.186 seconds) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)