On Sat, 7 Jan 2017 10:58:56 +0100
gwenn <gwenn.k...@gmail.com> wrote:
> After 3.16,
> sqlite3_step returns SQLITE_DONE
> and
> sqlite3_column_count does not return 0 but 6
That is the correct answer. The function returns a set of rows.
Every invocation returns the same number of columns. Some invocations
return more rows than others; some return zero rows.
The column definitions of a SELECT statement are not affected by the
WHERE clause.
select * from T where 0 = 1;
returns all rows of T meeting the criterion. The fact that no rows meet
the criterion does not change their definition.
--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
