Test failures when running on 19c PDB #31
Description
Running install_test.sql produces the following failures/errors when running on an PDB of an Oracle 19c instance. It works without problem in an non-multitenant environment.
====================================================================
Run tests with 12.2 code coverage
====================================================================
plscope
test
test_type_util
test_dedup_t_obj [1.35 sec]
test_dedup_t_col [.052 sec]
test_dedup_t_col_lineage [.054 sec]
test_plscope_identifiers
user_identifiers [2.234 sec]
user_statements [.727 sec]
test_plscope_context
test_set_attr [.025 sec]
test_remove_attr [.015 sec]
test_remove_all [.104 sec]
test_parse_util
test_parse_query [.103 sec]
test_get_insert_targets [.13 sec]
test_get_insert_subquery [.052 sec]
test_get_dep_cols [.064 sec]
test_lineage_util
test_set_get_recursive [.026 sec]
test_get_dep_cols_from_query [.742 sec]
test_get_dep_cols_from_view [.059 sec]
test_get_dep_cols_from_insert [2.142 sec] (FAILED - 1)
test_get_target_cols_from_insert [.699 sec] (FAILED - 2)
test_dd_util
test_resolve_synonym [.042 sec] (FAILED - 3)
test_get_object [.007 sec]
test_get_objects [.048 sec]
test_get_column_id [.011 sec]
test_get_view_source [.119 sec]
demo
test_etl
test_load_from_tab [.204 sec]
deptsal an deptsal_err deleted.
deptsal loaded and commited (from table).
test_load_from_view [.034 sec]
deptsal an deptsal_err deleted.
deptsal loaded and commited (from view).
test_load_from_syn [.021 sec]
deptsal an deptsal_err deleted.
deptsal loaded and commited (from view via synonym).
test_load_from_syn_wild [.019 sec]
deptsal an deptsal_err deleted.
deptsal loaded and commited (from view via synonym without explicit column references).
test_load_from_syn_log [.023 sec]
deptsal an deptsal_err deleted.
deptsal loaded and commited (with log errors).
test_load_multi_table [.026 sec]
deptsal an deptsal_err deleted.
deptsal loaded and commited (from via multi-table-insert).
test_load_from_implicit_cursor [.022 sec]
deptsal an deptsal_err deleted.
deptsal loaded and commited (from implicit cursor).
test_load_from_explicit_cursor [.019 sec]
deptsal an deptsal_err deleted.
deptsal loaded and commited (from explicit cursor).
test_load_from_dyn_sql [.02 sec]
deptsal an deptsal_err deleted.
deptsal loaded and commited (from dynamic SQL).
test_sal_of_dept [.01 sec]
test_load_from_app_join [.033 sec]
deptsal an deptsal_err deleted.
deptsal loaded and commited (from application join).
Failures:
1) test_get_dep_cols_from_insert
Actual: plscope.t_col_lineage_type [ count = 3 ] was expected to equal: plscope.t_col_lineage_type [ count = 3 ]
Diff:
Rows: [ 3 differences ]
Row No. 1 - Actual: <TO_COLUMN_NAME>SALARY</TO_COLUMN_NAME>
Row No. 1 - Expected: <TO_COLUMN_NAME>DEPT_NAME</TO_COLUMN_NAME>
Row No. 2 - Actual: <TO_COLUMN_NAME>DEPT_NAME</TO_COLUMN_NAME>
Row No. 2 - Expected: <TO_COLUMN_NAME>DEPT_NO</TO_COLUMN_NAME>
Row No. 3 - Actual: <TO_COLUMN_NAME>DEPT_NO</TO_COLUMN_NAME>
Row No. 3 - Expected: <TO_COLUMN_NAME>SALARY</TO_COLUMN_NAME>
at "PLSCOPE.TEST_LINEAGE_UTIL.TEST_GET_DEP_COLS_FROM_INSERT", line 121 ut.expect(anydata.convertCollection(l_sorted))
Actual: plscope.t_col_lineage_type [ count = 7 ] was expected to equal: plscope.t_col_lineage_type [ count = 7 ]
Diff:
Rows: [ 7 differences ]
Row No. 1 - Actual: <TO_COLUMN_NAME>DEPT_NAME</TO_COLUMN_NAME>
Row No. 1 - Expected: <TO_COLUMN_NAME>DEPT_NO</TO_COLUMN_NAME>
Row No. 2 - Actual: <TO_COLUMN_NAME>SALARY</TO_COLUMN_NAME>
Row No. 2 - Expected: <TO_COLUMN_NAME>DEPT_NAME</TO_COLUMN_NAME>
Row No. 3 - Actual: <TO_COLUMN_NAME>DEPT_NO</TO_COLUMN_NAME>
Row No. 3 - Expected: <TO_COLUMN_NAME>SALARY</TO_COLUMN_NAME>
Row No. 4 - Actual: <TO_COLUMN_NAME>DEPT_NO</TO_COLUMN_NAME>
Row No. 4 - Expected: <TO_COLUMN_NAME>SALARY</TO_COLUMN_NAME>
Row No. 5 - Actual: <TO_COLUMN_NAME>SALARY</TO_COLUMN_NAME>
Row No. 5 - Expected: <TO_COLUMN_NAME>DEPT_NAME</TO_COLUMN_NAME>
Row No. 6 - Actual: <TO_COLUMN_NAME>DEPT_NAME</TO_COLUMN_NAME>
Row No. 6 - Expected: <TO_COLUMN_NAME>DEPT_NO</TO_COLUMN_NAME>
Row No. 7 - Actual: <TO_COLUMN_NAME>DEPT_NO</TO_COLUMN_NAME>
Row No. 7 - Expected: <TO_COLUMN_NAME>SALARY</TO_COLUMN_NAME>
at "PLSCOPE.TEST_LINEAGE_UTIL.TEST_GET_DEP_COLS_FROM_INSERT", line 149 ut.expect(anydata.convertCollection(l_sorted))
2) test_get_target_cols_from_insert
Actual: plscope.t_col_type [ count = 3 ] was expected to equal: plscope.t_col_type [ count = 3 ]
Diff:
Rows: [ 3 differences ]
Row No. 1 - Actual: <COLUMN_NAME>DEPT_NAME</COLUMN_NAME>
Row No. 1 - Expected: <COLUMN_NAME>DEPT_NO</COLUMN_NAME>
Row No. 2 - Actual: <COLUMN_NAME>SALARY</COLUMN_NAME>
Row No. 2 - Expected: <COLUMN_NAME>DEPT_NAME</COLUMN_NAME>
Row No. 3 - Actual: <COLUMN_NAME>DEPT_NO</COLUMN_NAME>
Row No. 3 - Expected: <COLUMN_NAME>SALARY</COLUMN_NAME>
at "PLSCOPE.TEST_LINEAGE_UTIL.TEST_GET_TARGET_COLS_FROM_INSERT", line 173 ut.expect(anydata.convertCollection(l_actual))
3) test_resolve_synonym
ORA-06550: line 2, column 10:
PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:
( begin case declare exit for function goto if loop mod null
package pragma procedure raise return select type update
while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
table continue call close current define delete fetch lock
insert open rollback savepoint set sql execute commit forall
merge library assembly operator pipe purge compound
json_exists json_value json_q
ORA-06550: line 2, column 10:
PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:
( begin case declare exit for function goto if loop mod null
package pragma procedure raise return select type update
while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
table continue call close current define delete fetch lock
insert open rollback savepoint set sql execute commit forall
merge library assembly operator pipe purge compound
json_exists
ORA-06512: at "PLSCOPE.DD_UTIL", line 12
ORA-06512: at "PLSCOPE.DD_UTIL", line 26
ORA-06512: at "PLSCOPE.TEST_DD_UTIL", line 35
ORA-06512: at "PLSCOPE.DD_UTIL", line 12
ORA-06512: at "PLSCOPE.DD_UTIL", line 26
ORA-06512: at "PLSCOPE.TEST_DD_UTIL", line 35
ORA-06512: at line 6
Finished in 9.592997 seconds
33 tests, 2 failed, 1 errored, 0 disabled, 0 warning(s)