Re: [Haskelldb-users] composing relational operations with aggregate expressions

[Matthias R. <mat...@so...>]

Bjorn,

Bjorn Bringert <bri...@cs...> writes:

> Try changing line 187 in Optimize.hs to
>
>           	= not (any (isAggregate.snd) assoc)
>
> Let me know if that helps and I'll fix it in darcs.

That seems to do the trick. Thanks! I now get

SELECT DISTINCT count6 as count
FROM  (SELECT DISTINCT COUNT(id5) as count6
       FROM  ((SELECT DISTINCT id as id5
               FROM  table1 as T1)
              EXCEPT
              (SELECT DISTINCT id as id5
               FROM  table2 as T1)) as T1) as T1

The outer select is unnecessary but harmless.


Matthias