I'm not sure if this is an error on my end or on SQLite's. I'm using 3.7.2.
I'm creating two tables as follows:
PRAGMA foreign_keys=ON;
CREATE TABLE 'users' (
'id' INTEGER NOT NULL,
'type' INTEGER NOT NULL,
'name' VARCHAR(64) NOT NULL,
PRIMARY KEY('id', 'type') ON CONFLICT REPLACE
);
ndet...@mvps.org> wrote:
From: Igor Tandetnik <itandet...@mvps.org>
Subject: Re: [sqlite] Issue using ON DELETE CASCADE along with ON
CONFLICTREPLACE
To: sqlite-users@sqlite.org
Date: Monday, October 18, 2010, 4:36 PM
NSRT Mail account. <joecool2...@yahoo.com> wrote:
> The entry
I have a database with a single table. The database is 23922826240 bytes. The
table has 2147483685 rows in it.
Running: UPDATE t SET v=1; makes my application start to use all available RAM,
then swap, and is finally killed by the OS (I do not have 23GB of free
RAM+swap).
Should running an
Looking at, http://www.sqlite.org/c3ref/open.html it seems that a function
sqlite3_open16_v2() is inexplicably missing. Is there a reason for this?
___
sqlite-users mailing list
sqlite-users@sqlite.org
sqlite3_changes() and sqlite3_total_changes() both return an int.
I ran a huge update on a table with 2147483685 rows in it, and when I was done,
the result from sqlite3_total_changes() was negative, it had overflowed to
-2147483612.
The documentation doesn't seem to indicate negative values
I believe I ran into a bug with SQLite, and would like to ensure the problem is
not on my end.
I created a simple table along with a view of it:
SQLite version 3.7.14.1 2012-10-04 19:37:12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .dump
PRAGMA
In the example, I just realized something that makes matters worse.
sqlite> SELECT "id" AS "id", "name" AS "name" FROM "names";
id|name
1|Linus
2|Bill
3|Steve
4|Richard
5|Ninjas
Despite using a view, using AS seems to remove the quotes.
In accordance with SQL standards and SQLite developing guidelines, my entire
team always uses double quotes around identifiers, and single quotes around
string literals.
Some relevant documentation is here: http://www.sqlite.org/lang_keywords.html
"SQLite adds new keywords from time to time
Hello Everyone,
I'm glad to see I'm not the only one who wants this.
I'm thinking perhaps I wasn't clear enough in my first e-mail that I created a
patch for the time being.
You can download the patch, along with already modified source, static
libraries and binaries for Linux i386, Linux
Hi Dan,
I had some free time and looked into your request. Bear in mind I don't really
know what I'm doing, but I managed to whip up this:
http://paste.nachsoftware.com/SQLite3/BrksDfe9d421e8ed00d34f0fc50a59956af21byK
Results:
> ./sqlite3
SQLite version 3.7.14.1 2012-10-04 19:37:12
Enter
10 matches
Mail list logo