On Jul 1, 2008, at 3:53 PM, Alexey Pechnikov wrote:
> В сообщении от Tuesday 01 July 2008 23:47:50
> [EMAIL PROTECTED] написал(а):
>> On Tue, 1 Jul 2008, Alexey Pechnikov wrote:
>>> Is any difference between "CREATE INDEX ev_idx ON events(type,eid)"
>>> and "CREATE INDEX ev_idx ON events(type,eid desc)"? What is "desc"
>>> keyword for index?
>>
>> The DESC keyword creates the index in descending collation order,
>> rather
>> than ascending order (default). I believe this sort order may not be
>> observed in older versions, but more recent ones do so.
>
> I'm using SQLite 3.5.9 and there are no differents in my tests
> between DESC
> and default indeces. I try create index with keywork DESC for
> optimize DESC
> sorting but it don't work for me. My tests you can see above.
>
Production tests for the descending index feature are found here:
http://www.sqlite.orc/cvstrac/fileview?f=sqlite/test/descidx1.test
http://www.sqlite.orc/cvstrac/fileview?f=sqlite/test/descidx2.test
http://www.sqlite.orc/cvstrac/fileview?f=sqlite/test/descidx3.test
Perhaps you can look at those tests and figure out what the difference
is between them and your tests.
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
