[DRILL-5623] SYSTEM ERROR: SchemaChangeException: Failure while materializing expression.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: SQL Parser

Environment

Drill 1.10
ORACLE 12 via JDBC

• Assignee: Unassigned
• Reporter: N Campbell
• Created: 29/Jun/17 12:52
• Updated: 29/Jun/17 12:52

Description

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);