Forum Stats

  • 3,815,358 Users
  • 2,259,005 Discussions
  • 7,893,052 Comments

Discussions

liquibase genschema parsing bug

bsamuel
bsamuel Member Posts: 25 Blue Ribbon

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!

Answers