Re: [sqlite] Issue with index (maybe asc/desc problem)

Thanks for the quick answer. This product is great! Bye! Clodo <[EMAIL PROTECTED]> wrote: But a changelogs say: "Version 3.3.0 adds support for CHECK constraints, DESC indices, " I use the 3.5.2 version. What's the status/problem about that? How i can re-write the first select above to

Re: [sqlite] Issue with index (maybe asc/desc problem)

--- [EMAIL PROTECTED] wrote: > DESC indices requires a backwards-compatible file format > changes. Older versions of SQLite (prior to 3.3.0) cannot > read or write databases that make use of DESC indicdes. > To preserve compatibility, SQLite generates databases in > the old format by default.

Re: [sqlite] Issue with index (maybe asc/desc problem)

Clodo <[EMAIL PROTECTED]> wrote: > > But a changelogs say: > "Version 3.3.0 adds support for CHECK constraints, DESC indices, " > > I use the 3.5.2 version. > What's the status/problem about that? > How i can re-write the first select above to use an index on both fields? > Thanks! > DESC

[sqlite] Issue with index (maybe asc/desc problem)

Hi to all, i have a problem with indexes. For example: CREATE TABLE T1 ( a text, b text ); CREATE INDEX I1 on T1 (a asc, b desc); 1' query: explain query plan select * from t1 order by a asc, b desc limit 10 output detail-> TABLE T1 2' query: explain query plan select * from t1 order by a