Skip to content

Commit 1a5c525

Browse files
lwasylowlwasylow
authored
Release/v3.1.7 (#942)
* Test to verify there's a problem with cursor-comparison on 12.1 when there are several numbers with different precision and we make use of package-level nested table types * Typo * Initial checkin * Adding handling of xml error * Adding new API user. * Updated `install.md` * Updated project version after build [skip ci] * Separating tests. * Update properties * Change user that executes tests as helper that is super user. * Updated version to `3.1.7` * Updated project version after build [skip ci] * Adding next set of tests migrated. expectations/binary/test_equal expectations/binary/test_expect_to_be_less_than expectations/test_expectation_anydata expectations/test_expectation_processor * Adding next set of tests migrated. expectations/binary/test_be_less_or_equal changing name of function to more meaningful. * Fixing test package * Added set of tests: expectations/binary/test_be_greater_or_equal expectations/binary/test_be_greater_than expectations/unary/test_expect_not_to_be_null Passing username implicit into ut_test_runner. * Adding set of tests : expectations/unary/test_expect_to_be_empty expectations/unary/test_expect_to_be_null expectations/unary/test_expect_to_be_true_false expectations/unary/test_expect_to_have_count Adding dummy type for testing. * Adding schema prefix to failing tests from 12.1 * Fixing development scripts * Fixed bug for deployments with uninstall included. Added new user to `template.env.sh` * Updated project version after build [skip ci] * FIX : removal of non existing types from uninstall script * INSTALL:Is it too many monkeys ?:) * Added support for random order of test execution. Resolves #422 * Adding set of tests: api/test_ut_run * Adding set of tests: api/test_ut_run * Fixing one bad test. Workaround for current issue with `unordered()` comparison of blank lines. * Fixing issue with null vs null being returned as false. Fixing change in Oracle 12.2+ where XML is stored as binary XML and not preserving insignificant white space. This require store data as clob. * Revert test * Fixed bad test. Added `dbms_output.enable` in `core` test package * Adding set of tests: api/test_ut_run * Adding set of tests: core/annotations/test_annotation_parser core/annotations/test_annot_throws_exception core/annotations/test_annotation_manager * Adding set of tests: core/test_ut_test core/test_ut_utils * Adding set of tests: core/test_ut_executable core/test_ut_suite * Adding set of tests: core/test_file_mapper core/test_output_buffer core/test_suite_manager core/test_ut_executable * Adding tests core/test_suite_builder * Adding tests: reporters reporters/test_junit_reporter reporters/test_sonar_test_reporter reporters/test_teamcity_reporter reporters/test_tfs_junit_reporter * Fixed storage for clob in output bugger table - make it inline. Changed how delete from output buffer table is handled - use ROWID. Increased fetch size from 100 to 3000 rows for output buffer. * Improved performance for reading data from output buffer. Decreased read limit back to 1000 as it should not have significant performance impact anymore. * Increased read limit to 5000. Fixed bug with increasing `max_message_id` even when nothing was read. * Adding set of tests: reporters/test_coverage reporters/test_debug_reporter reporters/test_documentation_reporter reporters/test_extended_coverage reporters/test_realtime_reporter Fixing some helper methods. * Split output buffers into two. Now we have separate buffer for CLOB data and VARCHAR2 text data. * Adding extra tests: reporters/test_coverage/test_cov_cobertura_reporter reporters/test_coverage/test_coverage_sonar_reporter reporters/test_coverage/test_coveralls_reporter reporters/test_coverage/test_html_extended_reporter * Updated documentation for random order of test execution * Adding tests: reporters/test_coverage reporters/test_coverage/test_html_proftab_reporter reporters/test_proftab_coverage * Updated project version after build [skip ci] * Fixing broken test. Adding test: reporters/test_coverage/test_html_extended_reporter reporters/test_extended_coverage * Adding test: unary/test_expect_to_be_not_null * Adding global setup * document how to avoid Oracle Bug 14402514 (see #891) * Fixes #891 - use to_match instead of to_be_like to avoid Oracle bug 14402514 on some 11.2.0.4 instances * Updated project version after build [skip ci] * Update cleanup script after branching from random order branch * Fixed invalid suitepath in `core` package. Updated cli version to 3.1.6 Added top package `utplsql` with dbms_output.enable for both test users. Renamed suitepath to match username (ut3_tester) * Updated project version after build [skip ci] * Cursor error handling * Update tests for handling usr friendly error * Applying fixes as per PR review. Removal of unused procedure from expactation_processor Switch to use constant in error message creation Update tests to match full message. * Cleanup whitespaces * fixing ORA-00907 when comparing ref cursors with BINARY_DOUBLE/BINRAY_FLOAT columns fixing ORA-00907: missing right parenthesis when comparing ref cursors with BINARY_DOUBLE/BINARY_FLOAT columns, because these column types do not support type length * fix/ORA-00907: adding simple testcase * fix/ORA-00907: shortening test case name * fix/ORA-00907: wrong schema name in test case check * Updated project version after build [skip ci] * Call stack differs based on version * Fix typo * Update error lines * Adding ROWID to list of types that do not provide a length. * cleaning up tests * Update tests * testing wildcard, there is some unexpected white space that is not appearing on local tests or other similar for expected. * Fix : No length datatypes mapping. This is to address issue when Oracle dont expect a length value against data type but cursor description return a max_len not being null. * Update test * Mysterious whitespace appears from time to time. TODO * Updated project version after build [skip ci] * Fixing issue with a special column names non XML compliant (#903) * Fixing issue with a special column names that do not adhere to XML rules. * removing unused global constant. * Modification after PR comments. Inline call to function. Remove constants to be private. Expose only one function rest to be private * Updated project version after build [skip ci] * Adding trigger solution for annotation parsing. * Fixed some issues with trigger Some tests need to be fixed to disable trigger before testing Some tests need to be added to prove trigger is working * Fixed uninstall script and constant. Disabled `-scc` flag in tests * Removed commented code. * Added tags for tests and tags for suite. * Switch to use VARCHAR2 instead of UT_VARCHAR2_ROWS() Signed-off-by: lwasylow <lwasylow@gmail.com> * Switch to use VARCHAR2 instead of UT_VARCHAR2_ROWS() Signed-off-by: lwasylow <lwasylow@gmail.com> * Fix/oracle bug with xmlspaces (#895) * Address issue with whitespace in XML. Cursor describe is ignoring whitespace so max len of column with value ' t ' is showing as 1. XMLTABLE when extracting values from tag with whitespaces its ignoring them. It works properly if there is any character there e.g ' t '. * Update tests * Updated project version after build [skip ci] * Adding Tests to tags #suitebuilder * Change annotation to --%tags * Fixing empty tags to use xmlgen * Adding tests for ut.run Change query to use regexp as instr was giving false positives. * Added tests for ut.run procedure * Added extra tests for ut run function * Fixing error message function * Update docs * Update docs and tests * Fixes to PR comments * Fixes to PR comments * Updates to PR * Separated the install for trigger. * Phase 2 : switch to varchar_rows() * Number precision from dbms_sql not correct (#908) * Fixing issue with number from dual and precision being incorrectly read. * Updated tests * Updated project version after build [skip ci] * add tests on 19c DB version * Phase 2 : switch to varchar_rows() * Remove a 4k tests * Added constant * Updated project version after build [skip ci] * Added-back rigger installation to CI/CD process. * Moved test to new package structure and improved test details. * Fixed test to run only on 12 and above. * Updated project version after build [skip ci] * Removed garbage after PR merge. * Updates to PR. Switch to common add tags to suite item * Move query to template to simplify view * Updated project version after build [skip ci] * Fix to issue when column was removed from the middle of cursor using a exclude or include. this left a gap in orders and cause an columns mismatch on position for remainder of columns. * Fix typo * Make sure that order of the columns is kept when rewriting an order and nothing was removed. * Partition should not be across column name but a full table set. * Removal of row_number as its excessive we dont partition by any * fix message_id increment * the fix * shorten test name * fix type * Updated project version after build [skip ci] * Updated project version after build [skip ci] * Fixed issue with missing newlines in cobertura coverage for non-executed packages. Resolves #917 * Updated project version after build [skip ci] * Initial checkin * Failure details in sonar test reporter are now CDATA * Update ut_junit_reporter.tpb * Added handling of CDATA in failure messages for XML reporters. * Fixing PR comments. * Update docs with sample * TAG: Phase2 Adding a new attribute filterpath that is used for filtering cursor in anydata / refcursor. This value will be different from cursor in anydata as we skip root element. * TAG: Phase2 Adding a new attribute filterpath that is used for filtering cursor in anydata / refcursor. This value will be different from cursor in anydata as we skip root element. * PHASE 2 * Fixing unit test for Oracle 11.2 & 12.1 * Fixing code duplication * Updated project version after build [skip ci] * Fixes #921 - Assert input params in dynamic SQL Used dbms_assert.qualified_sql_name whenever possible. This is much less invasive than dbms_assert.enquote_name. Code converting case is left untouched. * Updated project version after build [skip ci] * Fixing sonar violation on duplicated code. * Updated project version after build [skip ci] * update tests to be less complicated * Fixing encoding issue * Updated project version after build [skip ci] * Renamed `gc_tag` to `gc_tags` Added debug logging of suite cache query. * Updated project version after build [skip ci] * Fixed install of release until feature is merged back. * Enabled-back dbms_preprocessor * Fixed bug in parsing annotations from DDL trigger. * Fixed issues with parsing code through trigger. Added disabling trigger on annotation parser tests. * Fixed re-install of trigger. * Updated readme for installation with trigger. Added additional tests for annotation management with / without trigger. Fixed code for situations when trigger gets added on pre-existing tests. * Addressed review comments. Refactored install scripts to avoid duplication. Added check for `oracle_maintained` schema when firing DDL trigger. * Fixed issue with style check. Reorganized code to avoid problems with conditional compilation on 12.2 for triggers. * Updated project version after build [skip ci] * Fixing sonar exclusions for analysis and coverage. * Updated project version after build [skip ci] * Fixed output_buffer purging error. Resolves #934 * Updated project version after build [skip ci] * add test cases for warning texts in tests, suites * implement new test cases and adapt existing ones Structure of test cases is affected since new PL/SQL package is created which is also used in the whole run. * emit warning texts on test and suite level * complete cleanup after run * Updated project version after build [skip ci] * Removed dependency on `dbms_utility.name_resolve`. Fixed issue with utPLSQL failing to run when schema contains package named the same as schema owning it. It is now possible to have utPLSQL test package like this: ``` create or replace package some_schema.some_schema as --%suite --%test procedure sample_test; end; / create or replace package body some_schema.some_schema as procedure sample_test is begin ut.expect(1).to_equal(1); end; end; / ``` The tests from the package can be invoked by calling: `exec ut.run('some_schema.some_schema');` If only schema is provided, all test packages in schema are executed. `exec ut.run('some_schema');` Resolves #569 Resolves #885 * Fixed issue with parsing by trigger when source contains leading comments. * Fixed typo. * Improved time needed for clob-to-table conversion. Timing before change (with dbms_lob.read): `clob_to_table - Took:+000000000 00:00:00.012957000` After change: `clob_to_table - Took:+000000000 00:00:00.001236000` Speed improved by order of magnitude. * Resolved issues with regex for DDL trigger processing. * Adressed review comment. * Fixed typo. * Updated project version after build [skip ci] * Updated project version after build [skip ci] * Feature/json object (#928) * Initial checkin. General skelet of code * Adding json tree parsing. Enabling 12.2 * Update tests. Update sonar rules. * small fixes * PHASE 2: Moving diff into temp table and init data compare during compare implementation to avoid finding same differences twice Adding have count and negated have count matcher.l * Added more complex tests. Added test when extract a piece from two different jsons. Small fixes to code on same hierarchy parent arrays * Update mddocs Fix to json traverse array when object is element of array, the element name is content of object which can be different order but same semantic content. * Fixing sonar * Switch to use supertype * PHASE3 : Adding a functionality for install in pre 12.2 * PHASE3 : Adding a functionality for install in pre 12.2 * PHASE3 : Adding a functionality for install in pre 12.2 * PHASE3 : Adding a functionality for install in pre 12.2 * PHASE3 : Adding a functionality for install in pre 12.2 * PHASE3 : Adding a functionality for install in pre 12.2 * update tests * Update set define off * Code cleanup * fix slash * Creating a dummy specs and removing conditional compilation for code cleanup * PR fixes. * Reverting development script changes. * Refactored JSON code. Changed formatting of JSON-diff output. Changed date formats. * Fixed install on Oracle < 12.2 * Updated project version after build [skip ci] * Update readme.md * Updated copyright year * Updated project version after build [skip ci]
1 parent e3f5f95 commit 1a5c525

434 files changed

Lines changed: 13049 additions & 6407 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎.travis.yml‎

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -25,6 +25,8 @@ env:
2525
- UT3_USER_PASSWORD=ut3
2626
- UT3_TESTER=ut3_tester
2727
- UT3_TESTER_PASSWORD=ut3
28+
- UT3_TESTER_HELPER=ut3_tester_helper
29+
- UT3_TESTER_HELPER_PASSWORD=ut3
2830
- UT3_TABLESPACE=users
2931
# Environment for building a release
3032
- CURRENT_BRANCH=${TRAVIS_BRANCH}
@@ -45,7 +47,7 @@ env:
4547
#utPLSQL released version directory
4648
- UTPLSQL_DIR="utPLSQL_latest_release"
4749
- SELFTESTING_BRANCH=${TRAVIS_BRANCH}
48-
- UTPLSQL_CLI_VERSION="3.1.0"
50+
- UTPLSQL_CLI_VERSION="3.1.6"
4951
# Maven
5052
- MAVEN_HOME=/usr/local/maven
5153
- MAVEN_CFG=$HOME/.m2
@@ -54,6 +56,7 @@ env:
5456
- ORACLE_VERSION="${DOCKER_TAG_12C:-12c-r1-se2-small}" CONNECTION_STR='127.0.0.1:1521/ORCLCDB' DOCKER_OPTIONS="-v /dev/pdbs:/opt/oracle/oradata/pdbs"
5557
- ORACLE_VERSION="${DOCKER_TAG_12C2:-12c-r2-se2-small}" CONNECTION_STR='127.0.0.1:1521/ORCLCDB' DOCKER_OPTIONS="-v /dev/pdbs:/opt/oracle/oradata/pdbs"
5658
- ORACLE_VERSION="${DOCKER_TAG_18:-18c-se2-small}" CONNECTION_STR='127.0.0.1:1521/ORCLCDB' DOCKER_OPTIONS="-v /dev/pdbs:/opt/oracle/oradata/pdbs"
59+
- ORACLE_VERSION="${DOCKER_TAG_19:-19c-se2-small}" CONNECTION_STR='127.0.0.1:1521/ORCLCDB' DOCKER_OPTIONS="-v /dev/pdbs:/opt/oracle/oradata/pdbs"
5760

5861
cache:
5962
pip: true

‎.travis/install.sh‎

Lines changed: 32 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@ set verify off
1010
1111
--alter session set plsql_warnings = 'ENABLE:ALL', 'DISABLE:(5004,5018,6000,6001,6003,6009,6010,7206)';
1212
alter session set plsql_optimize_level=0;
13-
@install_headless.sql $UT3_OWNER $UT3_OWNER_PASSWORD
13+
@install_headless_with_trigger.sql $UT3_OWNER $UT3_OWNER_PASSWORD
1414
SQL
1515

1616
#Run this step only on second child job (12.1 - at it's fastest)
@@ -25,14 +25,18 @@ if [[ "${TRAVIS_JOB_NUMBER}" =~ \.2$ ]]; then
2525
set verify off
2626
2727
@uninstall_all.sql $UT3_OWNER
28+
whenever sqlerror exit failure rollback
2829
declare
2930
v_leftover_objects_count integer;
3031
begin
3132
select sum(cnt)
3233
into v_leftover_objects_count
33-
from (select count(1) cnt from dba_objects where owner = '$UT3_OWNER'
34-
union all
35-
select count(1) cnt from dba_synonyms where table_owner = '$UT3_OWNER'
34+
from (
35+
select count(1) cnt from dba_objects where owner = '$UT3_OWNER'
36+
where object_name not like 'PLSQL_PROFILER%' and object_name not like 'DBMSPCC_%'
37+
union all
38+
select count(1) cnt from dba_synonyms where table_owner = '$UT3_OWNER'
39+
where table_name not like 'PLSQL_PROFILER%' and table_name not like 'DBMSPCC_%'
3640
);
3741
if v_leftover_objects_count > 0 then
3842
raise_application_error(-20000, 'Not all objects were successfully uninstalled - leftover objects count='||v_leftover_objects_count);
@@ -47,6 +51,8 @@ SQL
4751
4852
alter session set plsql_optimize_level=0;
4953
@install.sql $UT3_OWNER
54+
@install_ddl_trigger.sql $UT3_OWNER
55+
@create_synonyms_and_grants_for_public.sql $UT3_OWNER
5056
SQL
5157

5258
fi
@@ -60,27 +66,37 @@ grant select any dictionary to $UT3_OWNER;
6066
grant create any procedure, drop any procedure, execute any procedure to $UT3_OWNER;
6167
SQL
6268

63-
#Create user that will own the tests
69+
#Create user that will own the tests that are relevant to internal framework
6470
time "$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
6571
set feedback off
6672
@create_utplsql_owner.sql $UT3_TESTER $UT3_TESTER_PASSWORD $UT3_TABLESPACE
67-
68-
--needed for testing distributed transactions
69-
grant create public database link to $UT3_TESTER;
70-
grant drop public database link to $UT3_TESTER;
71-
set feedback on
72-
--Needed for testing coverage outside of main UT3 schema.
73-
grant create any procedure, drop any procedure, execute any procedure, create any type, drop any type, execute any type, under any type, select any table, update any table, insert any table, delete any table, create any table, drop any table, alter any table, select any dictionary to $UT3_TESTER;
74-
revoke execute on dbms_crypto from $UT3_TESTER;
75-
grant create job to $UT3_TESTER;
73+
--needed for disabling DDL trigger and testint parser without trigger enabled/present
74+
grant alter any trigger to ut3_tester;
75+
grant administer database trigger to $UT3_TESTER;
7676
exit
7777
SQL
7878

79-
#Create additional UT3$USER# to test for special characters
79+
#Create additional UT3$USER# to test for special characters and front end API testing
8080
time "$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
8181
set feedback off
8282
@create_utplsql_owner.sql $UT3_USER $UT3_USER_PASSWORD $UT3_TABLESPACE
83-
--Grant UT3 framework to UT3$USER#
83+
--Grant UT3 framework to min user
8484
@create_user_grants.sql $UT3_OWNER $UT3_USER
8585
exit
8686
SQL
87+
88+
#Create additional UT3_TESTER_HELPER that will provide a functions to allow min grant test user setup test
89+
time "$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
90+
set feedback off
91+
@create_utplsql_owner.sql $UT3_TESTER_HELPER $UT3_TESTER_HELPER_PASSWORD $UT3_TABLESPACE
92+
--needed for testing distributed transactions
93+
grant create public database link to $UT3_TESTER_HELPER;
94+
grant drop public database link to $UT3_TESTER_HELPER;
95+
set feedback on
96+
--Needed for testing coverage outside of main UT3 schema.
97+
grant create any procedure, drop any procedure, execute any procedure, create any type, drop any type, execute any type, under any type, select any table, update any table, insert any table, delete any table, create any table, drop any table, alter any table, select any dictionary, create any synonym, drop any synonym to $UT3_TESTER_HELPER;
98+
grant create job to $UT3_TESTER_HELPER;
99+
--Needed to allow for enable/disable of annotation triggers
100+
grant administer database trigger to $UT3_TESTER_HELPER;
101+
exit
102+
SQL

‎.travis/install_utplsql_release.sh‎

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -36,9 +36,14 @@ end;
3636
/
3737
SQL
3838

39+
INSTALL_FILE="install_headless_with_trigger.sql"
40+
if [[ ! -f "${INSTALL_FILE}" ]]; then
41+
INSTALL_FILE="install_headless.sql"
42+
fi
43+
3944
"$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<SQL
4045
alter session set plsql_optimize_level=0;
41-
@install_headless.sql ${UT3_RELEASE_VERSION_SCHEMA}
46+
@${INSTALL_FILE} ${UT3_RELEASE_VERSION_SCHEMA}
4247
exit
4348
SQL
4449

‎LICENSE‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -187,7 +187,7 @@
187187
same "printed page" as the copyright notice for easier
188188
identification within third-party archives.
189189

190-
Copyright 2016 utPLSQL Project
190+
Copyright 2016 - 2019 utPLSQL Project
191191

192192
Licensed under the Apache License, Version 2.0 (the "License"):
193193
you may not use this file except in compliance with the License.

‎VERSION‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1 +1 @@
1-
v3.1.6
1+
v3.1.7

‎development/cleanup.sh‎

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -21,16 +21,17 @@ end;
2121
drop user ${UT3_OWNER} cascade;
2222
drop user ${UT3_RELEASE_VERSION_SCHEMA} cascade;
2323
drop user ${UT3_TESTER} cascade;
24+
drop user ${UT3_TESTER_HELPER} cascade;
2425
drop user ${UT3_USER} cascade;
2526
2627
begin
2728
for i in (
28-
select decode(owner,'PUBLIC','drop public synonym "','drop synonym "'||owner||'"."')|| synonym_name ||'"' drop_orphaned_synonym from dba_synonyms a
29+
select decode(owner,'PUBLIC','drop public synonym "','drop synonym "'||owner||'"."')|| synonym_name ||'"' drop_orphaned_synonym, owner||'.'||synonym_name syn from dba_synonyms a
2930
where not exists (select 1 from dba_objects b where (a.table_name=b.object_name and a.table_owner=b.owner or b.owner='SYS' and a.table_owner=b.object_name) )
3031
and a.table_owner not in ('SYS','SYSTEM')
3132
) loop
32-
dbms_output.put_line(i.drop_orphaned_synonym);
3333
execute immediate i.drop_orphaned_synonym;
34+
dbms_output.put_line('synonym '||i.syn||' dropped');
3435
end loop;
3536
end;
3637
/

‎development/template.env.sh‎

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ export SQLCLI=sql # For sqlcl client
44
#export SQLCLI=sqlplus # For sqlplus client
55
export CONNECTION_STR=127.0.0.1:1521/xe # Adjust the connect string
66
export ORACLE_PWD=oracle # Adjust your local SYS password
7-
export UTPLSQL_CLI_VERSION="3.1.0"
7+
export UTPLSQL_CLI_VERSION="3.1.6"
88
export SELFTESTING_BRANCH=develop
99

1010
export UTPLSQL_DIR="utPLSQL_latest_release"
@@ -13,7 +13,8 @@ export UT3_OWNER_PASSWORD=ut3
1313
export UT3_RELEASE_VERSION_SCHEMA=ut3_latest_release
1414
export UT3_TESTER=ut3_tester
1515
export UT3_TESTER_PASSWORD=ut3
16+
export UT3_TESTER_HELPER=ut3_tester_helper
17+
export UT3_TESTER_HELPER_PASSWORD=ut3
1618
export UT3_TABLESPACE=users
1719
export UT3_USER="UT3\$USER#"
1820
export UT3_USER_PASSWORD=ut3
19-

‎development/utplsql_style_check.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -40,8 +40,8 @@ select i.name, i.type, i.object_name, i.object_type, i.usage, i.line, i.col, cou
4040
and i.usage_context_id = p.usage_id
4141
where i.type like 'VARIABLE' and i.usage = 'DECLARATION'
4242
and i.object_type not in ('TYPE')
43-
and (i.name not like 'L#_%' escape '#' and p.type in ('PROCEDURE','FUNCTION','ITERATOR')
44-
or i.name not like 'G#_%' escape '#' and p.type not in ('PROCEDURE','FUNCTION','ITERATOR'))
43+
and (i.name not like 'L#_%' escape '#' and p.type in ('PROCEDURE','FUNCTION','ITERATOR','TRIGGER')
44+
or i.name not like 'G#_%' escape '#' and p.type not in ('PROCEDURE','FUNCTION','ITERATOR','TRIGGER'))
4545
and p.type != 'RECORD'
4646
order by object_name, object_type, line, col
4747
;

‎docs/about/authors.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.6.2729-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.7.3085-blue.svg)
22

33
### utPLSQL v3 Major Contributors
44

‎docs/about/license.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.6.2729-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.7.3085-blue.svg)
22

33
# Version Information
44

0 commit comments

Comments
 (0)