On 4/9/19, Dominique Devienne <[email protected]> wrote:
>>
>> 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?
If you compile with -DSQLITE_DEBUG, then there is a new undocumented
function affinity(). After inserting a row into table t1:
INSERT INTO t1 values(1,2,3);
You can do:
SELECT affinity(x), affinity(y), affinity(z) FROM v1;
And get the answer:
'text','none','none'
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
