On Tue, 5 Apr 2016 13:19:50 -0400
Richard Hipp <drh at sqlite.org> wrote:
> CREATE TABLE t2(w SHORT INT, x DECIMAL, y BIGINT, z REAL);
> CREATE VIEW v3 AS SELECT w+x+y+z FROM t2;
>
> What should "PRAGMA table_info('v3')" report as the column type?
It should report it as for a table, with values consistent with how
SQLite will treat the column.
A fundamental rule for views is that -- for purposes of SELECT -- they
*are* tables. The fact that tables have physical representation in the
database and views are derived is, er, immaterial to the relational
algebra implemented by the DBMS.
--jkl
