your options are:
1. use jboss-3.2.7 where it is fixed.
2. switch to org.jboss.ejb.plugins.cmp.jdbc.EJBQLToSQL92Compiler using ql-compiler in jbossjdbc-cmp.xml. (of course you will lose the benefit of LEFT OUTER JOIN, as the finder wont go nested anymore, and also get all fields in the find)
3. Update jboss.jar's JDBCAbstractCMPFieldBridge.class with the one from jboss-3.2.7 or recompiling in 3.2.6 source.
I dont really recommend 2 as it is self-defeating.