Re: [sqlite] internal column header not case sensitive?

On Oct 12, 2011, at 5:28 PM, Simon Slavin wrote: > Was that not what you were expecting ? You are using count(2) not sum(2). I don't see why the result I am expecting would be different between count or sum. I wasn't try to get the values, 1 or 2 just results in a unique difference but the

[sqlite] internal column header not case sensitive?

I am having an issue where I build a query that creates columns based on case expressions. The expressions are identical except for a case difference. The result only shows data from the first expression duplicated in both columns. The query that results in the issue: select mycategory,