search

rsim / ruby-plsql-spec

Oracle PL/SQL unit testing with Ruby
MIT License
68 stars 25 forks source link

Coverage report looks wrong for triggers #34

Open danbroun opened 8 years ago

danbroun commented 8 years ago

If I have a look at a coverage report of a package every green/red and gray line is understandable. A coverage report for a trigger looks extremely random.

Can anyone confirm this behavior?

jgebal commented 8 years ago

A steps to reproduce or a working example of bad behavior would help

danbroun commented 8 years ago

Just create for example an insert trigger and then write a test which inserts data into the example table. If you have a look at the produced coverage report the marking which line were run looks really random. If you want I can try to attach a example report. Hope I can make it this week.

javornikolov commented 8 years ago

@danbroun, may you also check PLSQL_OPTIMIZE_LEVEL option which has been used to compile the trigger? For better coverage output it's best to use 1.