[sqlite] Expecting syntax error on delete

[Richard Williams]

I have a PHP program where I have the equivalent of the following code. The
code was not deleting the expected rows ('abc' & 'def') because of the bad
syntax. However the error did not throw an exception. Is this what I should
expect?

$p = new PDO('sqlite::memory:');
$p->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$p->exec("create table a (a text)");
$sql = "delete from a where a in (a in ('abc','def'))";
$stat = $p->exec($sql);