ALL should be added to the list of reserved keyword.

[Pavel]

The list of the reserved keywords in  http://www.h2database.com/html/advanced.html in incomplete.

H2 version tested: 1.4.196.

Example:

Statement stat = connection.createStatement();
stat.execute("CREATE TABLE ALL ( I INTEGER)");
try (ResultSet rs = stat.executeQuery("SELECT ALL.I FROM ALL")) {
}

org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT ALL.[*]I FROM ALL"; expected "*, NOT, EXISTS, INTERSECTS, SELECT, FROM, WITH"

PS.

ALL is SQL 2003 reserved keyword.

[Noel Grandin]

thanks, fixed in trunk