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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: Server

Environment

Drill 1.10
ORACLE 12C2

• Assignee: Unassigned
• Reporter: N Campbell
• Created: 29/Jun/17 20:40
• Updated: 29/Jun/17 20:40

Description

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
) ;