[jira] [Created] (DRILL-5630) Drill pushing invalid SQL to ORACLE when CAST( date as varchar) used

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created DRILL-5630:
---------------------------------

             Summary: Drill pushing invalid SQL to ORACLE when CAST( date as varchar) used
                 Key: DRILL-5630
                 URL: https://issues.apache.org/jira/browse/DRILL-5630
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.10.0
         Environment: Drill 1.10
ORACLE 12C2
            Reporter: N Campbell


plugin to ORACLE via JDBC defined

Following statement sent to Drill
select TDT.RNUM, cast(TDT.CDT as varchar(10)) from certora.DBCERT.TDT 

DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. 

sql SELECT "RNUM", CAST("CDT" AS VARCHAR(10) CHARACTER SET "ISO-8859-1") "EXPR$1" FROM "DBCERT"."TDT"

ORACLE DDL
 CREATE TABLE "DBCERT"."TDT" 
   (	"RNUM" NUMBER, 
	"CDT" DATE
   ) ;




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)