Bug 10202228 wrong result when _allow_level_without_connect_by set to true This
Bug 10202228 wrong result when _allow_level_without_connect_by set to true
This note gives a brief overview of bug
10202228.
The content was last updated on: 25-OCT-2011
Click here for details of each of the sections below.
Affects:
Product (Component) |
oracle Server (Rdbms) |
Range of versions believed to be affected |
Versions >= 11.2.0.1 but BELOW 12.1 |
Versions confirmed as being affected |
|
PlatfORMs affected |
Generic (all / most platforms affected) |
Fixed:
This issue is fixed in |
|
|||
Symptoms: |
Related To: |
|||
|
|
|||
Description
If a select query with,
1. level pseudo column
2. no connect-by clause
3. "_allow_level_without_connect_by" = true
4. plan_table output shows missing filter predicate
5. Wrong result (more rows than expected)
HOOKS parameter:_allow_level_without_connect_by LIKELYAFFECTS XAFFECTS_11.2.0.1 XAFFECTS_V11020001 AFFECTS=11.2.0.1 XAFFECTS_11.2.0.2 XAFFECTS_V11020002 AFFECTS=11.2.0.2 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_CONNECTBY TAG_WRONGRES CONNECTBY WRONGRES FIXED_11.2.0.3 FIXED_12.1.0.0
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support. |
--结束END--
本文标题: Bug 10202228 wrong result when _allow_level_without_connect_by set to true
本文链接: https://www.lsjlt.com/news/48076.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-16
2024-05-16
2024-05-16
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0