Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.6.2
-
Untriaged
-
0
-
Yes
Description
create or replace function TEST_CTE_CORR(abc) {
|
( WITH CTE_1 AS ( Select 1 as CTE_1_Value ) ,
|
CTE_2 AS ( Select c.*, abc from CTE_1 c )
|
Select * from CTE_2 )
|
};
|
execute function TEST_CTE_CORR(123);
|
{
|
"requestID": "adbb8145-642d-411f-9591-98cc1b85e367",
|
"signature": null,
|
"results": [
|
],
|
"errors": [
|
{
|
"code": 10109,
|
"msg": "Error executing function 'TEST_CTE_CORR' ",
|
"reason": {
|
"_level": "exception",
|
"caller": "inline:143",
|
"code": 10103,
|
"icause": "Formalizer internal error: correlation reference CTE_1 is not in allowed",
|
"key": "function.internal.error",
|
"message": "Operation on function encountered an unexpected error: Formalizer internal error: correlation reference CTE_1 is not in allowed. Please collect the failing statement and contact support"
|
}
|
}
|
],
|
"status": "fatal",
|
"metrics": {
|
"elapsedTime": "1.980086ms",
|
"executionTime": "1.809972ms",
|
"resultCount": 0,
|
"resultSize": 0,
|
"serviceLoad": 3,
|
"errorCount": 1
|
}
|
}
|