This behavior is by design and originates from inside the SQLite core library.

More details can be found here:


If you still believe the behavior is not as described, please feel free to open
another ticket or send a message to the "sqlite-users" mailing list:


If you open another ticket, please give the specific database schema, SQL query,
and any other information that may help us to reproduce the issue you are seeing.