Re: [sqlite] VTable Column Affinity Question and Change Request

2020-02-05 Thread Keith Medcalf
On Wednesday, 5 February, 2020 18:10, Jens Alfke : >> On Feb 5, 2020, at 9:58 AM, Keith Medcalf wrote: >> It seems that "column affinities" are not respected in Virtual Table >> implementations -- that is the value that is returned is the datatype >> provided by the the vtab_cursor sqlite3_resu

Re: [sqlite] Patch: VTable Column Affinity Question and Change Request

2020-02-05 Thread Keith Medcalf
Patch to Fix Column Affinity not applied to Virtual Columns. In expr.c function sqlite3ExprCodeGetColumnOfTable At or about line 3555 where the OP_Column or OP_VColumn opcode is added to the VDBE program, and the default code is generated, make this: sqlite3VdbeAddOp3(v, op, iTabCur, x, reg

Re: [sqlite] VTable Column Affinity Question and Change Request

2020-02-05 Thread Jens Alfke
> On Feb 5, 2020, at 9:58 AM, Keith Medcalf wrote: > > It seems that "column affinities" are not respected in Virtual Table > implementations -- that is the value that is returned is the datatype > provided by the the vtab_cursor sqlite3_result_* function and the "column > affinity" from the

Re: [sqlite] unsafe use of virtual table

2020-02-05 Thread tom-sqlite
Ah I see now. Thank you Keith! Tom Message: 14 Date: Tue, 04 Feb 2020 14:57:06 -0700 From: "Keith Medcalf" To: "SQLite mailing list" Subject: Re: [sqlite] unsafe use of virtual table Message-ID: <62147479ae781d49902e13c3c23a3...@mail.dessus.com> Content-Type: text/plain; charset="utf-8" This

[sqlite] VTable Column Affinity Question and Change Request

2020-02-05 Thread Keith Medcalf
It seems that "column affinities" are not respected in Virtual Table implementations -- that is the value that is returned is the datatype provided by the the vtab_cursor sqlite3_result_* function and the "column affinity" from the vtab declaration is not applied. In effect the column affinity

[sqlite] WikiTribune Duos

2020-02-05 Thread Klaas van Buiten V
L.S., Today I created a subWiki @wtSocial called DUOS: Developers+Users Of SQLite For all of you interested to participate this forum can be found here: https://wt.social/wt/duos-developersusers-of-sqlite Kind regards, Klaas ‘Z4us’ van B. V ___ sqlite

Re: [sqlite] csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines

2020-02-05 Thread Keith Medcalf
On Tuesday, 4 February, 2020 22:31, Keith Medcalf wrote: The vsv.c (source) file line counting is now verified and I have added a skip= parameter. Adding skip was far easier than variable separators ... Same location, file updated: http://www.dessus.com/files/vsv.c The complete collection:

Re: [sqlite] Table has different rootpage in EXPLAIN and sqlite_master

2020-02-05 Thread curmudgeon
You were correct David. The explain rootpage referred to an index and I was checking against the table rootpage. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.s

Re: [sqlite] [EXTERNAL] Unsubscribe from Sqlite users list

2020-02-05 Thread Hick Gunter
Visit the link given at the bottom of every message, including this one -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Ainhoa B Gesendet: Mittwoch, 5. Februar 2020 15:11 An: SQLite mailing list Betreff: [EXTERNAL] [sqlite]

Re: [sqlite] Unsubscribe from Sqlite users list

2020-02-05 Thread David Raymond
Follow the link at the bottom of every email. The bottom box/button on the page is for unsubscribing. http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -Original Message- From: sqlite-users On Behalf Of Ainhoa B Sent: Wednesday, February 5, 2020 9:11 AM To: SQLite ma

[sqlite] Unsubscribe from Sqlite users list

2020-02-05 Thread Ainhoa B
Hi, I would like to unsubscribe from this list and stop receiving messages, but I do not know how to do it. Can someone help me? Thanks! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/l

Re: [sqlite] [EXTERNAL] Re: Please increase the default for SQLITE_MAX_VARIABLE_NUMBER

2020-02-05 Thread Hick Gunter
WHERE x IN carray($PTR, $DIM) With $PTR being the address of the array and $DIM ist cardinality. Should be tons faster than parsing and binding a gazillion parameters. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Deon B