Little whine about an error message

[Bryan Pendleton <bp...@amberpoint.com>]

When I mistype 'join' as 'joing', the error message that I
get actually complains about the word 'left'. It ought to,
in my opinion, complain about the word 'joing', since that
is truly the word with the syntax error in it.

ij> select * from t1 left outer joing t2 on t1.c2=t2.c1;
ERROR 42X01: Syntax error: Encountered "left" at line 1, column 18.

I don't know if this is a PITA to fix or not, but I thought
I'd send it along anyway since it was so easy to reproduce.

thanks,

bryan

Re: Little whine about an error message

[Rick Hillegas <Ri...@Sun.COM>]

Hi Bryan,

Thanks for reporting this. I have logged bug 565 to track it. It could 
be relatively easy to fix this particular diagnostic, but I think it's 
an example of a larger family of unhelpful parser errors--which, you're 
right,  it might be a PITA to cleanup systematically.

Regards,
-Rick

Bryan Pendleton wrote:

> When I mistype 'join' as 'joing', the error message that I
> get actually complains about the word 'left'. It ought to,
> in my opinion, complain about the word 'joing', since that
> is truly the word with the syntax error in it.
>
> ij> select * from t1 left outer joing t2 on t1.c2=t2.c1;
> ERROR 42X01: Syntax error: Encountered "left" at line 1, column 18.
>
> I don't know if this is a PITA to fix or not, but I thought
> I'd send it along anyway since it was so easy to reproduce.
>
> thanks,
>
> bryan
>