Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5625

Drill pushing invalid SQL to ORACLE when IS NULL, IS UNKNOWN etc specified

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.10.0
    • None
    • Server
    • None

    • Drill 1.10
      ORACLE 12C2

    Description

      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

      Attachments

        Activity

          People

            Unassigned Unassigned
            the6campbells N Campbell
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: