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

Drill pushing invalid SQL to ORACLE when not between predicate used

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.10.0
    • Fix Version/s: None
    • Component/s: Server
    • Labels:
      None
    • Environment:

      Drill 1.10
      ORACLE 12C2

      Description

      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;

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              the6campbells N Campbell

              Dates

              • Created:
                Updated:

                Issue deployment