On Oct 12, 2011, at 4:27 PM, Pavel Ivanov wrote: > I can confirm this with the following script: > > sqlite> select a, count(case when b = 't' then 1 end), count(case when b = > 'T' then 1 end) from t group by a; > 1|2|2 > 2|1|1
Hmmm... yes... something very wrong: select a, count(case when lower( b ) = b and b = 't' then 1 end), count(case when upper( b) = b and b = 'T' then 1 end) from t group by a; 1|2|1 2|1|2 $ sqlite3 -version 3.7.8 2011-09-19 14:49:19 3e0da808d2f5b4d12046e05980ca04578f581177 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users