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
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
> 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
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
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
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
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:
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
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]
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
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
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
12 matches
Mail list logo