All entries for Wednesday 08 March 2006

Oracle lameness and empty sets :(

So I wanted to run a query which would return a number of rows if their ids were in a set:

  select url from page where id in (....)

This works fine.

Unfortunately it breaks horribly if the set is empty. Why? There is no mathematical ambiguity about an empty set. Why would oracle simply not return 0 rows?

: 08 Mar 2006 12:13 |  Comments (4) |  Close comments |  Report a problem