[jira] [Created] (DRILL-5623) SYSTEM ERROR: SchemaChangeException: Failure while materializing expression.

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

N Campbell created DRILL-5623:
---------------------------------

             Summary: SYSTEM ERROR: SchemaChangeException: Failure while materializing expression. 
                 Key: DRILL-5623
                 URL: https://issues.apache.org/jira/browse/DRILL-5623
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
    Affects Versions: 1.10.0
         Environment: Drill 1.10
ORACLE 12 via JDBC
            Reporter: N Campbell


Various statements that attempt to use SQL regression functions result in a parser error.

This example fails for a different reason and appears to be a defect

plugin use ORACLE 12.2 JDBC to ORACLE 12.2

select REGR_SXX( TREGR.C1, TREGR.C3), REGR_SXX( TREGR.C2, TREGR.C3) from certora.DBCERT.TREGR


SYSTEM ERROR: SchemaChangeException: Failure while materializing expression. 
Error in expression at index -1.  Error: Missing function implementation: [regr_sxx(FLOAT8-OPTIONAL, FLOAT8-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--.
Error in expression at index -1.  Error: Missing function implementation: [regr_sxx(FLOAT8-OPTIONAL, FLOAT8-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--.


ORACLE DDL

 CREATE TABLE "DBCERT"."TREGR" 
   (	"RNUM" NUMBER(*,0), 
	"C1" FLOAT(126), 
	"C2" NUMBER(*,0), 
	"C3" NUMBER(*,0)
   ) ;

Insert into DBCERT.TREGR (RNUM,C1,C2,C3) values (0,3,10,1);
Insert into DBCERT.TREGR (RNUM,C1,C2,C3) values (1,11,8,2);
Insert into DBCERT.TREGR (RNUM,C1,C2,C3) values (2,14,9,3);
Insert into DBCERT.TREGR (RNUM,C1,C2,C3) values (3,17,6,4);
Insert into DBCERT.TREGR (RNUM,C1,C2,C3) values (4,23,5,5);
Insert into DBCERT.TREGR (RNUM,C1,C2,C3) values (5,4,null,6);
Insert into DBCERT.TREGR (RNUM,C1,C2,C3) values (6,null,3,7);
Insert into DBCERT.TREGR (RNUM,C1,C2,C3) values (7,null,null,8);



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