Issue Type: Bug Bug
Assignee: Unassigned
Components: annotations
Created: 12/Sep/12 8:05 AM
Description:

Test from org.hibernate.test.annotations.filters.InheritedFilterTest are failing on Oracle, complaining about missing right parenthesis, although they are passing on other DBs.

Links to Red Hat Jenkins jobs:
InheritedFilterTest.testChildWithFilter
InheritedFilterTest.testParentWithFilter

Output and stacktrace for testParentWithFilter:

Hibernate: 
    insert 
    into
        Cat
        (age, name, domestic, id) 
    values
        (?, ?, ?, ?)
testParentWithFilter
Hibernate: 
    select
        this_.id as id198_0_,
        this_.age as age198_0_,
        this_.name as name198_0_,
        this_.domestic as domestic198_0_ 
    from
        Cat this_ 
    where
        ? < (
            select
                a.age 
            from
                Cat as a 
            where
                a.id=this_.ID
        )

Stacktrace

org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2458)
at org.hibernate.loader.Loader.doList(Loader.java:2440)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2316)
at org.hibernate.loader.Loader.list(Loader.java:2311)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:121)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1640)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at org.hibernate.test.annotations.filters.InheritedFilterTest.testParentWithFilter(InheritedFilterTest.java:70)
at org.hibernate.test.annotations.HibernateTestCase.runTest(HibernateTestCase.java:93)
at org.hibernate.test.annotations.HibernateTestCase.runBare(HibernateTestCase.java:81)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

Environment: Hibernate Annotations 3.4.0.GA_CP05,
Oracle 11g R1, R2, R1 RAC, R2 RAC
Project: Hibernate ORM
Priority: Major Major
Reporter: Zbyněk Roubalík
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira