On 10/12/2007, Kees Nuyt <[EMAIL PROTECTED]> wrote:
On Mon, 10 Dec 2007 12:22:53 +0100, Clodo <[EMAIL PROTECTED]>
wrote:
In this case:
-------------------------
CREATE TABLE test (
Field01 text PRIMARY KEY NOT NULL,
Field02 text
);
insert into test values ('alpha','beta');
update test set Field01='alpha', Field02='gamma';
Under the hood, the UPDATE statement above updates both the
table and index. SQLite does not realize that the index already
contains the correct data.
This:
UPDATE test set Field02='gamma';
does not touch the index.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------