[jira] [Created] (DRILL-5624) Drill is pushing similar predicate to an RDBMS which does not support it

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created DRILL-5624:
---------------------------------

             Summary: Drill is pushing similar predicate to an RDBMS which does not support it
                 Key: DRILL-5624
                 URL: https://issues.apache.org/jira/browse/DRILL-5624
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.10.0
         Environment: Drill 1.10
ORACLE 12R2
            Reporter: N Campbell



A plugin is defined to query ORACLE 12R2 via JDBC. 

If the followin statement is sent to Drill, it will issue a SQL statement which is invalid in ORACLE.

select  TVCHAR.RNUM, TVCHAR.CVCHAR from certora.DBCERT.TVCHAR where TVCHAR.CVCHAR SIMILAR TO 'BB'

DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. 

SELECT *
FROM "DBCERT"."VVCHAR"
WHERE "CVCHAR" SIMILAR TO 'BB'
plugin certora
Fragment 0:0


https://calcite.apache.org/docs/reference.html

ORACLE DDL

  CREATE TABLE "DBCERT"."TVCHAR" 
   (	"RNUM" NUMBER, 
	"CVCHAR" VARCHAR2(32 BYTE)
   ) ;


Insert into DBCERT.TVCHAR (RNUM,CVCHAR) values (0,null);
Insert into DBCERT.TVCHAR (RNUM,CVCHAR) values (1,null);
Insert into DBCERT.TVCHAR (RNUM,CVCHAR) values (2,' ');
Insert into DBCERT.TVCHAR (RNUM,CVCHAR) values (3,'BB');
Insert into DBCERT.TVCHAR (RNUM,CVCHAR) values (4,'EE');
Insert into DBCERT.TVCHAR (RNUM,CVCHAR) values (5,'FF');





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