From noreply at atlassian.com Fri Mar  5 10:28:49 2010
Content-Type: multipart/mixed; boundary="===============3170125592274001320=="
MIME-Version: 1.0
From: Ray Fan (JIRA) <noreply at atlassian.com>
To: hibernate-issues at lists.jboss.org
Subject: [hibernate-issues] [Hibernate-JIRA] Created: (HHH-4977)
 org.hibernate.test.hql.ASTParserLoadingTest error running testOneToManyFilter
 with Ingres
Date: Fri, 05 Mar 2010 09:28:48 -0600
Message-ID: <724203062.1394.1267802928598.JavaMail.j2ee-opensource-projects@vps07.contegix.com>

--===============3170125592274001320==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

org.hibernate.test.hql.ASTParserLoadingTest error running testOneToManyFilt=
er with Ingres
---------------------------------------------------------------------------=
--------------

                 Key: HHH-4977
                 URL: http://opensource.atlassian.com/projects/hibernate/br=
owse/HHH-4977
             Project: Hibernate Core
          Issue Type: Bug
          Components: testsuite
    Affects Versions: 3.5.0-CR-2
         Environment: Hibernate 3.5.0-CR-2, Ingres 9.3.1 (int.lnx/106), Ing=
res9Dialect
            Reporter: Ray Fan
         Attachments: hql-astparserloadingtest.zip

Error reported executing org.hibernate.test.hql.ASTParserLoadingTest testOn=
eToManyFilter with an Ingres exception
{noformat}
<error message=3D"could not execute query" type=3D"org.hibernate.exception.=
SQLGrammarException">org.hibernate.exception.SQLGrammarException: could not=
 execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.=
java:91)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHel=
per.java:66)
    at org.hibernate.loader.Loader.doList(Loader.java:2257)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2151)
    at org.hibernate.loader.Loader.list(Loader.java:2146)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:448)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.j=
ava:363)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.jav=
a:196)
    at org.hibernate.impl.SessionImpl.listFilter(SessionImpl.java:1614)
    at org.hibernate.impl.CollectionFilterImpl.list(CollectionFilterImpl.ja=
va:74)
    at org.hibernate.test.hql.ASTParserLoadingTest.testOneToManyFilter(ASTP=
arserLoadingTest.java:1653)
Caused by: com.ingres.gcf.util.SqlEx: A <column reference> contained a <qua=
lifier> 'order0_'
which did not correspond to any of the <table reference>s
within whose scope the <column reference> appeared.
    at com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source)
    at com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source)
    at com.ingres.gcf.jdbc.DrvPrep.prepare(Unknown Source)
    at com.ingres.gcf.jdbc.DrvConn.createPrepStmt(Unknown Source)
    at com.ingres.gcf.jdbc.JdbcPrep.<init>(Unknown Source)
    at com.ingres.gcf.jdbc.JdbcConn.createPrep(Unknown Source)
    at com.ingres.gcf.jdbc.JdbcConn.prepareStatement(Unknown Source)
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatc=
her.java:534)
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatc=
her.java:452)
    at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBat=
cher.java:161)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1597)
    at org.hibernate.loader.Loader.doQuery(Loader.java:718)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(L=
oader.java:271)
    at org.hibernate.loader.Loader.doList(Loader.java:2254)
    ... 38 more
</error>
{noformat}

The SQL query that is produced references order0_ in the WHERE clause of th=
e subselect.

{noformat}
    select
        order0_.customerId as customerId35_,
        order0_.orderNumber as orderNum2_35_,
        order0_.orderDate as orderDate35_,
        ( select
            sum(li.quantity*p.cost)
        from
            LineItem li,
            Product p
        where
            li.productId =3D p.productId
            and li.customerId =3D order0_.customerId
            and li.orderNumber =3D order0_.orderNumber ) as formula1_
    from
        CustomerOrder order0_
    where
        order0_.customerId =3D ?
{noformat}

Once the scoping error is removed a more fundamental error is exposed "Sub-=
selects are not supported within select target lists."

-- =

This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: htt=
p://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       =20

--===============3170125592274001320==--