On Aug 13, 2010, at 10:34 PM, Andy Chambers wrote:
> Is this a bug?
>
> create table t_distinct_bug (
> a,
> b,
> c
> );
>
> insert into t_distinct_bug values ('1', '1', 'a');
> insert into t_distinct_bug values ('1', '2', 'b');
> insert into t_distinct_bug values ('1', '3', 'c');
> insert into t_distinct_bug values ('1', '1', 'd');
> insert into t_distinct_bug values ('1', '2', 'e');
> insert into t_distinct_bug values ('1', '3', 'f');
>
> select a
> from (select distinct a, b
> from t_distinct_bug)
> => 1
>
> I'd have thought it should return
> 1
> 1
> 1
Thanks for this report. Now fixed in fossil tip. Bug here:
http://www.sqlite.org/src/info/e4b8a2ba6e
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
