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 Column 0 0 # ttab.col1 26 Column 0 1 # ttab.col2 27 Sequence 1 0 28 Column 0 0 # ttab.col1 29 Column 0 2 # ttab.col3 30 MakeRecord 5 0 31 IdxInsert 1 0 How I can force SQLite don't use index on grouping, and don't add duplicate column in ephemeral table? WBR, Alexandr Orefkov. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------