On 13 August 2010 16:34, Andy Chambers <achambers.h...@gmail.com> 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
>
> I'm on SQLite 3.6.22
Doesn't look right to me. I can confirm same results with 3.7.0.1 (Windows 7)
>
> --
> ----
> Andy Chambers
> Formedix Ltd
Regards,
Simon
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
