Does JRS block the use of "WITH" common table expressions?
![]() Trying to create a recursive query using common table expressions in JRS and I keep getting crrgw5628e an com.foundationdb.sql.parser sqlparseexception error occurred when validating the input SQL string, caused by encountered " "with" "WITH"" at line 1, column 1.
The simplest query I can do is: WITH cte AS ( SELECT REQUEST1_ID, REQUEST2_ID FROM RIDW.VW_REQUEST_RELATIONAL_LINK ) SELECT * FROM cte
We're running Oracle 11.2, and near as I can tell it should be working. I've had other issues in the past with using "WITH" in a query through JRS. Any ideas? |
One answer
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.