Hi,
Yes, I can't reproduce the problem. Could you provide a reproducible
test case? From what you wrote, I created the following script. I had
to change quite a lot to make it actually work:
drop all objects;
create table some_table(id int primary key, some_id int, another_id int);
insert into some_table values(1, 2, 3);
create table acme(id int primary key, some_id int, status int, svs_id int);
insert into acme values(1, 2, 3, 4);
create table svs(id int primary key, status int);
insert into svs values(1, 2);
create view if not exists some_view as
select a.id,
a.status,
count(svs.id) as vulnerabilities,
(select max(id) from acme where id < a.id and some_id = 2) previous_a_id
from acme a
left outer join svs on a.svs_id = svs.id
group by a.id, a.status;
select some_view.id from some_view inner join some_table on
some_view.id=some_table.id where some_table.another_id in (1, 2, 3);
Regards,
Thomas
--
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.
