Keyword 'from' in a column name

[twhitehead.twhiteheadjm.hotmail.com]

I know Seam 2 is probably on its way out with seam 3 around the corner, but I thought I should still mention this.
I used the word 'from' as a column name and it immediately caused errors - not surprising really, though MySql didn't reject it.
So I changed it to fromDate, and everything was fine until I had enough records for paging to kick in and I got errors again:

Caused by: org.hibernate.hql.ast.QuerySyntaxException: expecting CLOSE, found 'from' near line 1, column 19 [select count(duty from aero.stratus.qgt.entity.Duty duty order by) from aero.stratus.qgt.entity.Duty duty]

I was also sorting by the same column and the error only occurred if the table was sorted by that column.

I am guessing this is a bug in EntityQuery.

Changing the column name to dateFrom has stopped the errors.

I am using Seam 2.2.0.GA

[herberson]

All EJBQL is converted to SQL statements and in SQL as in EJBQL (or HQL) from is a keyword and you should avoid use keywords as column name.