SQLite Forum

create unique index and order by not really unique or ordered properly
Login
That's almost impossible unless the data are differently typed per row or you are using some custom collation that almost randomizes results (though your posted schema seems to exclude the latter possibility - if that is an accurate reproduction of the real schema).

Please run:  

```
select answerid, typeof(answerid) from answers order by answerid;

PRAGMA table_info(Answers);
```

and post the results here.