N Campbell created DRILL-5628: --------------------------------- Summary: Drill pushing invalid SQL to ORACLE when not between predicate used Key: DRILL-5628 URL: https://issues.apache.org/jira/browse/DRILL-5628 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 12C2 via JDBC defined following query sent to DRILL which fails in ORACLE select RNUM,TJOIN2.C1, TJOIN2.C2 from certora.DBCERT.TJOIN2 where not TJOIN2.C2 between 'AA' and 'CC' DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. SELECT * FROM "DBCERT"."TJOIN2" WHERE NOT "C2" >= 'AA' AND (NOT "C2") <= 'CC' ORACLE DDL CREATE TABLE "DBCERT"."TJOIN1" ( "RNUM" NUMBER(*,0), "C1" NUMBER(*,0), "C2" NUMBER(*,0) ) ; GRANT SELECT ON "DBCERT"."TJOIN1" TO PUBLIC; -- This message was sent by Atlassian JIRA (v6.4.14#64029)