RDBPROD: Wrong Result In SQL query involving a join and count function.
(Doc ID 2020586.1)
Last updated on APRIL 14, 2022
Applies to:Oracle Rdb Server on OpenVMS - Version 22.214.171.124 to 126.96.36.199 [Release 7.3]
HP OpenVMS Alpha
HP OpenVMS Itanium
Query generates incorrect results if the columns in the where clause are re-arranged, for example "where a.columnx = b.columnx" to "where b.columnx = a.columnx".
The query in question was a join:
Upgrade to 188.8.131.52
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document