On Mon, Nov 02, 2009 at 02:21:29PM -0500, Roman Sokolyuk wrote:
Hi,
I am trying to run AGGR functions on a table - COUNT (column_name) and it looks like it counts <null>'s as well.
Using the Aug2009-SP2 release on my 64-bit Fedora 10 desktop, this appears to work fine and as expected for me: sql>select count(*) from tables; +-------+ | L7 | +=======+ | 30 | +-------+ 1 tuple sql>select count(query) from tables; +-------+ | L10 | +=======+ | 3 | +-------+ 1 tuple sql>select count(*) from tables where query is not null; +-------+ | L11 | +=======+ | 3 | +-------+ 1 tuple sql>select count(*) from tables where query is null; +-------+ | L12 | +=======+ | 27 | +-------+ 1 tuple sql> Stefan
Is there a way to prevent it?
------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |