No subject


Tue Nov 9 20:19:56 GMT 2010


select count(distinct (a,b,c)) from A where xxx

Note the extra () around the column list. I think also the above may be
more correct from an sql standpoint?

At the moment, using storm's current implementation of Count() you get
the following error:

ProgrammingError: function count(integer, integer, integer, integer)
does not exist LINE 1: SELECT COUNT(DISTINCT a,b,c) ... HINT: No
function matches the given name and argument types. You might need to
add explicit type casts.

I have fixed it locally by providing my own implementation of Count().
Am I correct in assuming this is a bug? If so, I'll go ahead and raise a
bug in Launchpad.







More information about the storm mailing list