Hello !  

I'm testing sqlite3 trunk on existing code and noticed that the changes to
"create index" using expressions/functions is breaking on old databases.  

It seems that because I used the field name single quotes now it's
considering it an expression.  

On an old database I have the following to create an index:  

CREATE INDEX companies_number_idx ON companies ('number');  

?  

Now if I try to do anything on that database with sqlite3 trunk I get this
error message:  

malformed database schema (companies_number_idx) - indexes on expressions not
yet supported  

?

Reply via email to