[sqlite] Function lower on index expressions not allowed ?

[Domingo Alvarez Duarte]

Hello !  

I'm converting a database from postgresql and when I tried to create this
index it fails:  

CREATE UNIQUE INDEX country_name_idx on country(lower(name));  

Error: "non-deterministic functions prohibited in index expressions"  

Can the lower function be non deterministic ?  

I know that there is the "collate nocase" but to test the new functionality I
tried as is.  

Cheers !