Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

liquibase genschema parsing bug

bsamuelMar 23 2022

Hi all,
Liquibase version: 4.6.1
Extension Version: 21.4.1.0
I'm evaluating liquibase at present and I've found an issue with the "lb genshema -split" command where a few objects can't be parsed. For those objects if I use "lb genobject -type <type> -name <name>" it works fine.
The following view will get the error:
"The following are objects that were not able to be parsed correctly.
This means they will not be sorted according to any object dependencies.
view_bad_0.xml"
CREATE OR REPLACE VIEW emp_v AS
SELECT empno
, json_arrayagg (
json_object (
'ename' value e.ename
, 'job' value e.job
, 'mgr' value e.mgr
, 'dept' value ( SELECT json_arrayagg (
json_object (
'dname' value d.dname
, 'loc' value d.loc
RETURNING CLOB )
RETURNING CLOB )
FROM dept d
WHERE d.deptno = e.deptno )
RETURNING CLOB )
RETURNING CLOB ) AS "data"
FROM emp e
GROUP BY empno;

However, if you comment out one of the lines, eg the "mgr" line, it will work fine. Has anyone come across this and know if there is a solution?
Thanks!

Comments

Post Details

Added on Mar 23 2022
1 comment
296 views