Jesse Long wrote:
> 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.
>
Further: this actually works: (notice the "on" expression in the first
inner join)
select * from candidate a inner join candidate b on 1 = 1 left outer join pref
on
b.id = pref.aid;
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.
