SQLite Forum

I did some checking.  Your "expected behavior" is what MySQL does.  The
"actual behavior" is what PostgreSQL does.  I think SQLite should continue
to do what PostgreSQL does.