SQLite Forum

INSERT with RETURNING causes duplicate rows
Login
This is all I am doing. This is how to reproduce what I am seeing.

## SQLite Shell - 3.35.5 2021-04-19 18:32:05
```sql
sqlite> CREATE TABLE profile
(
    profile_id INTEGER     PRIMARY KEY autoincrement,
    name       VARCHAR(64),
    email      VARCHAR(255),
    age        INT         NOT NULL DEFAULT 0,
    created    VARCHAR(20) NOT NULL DEFAULT CURRENT_TIMESTAMP
);
sqlite> select * from profile;

-- run the below php code

sqlite> select * from profile;
profile_id  name      email        age  created            
----------  --------  -----------  ---  -------------------
1           Adam Fry  a@gmail.com  47   2021-06-13 14:54:08
2           Adam Fry  a@gmail.com  47   2021-06-13 14:54:08
sqlite>
```

## PHP Code - 7.4.20 w/SQLite 3.35.5
```php
$db = new SQLite3('tests/file.db');

$result = $db->query("INSERT INTO profile (age, email, name) VALUES (47, 'a@gmail.com', 'Adam Fry') 
    RETURNING profile_id, email");
print_r($result->fetchArray(SQLITE3_ASSOC));

$db->close();
```