drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5625) Drill pushing invalid SQL to ORACLE when IS NULL, IS UNKNOWN etc specified
Date Thu, 29 Jun 2017 16:30:00 GMT
N Campbell created DRILL-5625:
---------------------------------

             Summary: Drill pushing invalid SQL to ORACLE when IS NULL, IS UNKNOWN etc specified
                 Key: DRILL-5625
                 URL: https://issues.apache.org/jira/browse/DRILL-5625
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.10.0
         Environment: Drill 1.10
ORACLE 12C2
            Reporter: N Campbell


A plugin is defined for ORACLE via JDBC

The following query is sent to DRILL which fails due to it generating SQL which ORACLE does
not support

select 1 from certora.DBCERT.TVERSION where ( CNNULL = 1 ) is UNKNOWN
DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. 

SELECT 1 "EXPR$0" FROM "DBCERT"."TVERSION"
WHERE ("CNNULL" = 1) IS NULL





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

Mime
View raw message