Hi SQLite dev team,
I have been testing the shell-bindings branch, and encountered an issue
when setting text/blob values via the shell_bindings virtual table.
bindvtabUpdate fails to set p->len. Adding p->len = len resolves the issue.
Regards
Jake
Some ideas:
Sqlite may return that the database is locked immediately if it detects a
deadlock situation. Something like: a different connection holds a reserved
lock (waiting for read connections to close so it can promote to exclusive),
and the current connection tries to promote from a read
On 3 Jul 2018, at 8:08pm, Phani Rahul Sivalenka
wrote:
> As per our observation, the initial write operations on the sqlite db file
> throw "db is locked" error. After a certain time (around an hour) write
> operations start working and we are able to do all the operations as
> required. [...]
As per our observation, the initial write operations on the sqlite db file
throw "db is locked" error. After a certain time (around an hour) write
operations start working and we are able to do all the operations as
required.
On Mon, Jun 25, 2018 at 7:37 PM Phani Rahul Sivalenka
wrote:
> >
Thanks for the replies gents. This just caught me off guard a bit and
needed a check.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
V1 uses the value bound to the SQL Variable while performing the concatenation
of the text literal '+', the value cast as text, and the text literal 'hours'
V2 expects (wrongly) that the text literal '+:StartTimehours' magically
replaces part of the string with the value of an SQL variable
On 3 Jul 2018, at 4:22pm, Stephen Chrzanowski wrote:
> V1: *datetime(date(current_timestamp,'localtime'),'+'||:StartTime||'
> hours')))/60) MinutesSince9*
> V2: *datetime(date(current_timestamp,'localtime'),'+:StartTime
> hours')))/60) MinutesSince9 *
>
> I'm getting a failure with V2, and I'm
I'm attempting to do a simple bind for an integer.
The partial query is:
V1: *datetime(date(current_timestamp,'localtime'),'+'||:StartTime||'
hours')))/60) MinutesSince9*
V2: *datetime(date(current_timestamp,'localtime'),'+:StartTime
hours')))/60) MinutesSince9 *
I'm getting a failure with V2,
8 matches
Mail list logo