There shouldn't be any nulls.  The records were all added by a "Copy Into" command.  The files that we imported had no nulls in it at all.

On 03/24/2012 01:57 AM, Sjoerd Mullender wrote: 
On 2012-03-24 00:14, Joseph Brower wrote:

We were troubleshooting some odd results coming back from our database, 
and found that it's missing some entries from a column.  This appears to 
be causing some sort of offset.  Does anyone have any ideas on what can 
be done to resolve it or what may have caused it?  Is there any 
information we could send that would be helpful in troubleshooting this 
or for a bug report?

If we do a count(*) and then a count('single_column') we are getting two 
different results (when they should be indentical)

count (*) counts all rows, whereas count(single_column) only count
non-null values.  Are there any nulls in the single_column?





------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure


_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users