24 Mar
2012
24 Mar
'12
7:57 a.m.
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? -- Sjoerd Mullender