Trying to execute an invalid INNER JOIN query that misses the comma before the declaration of the last field to be extracted, the engine complains Column "<1st column name>" not found; <http://localhost:8082/query.do?jsessionid=a88e857137898e83ce1e2c0fb3f00760#>
I feel this is a minor issue: the SQL is really invalid, but *the error message is misleading*. That could become a problem for fairly complex queries, where one could waste time investigating on the wrong direction. Follows a reproducible test case. CREATE TABLE foo (ID int, FIELDX int); CREATE TABLE bar (ID int, FIELDY int); SELECT f.id, f.fieldx b.fieldy FROM foo f INNER JOIN bar b ON (f.id=b.id) (please note the missing comma before b.fieldy) This example produces the following error message using h2 v. 1.3.173 Column "F.ID" not found; SQL statement: SELECT f.id, f.fieldx b.fieldy FROM foo f INNER JOIN bar b ON (f.id=b.id) [42122-170]<http://localhost:8082/query.do?jsessionid=a88e857137898e83ce1e2c0fb3f00760#> 42S22/42122 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
