4 comments by 3 or more people

1. John Dale

   Why, God, why?

   08 Mar 2006, 13:39

2. :)

   It is particularly frustrating because it isn't intuitive and managed to escape the plethora of unit tests and integration tests because it never occurred to me that it would be a problem :)

   Oh well…..

   08 Mar 2006, 14:04

3. Chris May

   it's bizarre. This fail works:

   SQL> select * from dual where dummy in ();
   select * from dual where dummy in ()
                                      *
   ERROR at line 1:
   ORA-00936: missing expression

   but this works fine

   SQL> select * from dual where dummy in (select dummy from dual where 1 = 0);  
   
   no rows selected    

   It seems to be something as lame as oracle's parser not understanding that () is the empty set. Wierd.

   08 Mar 2006, 20:57

4. Chris May

   … though not as weird as my spelling.

   08 Mar 2006, 20:58