Re: [sqlite] [EXTERNAL] Comparison of incompatible types

2019-09-15 Thread Hick Gunter
This is well documented in https://sqlite.org/datatypes.html and https://sqlite.org/datatype3.html -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von kapil Gesendet: Samstag, 14. September 2019 11:15 An: sqlite-users@mailingl

Re: [sqlite] Bug: WINDOW clause within a CTE

2019-09-15 Thread Dan Kennedy
On 15/9/62 11:57, Jake Thaw wrote: The following examples demonstrate a possible bug when using a WINDOW clause within a CTE: SQLite version 3.30.0 2019-09-14 16:44:51 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent data