SQLite Forum

Bug: unexpected result from an empty table
Login
OK, thank you for your explanation and update to the documentation.

We have realized that it is a bare column, but it was not clear what the value of the column should be when the result set is empty. We used to think that "arbitrary" refers to "any one in the result set". When the result set is empty, it can only be NULL. Your update to the documentation has well corrected our thoughts and answered our doubts.