simple SQL queries give different results: Why?

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Tue, 8 Feb 2011 17:39:28 -0800
Message-ID: <AANLkTinoMopEREyS8FB2tU2So9+N5yr0+QD8FGwQWWap_at_mail.gmail.com>

The only difference is the MAX function.

SQL> SELECT d1.dummy
  FROM DUAL d1
 WHERE NOT EXISTS
(SELECT MAX(1)

             FROM DUAL d2
            WHERE d2.dummy = 'z')

no rows selected.

SQL> SELECT d1.dummy
  FROM DUAL d1
 WHERE NOT EXISTS
(SELECT 1

             FROM DUAL d2
            WHERE d2.dummy = 'z')

DUMMY

---

X
1 row selected.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 08 2011 - 19:39:28 CST