RDBPROD: Wrong Result In SQL query involving a join and count function.
(Doc ID 2020586.1)
Last updated on FEBRUARY 21, 2019
Applies to:Oracle Rdb Server on OpenVMS - Version 188.8.131.52 to 184.108.40.206 [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 220.127.116.11
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