On 5/28/2013 8:06 AM, Dave Wellman wrote:
However, if I ran "SELECT QUERYID,COUNT(*) FROM table GROUP BY 1;" I get two
rows in my answer set. They both 'look' like they contain a value of 1, but
obviously they are different to the dbms.
Try this:
select QUERYID, typeof(QUERYID), hex(QUERYID), len(QUERYID), count(*)
from MyTable group by 1;
This should collect enough information to determine the actual contents
of the column. Post the results here if you have difficulty interpreting
them.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
