EQL not generating correct SQL

[dvobss]

Windows and SUSE Linux
Java 5
JBoss 4.0.3RC1
MySQL 4.1.14
MySQL Connector/J 3.1.10

When I create a CMP EJB the finder queries seem to not be generating the correct SQL. On the wiki I found how to make JBoss log the SQL that was generated by the CMP's, after looking in the logs it makes me more believe that it's not generating the correct SQL.

For example, in one of my finder queries:

EQL
SELECT OBJECT(c) FROM mySchema AS c

Generated SQL (from log)
SELECT FROM t_0c

Any ideas on how to fix this? If you need more information feel free to ask for it because I would really like to figure out how to fix this and I'm at the end of my knowledge.

[fbiaggi]

Could you try with MySQL 4.1.13 ?
I have sse some stranges with 4.1.14...

[dvobss]

"fbiaggi" wrote:
Could you try with MySQL 4.1.13 ?
I have sse some stranges with 4.1.14...

I can try and post the results. However, I don't expect it to change. I say that because I recently upgraded MySQL on Windows from 4.1.10, as well as upgrading MySQL's J driver to try to fix the same problem. On Linux I'm still running MySQL 4.1.10 and I get the same errors.