On Mon, Apr 8, 2019 at 7:58 PM Jim Dossey <jim.dos...@gmail.com> wrote:
> I think I found an error in the documentation here: > https://www.sqlite.org/datatype3.html#column_affinity_for_views_and_subqueries > < > https://www.sqlite.org/datatype3.html#column_affinity_for_views_and_subqueries > > > > It defines the table and view: > CREATE TABLE t1(a INT, b TEXT, c REAL); > CREATE VIEW v1(x,y,z) AS SELECT b, a+c, 42 FROM t1 WHERE b!=11; > > It then states "The affinity of the v1.x column will be the same as the > affinity of t1.b (INTEGER), since v1.x maps directly into t1.b.". > > However column t1.b is TEXT, not INTEGER. > How to do determine that exactly? Via SQL? Debugging? There's no way to get "directly" the affinity of a column, that I know of, you can only infer it from side-effects I believe. Thus my curiosity. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
