You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2017/06/29 16:30:00 UTC
[jira] [Created] (DRILL-5625) Drill pushing invalid SQL to ORACLE
when IS NULL, IS UNKNOWN etc specified
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)