I am evaluating SQLite for a project I am working on.
I have a question about the behavior of the INTEGER PRIMARY KEY auto
increment feature.
My platform uses 32 bit integers, so the valid values for an unsigned
integer are 0 - 4294967296 and the valid values for a signed integer are
-2147483648
October 13, 2007 5:29 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] INTEGER PRIMARY KEY Auto Increment Rollover
Question
Hallo Odekirk Shawn,
SQLite use up to an 64Bit signed Integer for Primary Keys, even on non
64Bit-Systems!
Integer PrimaryKeys are always autoincrementing. When you don't s
Brickl Roland [mailto:[EMAIL PROTECTED] wrote:
> Integer PrimaryKeys are always autoincrementing. When you don't
> specify it it uses after (2^63)-1 a random free positiv value.
"Odekirk, Shawn" <[EMAIL PROTECTED]> wrote:
> I will compile this for Windows and s
>> Brickl Roland [mailto:[EMAIL PROTECTED] wrote:
>> Integer PrimaryKeys are always autoincrementing. When you don't
>> specify it it uses after (2^63)-1 a random free positiv value.
>> "Odekirk, Shawn" <[EMAIL PROTECTED]> wrote:
>> I will c
--- [EMAIL PROTECTED] wrote:
> Well, I'm not looking for shell.c or main.c ... perhaps the build
> process is , but not me.
Maybe you should tell us what you are trying to do.
I see some TCL stuff in there. I can't help you with that.
However, I can tell you that the command "cc sqlite3.c -o sqli
The sqlite3_last_insert_rowid function is completely, 100% reliable in your
scenario. The problem is that in your scenario you shouldn't be calling that
function.
The function is called sqlite3_last_insert_rowid, not
sqlite3_last_insert_or_ignore_rowid, and not sqlite3_last_insert_or_fail_rowid
This link gives a little more information:
http://www.sqlite.org/autoinc.html
Shawn
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Monday, October 29, 2007 10:57 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()
S
Adding "primary key" to column "a" results in the behavior I think you
were first expecting.
sqlite> create table tmp (a integer primary key, b integer);
sqlite> create unique index tmpIndex on tmp (a, b);
sqlite> insert into tmp values (1, 1);
sqlite> insert into tmp values (2, 2);
sqlite> select
I'm sorry if this is not the correct forum for this question, but does
anyone know if the digest mailing list is working? I have tried to
subscribe several times but it doesn't seem to work.
I assume that the digest will be one email each day containing all of
the posts to the regular mailing lis
I have recently upgraded an old system that managed its data in a
dynamically allocated linked list to use SQLite instead. I have been
extremely pleased with SQLite. Most operations have been greatly
simplified and I am much more confident in the stability of the system
and the integrity of the dat
Thank you all for your responses. This discussion has grown a lot more
than I thought it would.
Like I said in my original question, my system is made up of several
programs that communicate by sending messages to each other. I have a
utility program that can send messages to the programs for testi
>> I am not using BEGIN IMMEDIATE, just BEGIN, but I don't think it is a
>> problem in my case, since now there really is just one program
accessing
>> the database.
>
>Did you forget the message this thread was started from? The sqlite3
>command line utility is a second program, so this could be a
I will be out of the office beginning next week and was planning to turn
on the out of office auto reply in my email client, but I would like to
avoid spamming the group. I noticed a couple auto replies got through to
the group earlier in the week.
Is there anything I should do on my end to minimiz
13 matches
Mail list logo