Project:
| View Revisions: Issue #37322 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0037322: Remove technically useless ad_process entries | ||
| Revision | 2021-07-16 14:11 by shuehner | ||
| Steps To Reproduce | a.) select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and p.procedurename is null and p.classname is null and p.jrname is null order by p.ad_process_id b.) select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and not exists (select 1 from information_schema.routines r where r.routine_schema = 'public' and r.routine_name ilike p.procedurename) and p.procedurename is not null and p.procedurename <> 'DBA_Recompile' and p.classname is null and p.jrname is null; |
||
| Revision | 2017-11-18 13:25 by shuehner | ||
| Steps To Reproduce | a.) select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and not exists (select 1 from information_schema.routines r where r.routine_schema = 'public' and r.routine_name ilike p.procedurename) and p.procedurename is null and p.classname is null and p.jrname is null order by p.ad_process_id b.) select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and not exists (select 1 from information_schema.routines r where r.routine_schema = 'public' and r.routine_name ilike p.procedurename) and p.procedurename is not null and p.procedurename <> 'DBA_Recompile' and p.classname is null and p.jrname is null; |
||
| Revision | 2017-11-18 13:17 by shuehner | ||
| Steps To Reproduce | a.) select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and not exists (select 1 from information_schema.routines r where r.routine_schema = 'public' and r.routine_name ilike p.procedurename) and p.procedurename is null and p.classname is null and p.jrname is null order by p.ad_process_id |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |