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
--
----
Andy Chambers
Formedix Ltd
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
