I need to modify all the content in a table. So I wrap the modifications
inside a transaction to ensure either all the operations succeed, or none
do. I start the modifications with a DELETE statement, followed by INSERTs.
What I've discovered is even if an INSERT fails, the DELETE has still takes
Any reason I haven't heard back about this bug?
Thanks
_
From: Gene Connor [mailto:neothreeei...@hotmail.com]
Sent: Wednesday, April 30, 2014 12:21 AM
To: sqlite-users@sqlite.org
Subject: Bug in division?
SELECT DISTINCT 2/4 AS RESULT FROM TABLE;
returns 0
SELECT DISTINCT 2/4.0 AS
On 6 May 2014, at 2:06am, Gene Connor wrote:
> SELECT DISTINCT 2/4 AS RESULT FROM TABLE;
> returns 0
Not a bug. By providing two integer operands you have asked for integer
arithmetic, and will get an integer answer.
It's something that happens in several different languages, even C ! Worse
> Any reason I haven't heard back about this bug?
You did not get the rest of the discussion on your post? It is not a
bug but an implementation allowed behavior and has to do with integer
division.
John
___
sqlite-users mailing list
sqlite-users@sqlite
I think the OP might be seeing the list via one of those connected sites and
not getting the feedback. Maybe send a direct mail to him.
On 2014/05/06 14:48, John Drescher wrote:
Any reason I haven't heard back about this bug?
You did not get the rest of the discussion on your post? It is not a
On Tue, May 6, 2014 at 2:31 PM, Jim Carroll wrote:
>
> CREATE TABLE A(id INT PRIMARY KEY, val TEXT);
> INSERT INTO A VALUES(1, "hello");
> BEGIN;
> DELETE FROM A;
> INSERT INTO A VALUES(1, "goodbye");
> INSERT INTO A VALUES(1, "world");
> COMMIT;
Sounds like you want ON CONFLICT RO
> It would appear the DELETE was successful, and the first INSERT was
> successful. But when the second INSERT failed (as it was intended to)..it
> did not ROLLBACK the database.
Even though the second INSERT fails, your script still calls COMMIT
on an open transaction in which the DELETE and firs
Jim Carroll wrote:
> BEGIN;
> DELETE FROM A;
> INSERT INTO A VALUES(1, "goodbye");
> INSERT INTO A VALUES(1, "world");-- fails
> COMMIT;
>
> It would appear the DELETE was successful, and the first INSERT was
> successful. But when the second INSERT failed (as it was intended to)
On Tue, May 6, 2014 at 2:59 PM, Clemens Ladisch wrote:
> With the COMMIT, you told the database that the transaction succeeded
> (which means that the effects of all successful statements are saved
> permanently.) If you want the transaction to fail, execute ROLLBACK
> instead.
But that's only p
On 6 May 2014, at 1:52pm, RSmith wrote:
> I think the OP might be seeing the list via one of those connected sites and
> not getting the feedback. Maybe send a direct mail to him.
I'll send a personal email to him.
Simon.
___
sqlite-users mailing li
I observed a strange behavior. I was operating on a big table, there are
200,000 records in it. The table has a primary key or unique index, (time, id1,
id2), all of these indexed columns are integers.
The following query statement executed very slow, it took 15 secs on my ARM
device,
1. sele
Hello,
I failed to find a basic but correct Graphic User Interface program for
Sqlite in pure Python 3, with a liberal licence.
==> Did anyone know of something I may have missed ?
As I don't have great goals, I started to build a small one.
I'm posting it there in hope :
- it can be of interes
Woody Wu wrote:
> The following query statement executed very slow, it took 15 secs on my ARM
> device,
>
> 1. select max(time) from mytable where time < and id1 = k1 and id2 =
> n.
>
> However, if I replace k1with another value that can be found in the table and
> keep everything uncha
On 5/6/2014 10:19 AM, Woody Wu wrote:
I observed a strange behavior. I was operating on a big table, there are
200,000 records in it. The table has a primary key or unique index, (time, id1,
id2), all of these indexed columns are integers.
The following query statement executed very slow, it
On Mon, May 05, 2014 at 05:00:08PM -0400, Richard Hipp wrote:
> On Mon, May 5, 2014 at 4:53 PM, Patrick Donnelly wrote:
>
> > Hi,
> >
> > I have an INSERT that looks like
> >
> > INSERT INTO T
> > SELECT ...
> >
> > which I'm running numerous times a second that generally does nothing
> > beca
Are the results below expected?
$ sqlite3
SQLite version 3.8.4.3 2014-04-03 16:53:12
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE TABLE z AS SELECT NULL AS a;
sqlite> SELECT (SELECT DISTINCT COAL
It seems that foreign key errors on columns where the foreign key
definition has a constraint name don't include the constraint name in the
error message. This is using sqlite version 3.8.3.1.
Is this under the control of a compile switch or PRAGMA or am I stuck with
the way it is?
Pete
All,
Is there a way to use the "System.Data.SQLite.dll" mixed-mode assembly outside
of the GAC? Or is there a 32 bit only single file version of SQLite?
I'm running a 32 bit, non-managed code interpreted language that can't find
the SQLite.Interop.dll files if I start my program from a network
On Tue, May 6, 2014 at 5:12 PM, Peter Haworth wrote:
> It seems that foreign key errors on columns where the foreign key
> definition has a constraint name don't include the constraint name in the
> error message. This is using sqlite version 3.8.3.1.
>
> Is this under the control of a compile s
On May 6, 2014, at 11:17 PM, Richard Hipp wrote:
> It is theoretically possible to keep track of which constraints are failing
> so that the particular constraint can be identified in the error message.
> But that woudl require more memory and CPU cycles.
That would be resources well spent.
_
On Tue, May 6, 2014 at 11:24 PM, Petite Abeille wrote:
> On May 6, 2014, at 11:17 PM, Richard Hipp wrote:
>
> > It is theoretically possible to keep track of which constraints are
> failing
> > so that the particular constraint can be identified in the error message.
> > But that woudl require mo
> Interesting. It makes NO sense to return 0 when dividing two integers.
>
Never took a C/C++ class?
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I have this trivial program:
int main(int argc, char **argv)
{
lsm_db* db;
lsm_new(lsm_default_env(), &db);
lsm_open(db, "lsm");
lsm_cursor *csr;
lsm_csr_open(db, &csr);
lsm_csr_seek(csr, "a", 1, LSM_SEEK_GE);
lsm_csr_seek(csr, "a",
Drago, William @ MWG - NARDAEAST wrote:
>
> Is there a way to use the "System.Data.SQLite.dll" mixed-mode assembly
outside
> of the GAC? Or is there a 32 bit only single file version of SQLite?
>
Sure, you should be able to load the mixed-mode assembly from an arbitrary
location
using the LoadFr
On May 6, 2014, at 4:29 PM, John Drescher wrote:
>> Interesting. It makes NO sense to return 0 when dividing two integers.
>>
>
> Never took a C/C++ class?
The system does not return 0 any time you divide two integers, but it does
return zero for 2 / 4. After all, how many *whole* times
On May 6, 2014, at 5:26 PM, Gene Connor wrote:
> Subject: Re: [sqlite] Bug in division?
> From: j...@kreibi.ch
> Date: Tue, 6 May 2014 17:02:02 -0500
> CC: neothreeei...@hotmail.com
> To: sqlite-users@sqlite.org
>
> > The system does not return 0 any time you divide two integers, but it does
>
> Date: Tue, 6 May 2014 14:57:30 +0200
> From: Mark Lawrence
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] transactions do not respect delete
> Message-ID: <20140506125730.ga23...@rekudos.net>
> Content-Type: text/plain; charset=us-ascii
>
> > It would appear the DELETE was successful, and
Hi there,
We have a system which uses SQL server as a primary database. We are
thinking about replacing the entity framework provider so we can use SQLite
in-memory for integration tests.
I have done few tests and generally System.Data.SQlite works fine. The only
exception I have so far is:
My S
Christiano Borchardt wrote:
>
> My SQL server has a table with a primary key of type smallint which is an
> identity column. This is the AUTOINCREMENT equivalent on SQLite. However
> AUTOINCREMENT in SQlite only allows the Integer type.
> When the entity framework loads the entity for this table
29 matches
Mail list logo