SQLite Forum

DROP TABLE failure - is it intentional or a bug?
Login
I think some of the difficulty with non-deterministic functions used in virtual column values is that it can cause an index on such columns to become invalid without the DBMS being able to discern that it needs modification.  It's a concern that is orthogonal to whether users know what they are doing.