Hi,
I'm not sure if this is a bug, or just me abusing the grammar. h2-1.2.125.
create table candidate (id int not null auto_increment, name varchar not
null unique);
insert into candidate (name) values ('A'), ('B');
create table pref (fid int not null references candidate (id), aid int
not null references candidate (id), weight int not null);
insert into pref values (1, 2, 0);
select * from candidate a inner join candidate b on b.id = 2;
-- ^ this works
select * from candidate a inner join candidate b where b.id = 2;
-- ^ this works
select * from candidate a inner join candidate b left outer join pref on
b.id = pref.aid;
-- ^ this throws the following error:
-- Column "B.ID" not found; SQL statement:
-- select * from candidate a inner join candidate b left outer join pref
on b.id = pref.aid [42122-125] 42S22/42122
Sorry to report this so late on a planned release day.
Thanks,
Jesse
--
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.
