EJBQLToSQL92 ignores LIMIT clause

SourceForge Submitter: cracru .
I decided to post this as a bug as I noticed someone
else posted to the jboss-user list in August with the
similar problem.

When using the EJBQLToSQL92 compiler (in 3.2.5/6) the
LIMIT clause in my finders seems to be ignored. I have
debug level message turned on for CMP in the server log
and see nothing about the limit, nor is the result set
limited.

If I use the default QL compiler, limits seem to work,
and I get a debug message stating the values of the
offset and limit per query.

Thanks, Craig.