Update test coverage and documentation

utPLSQL · lwasylow · Feb 6, 2022 · Jan 31, 2022 · Jan 31, 2022 · Feb 1, 2022
commit cbe03e830810da8ce588368eacc6504f1e42dd22
diff --git a/docs/userguide/expectations.md b/docs/userguide/expectations.md
@@ -1645,6 +1645,10 @@ FAILURE
 
 utPLSQL is capable of comparing json data-types of `json_element_t` **on Oracle 12.2 and above**, and also `json` **on Oracle 21 and above**
 
+**Note:**
+> Whenever a database is upgraded to compatible version the utPLSQL needs to be reinstalled to pick up json changes. E.g. upgrade from 18c to 21c to enable `json` type compare. 
+
+
 ### Notes on comparison of json data
 
 - Json data can contain objects, scalar or arrays.

diff --git a/source/expectations/data_values/ut_compound_data_helper.pkb b/source/expectations/data_values/ut_compound_data_helper.pkb
@@ -786,8 +786,6 @@ create or replace package body ut_compound_data_helper is
   begin
      $if dbms_db_version.version >= 21 $then
        l_obj := case when a_json_t is null then cast (null as json_element_t ) else json_element_t.parse(json_query(a_json_t, '$' returning clob)) end;
-     $else
-       l_obj := null;
      $end
 	 return l_obj;
   end;