BBBinary BuddiesDevelopmentOct 21, 20265 min read0 views

Oracle EXISTS AND NOT EXISTS Returns a Row: Bug 35915968

A self-contradicting predicate returns a row in Oracle 19c and 21c. The cause is an optimizer rewrite bug, and there are three ways around it.

Share this article

fetch firstoracle optimizer bugoracle-databaseoracle19coracle21csql

Comments