RDBPROD: Wrong Result In SQL query involving a join and count function.
(Doc ID 2020586.1)
Last updated on SEPTEMBER 04, 2018
Applies to:Oracle Rdb Server on OpenVMS - Version 184.108.40.206 to 220.127.116.11 [Release 7.3]
HP OpenVMS Itanium
HP OpenVMS Alpha
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 18.104.22.168
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