The distinct keyword appears to be ignored when using group_concat in
a view. For example:
create table t1(data varchar);
insert into t1(data) values ('one'), ('one'), ('two'), ('three'),
('two'), ('three');
select group_concat(distinct data) from t1;
This will work as expected and return each distinct value in one row.
However:
create view v1 as (select group_concat(distinct data) from t1);
select * from v1;
That will return all 6 values in one row, instead of the expected 3.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
