Nemanja Corlija wrote:

I think in any other case unique index would be created as expected.

sqlite> drop table test;
sqlite> create table test (ni integer, pk_name varchar(32) primary key, info integer);
sqlite> pragma index_list(test);
0|sqlite_autoindex_test_1|1
sqlite> pragma table_info(test);
0|ni|integer|0||0
1|pk_name|varchar(32)|0||1
2|info|integer|0||0
sqlite>

that seems to be correct... interesting, thanks,

Mario

Reply via email to