Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OWB 10.1 adds parenthesis which changes the meaning of a condition

406996Nov 6 2008 — edited Nov 7 2008
When I connect two mapping table operators with a filter operator in between and I specify the filter condition as follows:

col1 is null or col1 > 5 and col2 = 10

OWB changes this into

(col1 is null or col1 > 5) and col2 = 10

which has a different meaning because in the first condition the and-operator is processed first.

Is this a known bug?
Is it still present in 10.2?

Regards,
Jaap.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2008
Added on Nov 6 2008
6 comments
563 views