SQLite Forum

Query performance regression after v3.33.0 (OP_SeekScan?)
Login
Should not that query be exactly equal to:

```
SELECT count(_rowid_)
  FROM edge
 WHERE EXISTS (SELECT * FROM sub_nodes WHERE node_id == node_from)
   AND EXISTS (SELECT * FROM sub_nodes WHERE node_id == node_to)
;
```

since `value IN table` means where exists a row in table where the primary key of table == value?