Re: [sqlite] Error in docs

On Tue, Apr 9, 2019 at 9:41 AM Richard Hipp wrote: > On 4/9/19, Dominique Devienne 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

Re: [sqlite] Error in docs

On 4/9/19, Dominique Devienne 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),

Re: [sqlite] Error in docs

On Mon, Apr 8, 2019 at 7:58 PM Jim Dossey 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

[sqlite] Error in docs

I think I found an error in the documentation here: 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

Re: [sqlite] Error in docs for WHERE clause in CREATE INDEX

Fixed in the draft documentation. On 10/4/17, Jens Alfke wrote: > From https://www.sqlite.org/partialindex.html > : > >> The WHERE clause may not contain subqueries, references to other tables, >> non-deterministic functions, or

[sqlite] Error in docs for WHERE clause in CREATE INDEX

From https://www.sqlite.org/partialindex.html : > The WHERE clause may not contain subqueries, references to other tables, > non-deterministic functions, or bound parameters. The LIKE, GLOB, MATCH, and > REGEXP operators in SQLite are implemented as