Re: [sqlite] bug: output contains values of a column not listed in SELECT

2010-03-31 Thread Dan Kennedy
On Mar 31, 2010, at 10:23 AM, Kirill Simonov wrote: > Hi, > > I encountered a weird bug. My query has the form > SELECT col_x, ... FROM my_table ... GROUP BY 1 > but the output of the query looks as if it was produced by a query of > the form > SELECT col_y, ... FROM my_table ... GROUP B

[sqlite] bug: output contains values of a column not listed in SELECT

2010-03-31 Thread Kirill Simonov
Hi, I encountered a weird bug. My query has the form SELECT col_x, ... FROM my_table ... GROUP BY 1 but the output of the query looks as if it was produced by a query of the form SELECT col_y, ... FROM my_table ... GROUP BY 1 That is, instead of values of col_x, I'm getting values of c