utPLSQL / Bugs Archive (Use GitHub now) / #32 utassert2.ieqminus

Paul Walker - 2013-10-12

Status: open --> Open

Priority: 5 --> Medium
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Paul Walker - 2013-10-12

Fixed in version: --> [none]
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Svyatoslav Chatchenko - 2014-04-04

I did changes, that ticket creator had mentioned
attachements:
ut_assert2.pkb.zip - patch
ut_utassert.zip - test package. just two simple tests. test 1 - reveal bug. test 2 - show workarround
testresult_before_changes.zip - log for test run before changes
testresult_after_changes.zip - log for test run after changes

testresult_after_changes.zip

testresult_before_changes.zip

ut_assert2.pkb.zip

ut_utassert.zip

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Paul Walker - 2014-04-06

Great, thanks. I'll setup an SVN branch with your changes as soon as I get chance

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Description has changed:

Diff:

--- old
+++ new
@@ -1,2 +1,2 @@
-I tried to use utAssert.eqquery and added as against\_this\_in parameter value "SELECT 1 FROM dual UNION ALL SELECT 2 FROM dual". It is propagated to procedure ieminus\(\) where the UNION ALL makes it fail. I can make a workaround when I add parenthesis around the parameter but I think that it makes much more sense when ieminus\(\) do that.
+I tried to use `utAssert.eqquery` and added as `against_this_in` parameter value `SELECT 1 FROM dual UNION ALL SELECT 2 FROM dual`. It is propagated to procedure `ieminus()` where the `UNION ALL` makes it fail. I can make a workaround when I add parenthesis around the parameter but I think that it makes much more sense when `ieminus()` do that.
 BTW I am willing to join the developers team if you allow me to. BR

assigned_to: Paul Walker
Seen in version: --> [other - please specify]
Oracle version: --> [Unknown]

Paul Walker - 2014-04-21

[r160] - Made a development branch
[r161] - Applied patch as provided by Svyatoslav Chatchenko above

Related

Commit: [r160]
Commit: [r161]

Last edit: Paul Walker 2014-04-21

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Paul Walker - 2014-04-21

I have tested this and it appears to work as expected. Merging with trunk ready for next release [r162]

Related

Commit: [r162]

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Paul Walker - 2014-04-21

status: Open --> Closed-Fixed

Fixed in version: [none] --> [next]
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

utassert2.ieqminus - missing parenthesis

Fixed in version

Searches

Help

#32 utassert2.ieqminus - missing parenthesis

Related

Discussion

Related

Related