Removed drops of coverage tables.

jgebal · jgebal · commit 1475fcfcd67b · 2017-03-03T00:15:16.000Z
diff --git a/source/core/coverage/install_profiler_tables.sql b/source/core/coverage/install_profiler_tables.sql
@@ -0,0 +1,3 @@
+whenever sqlerror continue
+@@proftab.sql
+whenever sqlerror exit failure rollback
diff --git a/source/core/coverage/proftab.sql b/source/core/coverage/proftab.sql
@@ -1,5 +1,3 @@
-whenever sqlerror continue
-
 create table plsql_profiler_runs
 (
   runid           number primary key,  -- unique run identifier,
@@ -61,4 +59,3 @@ comment on table plsql_profiler_data is
 
 create sequence plsql_profiler_runnumber start with 1 nocache;
 
-whenever sqlerror exit failure rollback
diff --git a/source/install.sql b/source/install.sql
@@ -83,7 +83,7 @@ whenever oserror exit failure rollback
 @@core/ut_assert_processor.pkb
 
 --gathering coverage
-@@core/coverage/proftab.sql
+@@core/coverage/install_profiler_tables.sql
 @@core/coverage/ut_coverage_sources_tmp.sql
 @@core/coverage/ut_coverage_helper.pks
 @@core/coverage/ut_coverage_helper.pkb
diff --git a/source/uninstall.sql b/source/uninstall.sql
@@ -67,18 +67,10 @@ drop type ut_coverage_file_mapping;
 
 drop package ut_coverage_helper;
 
-drop table plsql_profiler_data cascade constraints;
-
-drop table plsql_profiler_units cascade constraints;
-
-drop table plsql_profiler_runs cascade constraints;
-
 drop view ut_coverage_sources_tmp;
 
 drop table ut_coverage_sources_tmp$;
 
-drop sequence plsql_profiler_runnumber;
-
 drop package ut_teamcity_reporter_helper;
 
 drop package ut_runner;

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+whenever sqlerror continue`
	`2`	`+@@proftab.sql`
	`3`	`+whenever sqlerror exit failure rollback`
Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,3 @@`
`1`		`-whenever sqlerror continue`
`2`		`-`
`3`	`1`	`create table plsql_profiler_runs`
`4`	`2`	`(`
`5`	`3`	`runid number primary key, -- unique run identifier,`
`@@ -61,4 +59,3 @@ comment on table plsql_profiler_data is`
`61`	`59`
`62`	`60`	`create sequence plsql_profiler_runnumber start with 1 nocache;`
`63`	`61`
`64`		`-whenever sqlerror exit failure rollback`