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!