Re: [sqlite] sqlite3_changes() != 0 after SELECT

[Ben Summers]

D. Richard Hipp wrote:

Ben Summers wrote:

> Hi,
>
> I'm finding that in version 3, sqlite3_changes() != 0 after a SELECT query has been executed.

What's the query?

I found this in a simple program which tests my database interface code.

The table is

CREATE TABLE tTest1 (
        fID INTEGER PRIMARY KEY,
        fInteger INTEGER,
        fString VARCHAR(32)
);

then I do four inserts like

  INSERT INTO tTest1(fInteger,fString) VALUES(245,'string')

(after which sqlite3_changes() returns 1), and then the query

  SELECT fInteger,fString FROM tTest1 ORDER BY fInteger;

after which it still returns 1.

Sqlite v2.x returns 0 as expected.

Thanks,

Ben