JOINED DERIVED TABLE
      
Problem:
Post the bugfix for Bug#11760197 count distinct on a const value was
always made to return 1 irrespective of whether the join results were
empty.
      
Solution:
count is set to '1' only after finding atleast one tuple in the result.