Good day -
I just downloaded & built sqlite-autoconf-318 on Linux x86_64 .
Now I would like run some some 'test suite' that will allow me to
determine if the build is OK - but there appears to be none :
$ make check
make: Nothing to be done for 'check'.
(no test runs are done - this
I am trying to make use of SQLite's multi-threading capabilities to create a
temporary table from a query .Currently, I have not had enough time to
wait for SQLite to create the temporary table ( I tried for over 2
hours) , but I
can see from the /proc/${pid}/task listing for the sqlite3 $pid
to be part of the failed transaction (and so disallows
another BEGIN TRANSACTION ).
This seems very buggy to me.
On 18/03/2015, Simon Slavin wrote:
>
> On 18 Mar 2015, at 8:11pm, Jason Vas Dias wrote:
>
>> The problem is, if this transaction runs in a session, then
>> NO
When the sqlite3 shell is used to run a long stream of commands , eg. from
a script file or input pipe from another process, how can the success / failure
status of the last statement be determined ?
IE. if the shell has just run an insert statment :
BEGIN TRANSACTION; INSERT INTO db
On 18/03/2015, Petite Abeille wrote:
>
>> On Mar 18, 2015, at 9:11 PM, Jason Vas Dias
>> wrote:
>>
>> am I missing something?
>
> rollback?
>
Would you care to expand on that ?
How is the script consisting of just the two insert statements shown
meant to de
Good day -
There appears to be a bug in the way SQLite implements transactions :
I have an insert transaction which breaks a uniqueness constraint on an index:
BEGIN TRANSACTION;
INSERT INTO db VALUES("This breaks a constraint");
COMMIT;
The problem is, if this transaction runs in a
Aargh! Thank You! Someone else's eyes do help sometimes...
On 11/03/2015, Hick Gunter wrote:
> You have swapped data and field names in the insert.
>
> -Urspr?ngliche Nachricht-
> Von: Jason Vas Dias [mailto:jason.vas.dias at gmail.com]
> Gesendet: Mittwoch, 11.
Good day -
This is the first problem I've encountered with SQLite having
used it trouble free for a number of years, so I was surprised
when I discovered I can insert data into a table that then cannot
be queried :
I have a table:
CREATE TABLE hosts
(
ip INTEGER NOT NULL ,
Good day -
This is the first problem I've encountered with SQLite having
used it trouble free for a number of years, so I was surprised
when I discovered I can insert data into a table that then cannot
be queried :
I have a table:
CREATE TABLE hosts
(
ip INTEGER NOT NULL ,
name
9 matches
Mail list logo