RE: [sqlite] using "+" for avoiding using indexes in "group by"

Hi. > You can't. > > Why are you trying to avoid the use of indices? Most people > like it when their indices make an ORDER BY go faster. And > why are you worried about duplicate data in a transient > table, as long as you are getting the correct answer? > Thanks for reply. Just in real

Re: [sqlite] using "+" for avoiding using indexes in "group by"

"orefkov" <[EMAIL PROTECTED]> wrote: > Hi All. > > When I used "+" for avoiding using indexes in "order by" list, > this cause a duplicate columns in ephemeral "sort" table. > > Example: > > "select col1, col2, sum(col3) from ttab group by +col1, col2" > > In this case, ephemeral table contain

[sqlite] using "+" for avoiding using indexes in "group by"

Hi All. When I used "+" for avoiding using indexes in "order by" list, this cause a duplicate columns in ephemeral "sort" table. Example: "select col1, col2, sum(col3) from ttab group by +col1, col2" In this case, ephemeral table contain 5 columns, where column 0 and 3 are duplicate: 25 Col