db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Little whine about an error message
Date Tue, 13 Sep 2005 18:27:08 GMT
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.


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

View raw message