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