[ https://issues.apache.org/jira/browse/DRILL-5622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kunal Khatua updated DRILL-5622: -------------------------------- Component/s: Storage - JDBC > DISTINCT predicate generates invalid SQL for a JDBC data source such as ORACLE > ------------------------------------------------------------------------------ > > Key: DRILL-5622 > URL: https://issues.apache.org/jira/browse/DRILL-5622 > Project: Apache Drill > Issue Type: Bug > Components: Server, Storage - JDBC > Affects Versions: 1.10.0 > Environment: ORACLE 12 > Apache Drill 1.10 > Reporter: N Campbell > Priority: Major > > The SQL generated by DRILL to a database such as ORACLE is inavlid > SELECT RNUM, TINT.CINT FROM certora.DBCERT.TINT WHERE TINT.CINT IS DISTINCT > FROM 1 > DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL > query. > SELECT * > FROM "DBCERT"."TINT" > WHERE CAST(CASE WHEN "CINT" IS NULL THEN 1 IS NOT NULL WHEN 1 IS NULL THEN > "CINT" IS NOT NULL ELSE "CINT" <> 1 END AS BOOLEAN) > plugin certora > Fragment 0:0 > CREATE TABLE "DBCERT"."TINT" > ( "RNUM" NUMBER, > "CINT" NUMBER(9,0) > ) ; > Insert into DBCERT.TINT (RNUM,CINT) values (0,null); > Insert into DBCERT.TINT (RNUM,CINT) values (1,-1); > Insert into DBCERT.TINT (RNUM,CINT) values (2,0); > Insert into DBCERT.TINT (RNUM,CINT) values (3,1); > Insert into DBCERT.TINT (RNUM,CINT) values (4,10); -- This message was sent by Atlassian JIRA (v7.6.3#76005)