> e. There seems to be a typo in Andy's comments posting the SQL. Some > lines in the innermost WHERE clause are duplicated.
There's no typo. JPOX a week ago had dup'd clauses for the EXISTS join. I fixed this a few days ago. http://www.jpox.org/servlet/jira/browse/RDBMS-76 Has no impact on the query result (nor should it since just a dup of an existing clause). > Subquery testing: Michael has finished the test creation, and will > check in the tests to the tck. AI Michael file a new JIRA if JPOX > fails the tests. There's no way JPOX can pass any subquery tests since it isn't implemented, and there's already a JIRA. http://www.jpox.org/servlet/jira/browse/CORE-3207 I assumed Erik would be doing this as part of his "query refactoring", but guess he's been too busy with work so this is not resourced currently. Will be got to when someone has time ... unless we have a willing volunteer ;-) -- Andy (Java Persistent Objects - http://www.jpox.org)
