2

I recently encountered a weird situation where i get different result from the same query by only changing its scope.

What i mean by changing the scope , is putting the query inside a subquery:

I have this query:

select * from my_function

It returns the correct result, but when it's used as a subquery it gives less result :

select * from (select * from my_function)

Please note that there is no filters nor limits on rows.

my_function is a function that return a dataset like this :

return anydataset pipelined using myType;

I'm wondering if there is some (hidden) parameter in oracle 12c that might limits the result of a query when it's used in a view or a sub-query , especially if this query is using a function as source.

Thanks for your help :)

2
  • 2
    Can you provide a test case? Could be a bug as well. This is something similar: Bug 20004642 - Wrong results from query with TABLE() subquery and functions with binds (Doc ID 20004642.8) Commented Sep 6, 2016 at 9:51
  • Sorry for being late, as you mentioned, i actually use TABLE() in my query , and to resolve the problem , rewrite the whole query without using it ,and the problem was solved. Thanks @BalazsPapp
    – arabische
    Commented Sep 20, 2016 at 10:06

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.