From noreply at atlassian.com Mon Mar  1 10:21:48 2010
Content-Type: multipart/mixed; boundary="===============8224780129439166173=="
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-4961)
 org.hibernate.test.hql.ASTParserLoadingTest error running
 testPaginationWithPolymorphicQuery with Ingres
Date: Mon, 01 Mar 2010 09:21:48 -0600
Message-ID: <780922592.1156.1267456908254.JavaMail.j2ee-opensource-projects@vps07.contegix.com>

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

org.hibernate.test.hql.ASTParserLoadingTest error running  testPaginationWi=
thPolymorphicQuery with Ingres
---------------------------------------------------------------------------=
------------------------------

                 Key: HHH-4961
                 URL: http://opensource.atlassian.com/projects/hibernate/br=
owse/HHH-4961
             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

org.hibernate.test.hql.ASTParserLoadingTest testPaginationWithPolymorphicQu=
ery reports an error executing the test 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.list(SessionImpl.java:1258)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at org.hibernate.test.hql.ASTParserLoadingTest.testPaginationWithPolymo=
rphicQuery(ASTParserLoadingTest.java:249)
Caused by: com.ingres.gcf.util.SqlEx: A <column reference> contained a <qua=
lifier> 'product0_'
which did not correspond to any of the <table reference>s
within whose scope the &lt;column reference&gt; 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.&lt;init&gt;(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 product0_ in the WHERE clause of =
the subselect.
{noformat}
    select
        product0_.productId as productId37_,
        product0_.description as descript2_37_,
        product0_.cost as cost37_,
        product0_.numberAvailable as numberAv4_37_,
        ( select
            sum(li.quantity)
        from
            LineItem li
        where
            li.productId =3D product0_.productId ) as formula2_
    from
        Product product0_
{noformat}
Ingres does not support this scoping in 9.3.

-- =

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

--===============8224780129439166173==--

From noreply at atlassian.com Mon Apr  5 07:08:32 2010
Content-Type: multipart/mixed; boundary="===============5963603462805392291=="
MIME-Version: 1.0
From: Strong Liu (JIRA) <noreply at atlassian.com>
To: hibernate-issues at lists.jboss.org
Subject: [hibernate-issues] [Hibernate-JIRA] Assigned: (HHH-4961)
 org.hibernate.test.hql.ASTParserLoadingTest error running
 testPaginationWithPolymorphicQuery with Ingres
Date: Mon, 05 Apr 2010 06:08:32 -0500
Message-ID: <1901441033.2242.1270465712053.JavaMail.j2ee-opensource-projects@vps07.contegix.com>
In-Reply-To: 780922592.1156.1267456908254.JavaMail.j2ee-opensource-projects@vps07.contegix.com

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


     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4961?p=
age=3Dcom.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Strong Liu reassigned HHH-4961:
-------------------------------

    Assignee: Strong Liu

> org.hibernate.test.hql.ASTParserLoadingTest error running  testPagination=
WithPolymorphicQuery with Ingres
> -------------------------------------------------------------------------=
--------------------------------
>
>                 Key: HHH-4961
>                 URL: http://opensource.atlassian.com/projects/hibernate/b=
rowse/HHH-4961
>             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), In=
gres9Dialect
>            Reporter: Ray Fan
>            Assignee: Strong Liu
>         Attachments: hql-astparserloadingtest.zip
>
>
> org.hibernate.test.hql.ASTParserLoadingTest testPaginationWithPolymorphic=
Query reports an error executing the test with an Ingres exception
> {noformat}
> <error message=3D"could not execute query" type=3D"org.hibernate.exceptio=
n.SQLGrammarException">org.hibernate.exception.SQLGrammarException: could n=
ot execute query
>     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverte=
r.java:91)
>     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionH=
elper.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=
.java:363)
>     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.j=
ava:196)
>     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
>     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
>     at org.hibernate.test.hql.ASTParserLoadingTest.testPaginationWithPoly=
morphicQuery(ASTParserLoadingTest.java:249)
> Caused by: com.ingres.gcf.util.SqlEx: A <column reference> contained a <q=
ualifier> 'product0_'
> which did not correspond to any of the <table reference>s
> within whose scope the &lt;column reference&gt; 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.&lt;init&gt;(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(AbstractBa=
tcher.java:534)
>     at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBa=
tcher.java:452)
>     at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractB=
atcher.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=
(Loader.java:271)
>     at org.hibernate.loader.Loader.doList(Loader.java:2254)
>     ... 38 more
> </error>
> {noformat}
> The SQL query that is produced references product0_ in the WHERE clause o=
f the subselect.
> {noformat}
>     select
>         product0_.productId as productId37_,
>         product0_.description as descript2_37_,
>         product0_.cost as cost37_,
>         product0_.numberAvailable as numberAv4_37_,
>         ( select
>             sum(li.quantity)
>         from
>             LineItem li
>         where
>             li.productId =3D product0_.productId ) as formula2_
>     from
>         Product product0_
> {noformat}
> Ingres does not support this scoping in 9.3.

-- =

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

--===============5963603462805392291==--

From noreply at atlassian.com Mon Apr  5 07:08:32 2010
Content-Type: multipart/mixed; boundary="===============1779498832640235938=="
MIME-Version: 1.0
From: Strong Liu (JIRA) <noreply at atlassian.com>
To: hibernate-issues at lists.jboss.org
Subject: [hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4961)
 org.hibernate.test.hql.ASTParserLoadingTest error running
 testPaginationWithPolymorphicQuery with Ingres
Date: Mon, 05 Apr 2010 06:08:31 -0500
Message-ID: <974025945.2239.1270465711900.JavaMail.j2ee-opensource-projects@vps07.contegix.com>
In-Reply-To: 780922592.1156.1267456908254.JavaMail.j2ee-opensource-projects@vps07.contegix.com

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


    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4961?pa=
ge=3Dcom.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focus=
edCommentId=3D36130#action_36130 ] =


Strong Liu commented on HHH-4961:
---------------------------------

Ray,

what does this mean?
{quote}Ingres does not support this scoping in 9.3.
{quote}

do you want to skip this test on Ingres?

> org.hibernate.test.hql.ASTParserLoadingTest error running  testPagination=
WithPolymorphicQuery with Ingres
> -------------------------------------------------------------------------=
--------------------------------
>
>                 Key: HHH-4961
>                 URL: http://opensource.atlassian.com/projects/hibernate/b=
rowse/HHH-4961
>             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), In=
gres9Dialect
>            Reporter: Ray Fan
>         Attachments: hql-astparserloadingtest.zip
>
>
> org.hibernate.test.hql.ASTParserLoadingTest testPaginationWithPolymorphic=
Query reports an error executing the test with an Ingres exception
> {noformat}
> <error message=3D"could not execute query" type=3D"org.hibernate.exceptio=
n.SQLGrammarException">org.hibernate.exception.SQLGrammarException: could n=
ot execute query
>     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverte=
r.java:91)
>     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionH=
elper.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=
.java:363)
>     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.j=
ava:196)
>     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
>     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
>     at org.hibernate.test.hql.ASTParserLoadingTest.testPaginationWithPoly=
morphicQuery(ASTParserLoadingTest.java:249)
> Caused by: com.ingres.gcf.util.SqlEx: A <column reference> contained a <q=
ualifier> 'product0_'
> which did not correspond to any of the <table reference>s
> within whose scope the &lt;column reference&gt; 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.&lt;init&gt;(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(AbstractBa=
tcher.java:534)
>     at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBa=
tcher.java:452)
>     at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractB=
atcher.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=
(Loader.java:271)
>     at org.hibernate.loader.Loader.doList(Loader.java:2254)
>     ... 38 more
> </error>
> {noformat}
> The SQL query that is produced references product0_ in the WHERE clause o=
f the subselect.
> {noformat}
>     select
>         product0_.productId as productId37_,
>         product0_.description as descript2_37_,
>         product0_.cost as cost37_,
>         product0_.numberAvailable as numberAv4_37_,
>         ( select
>             sum(li.quantity)
>         from
>             LineItem li
>         where
>             li.productId =3D product0_.productId ) as formula2_
>     from
>         Product product0_
> {noformat}
> Ingres does not support this scoping in 9.3.

-- =

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

--===============1779498832640235938==--

From noreply at atlassian.com Mon Apr  5 09:26:32 2010
Content-Type: multipart/mixed; boundary="===============6545200097194620385=="
MIME-Version: 1.0
From: Strong Liu (JIRA) <noreply at atlassian.com>
To: hibernate-issues at lists.jboss.org
Subject: [hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-4961)
 org.hibernate.test.hql.ASTParserLoadingTest error running
 testPaginationWithPolymorphicQuery with Ingres
Date: Mon, 05 Apr 2010 08:26:31 -0500
Message-ID: <312224556.2255.1270473991905.JavaMail.j2ee-opensource-projects@vps07.contegix.com>
In-Reply-To: 780922592.1156.1267456908254.JavaMail.j2ee-opensource-projects@vps07.contegix.com

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


     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4961?p=
age=3Dcom.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Strong Liu resolved HHH-4961.
-----------------------------

       Resolution: Fixed
    Fix Version/s:  3.5.x

skip this test on ingres

> org.hibernate.test.hql.ASTParserLoadingTest error running  testPagination=
WithPolymorphicQuery with Ingres
> -------------------------------------------------------------------------=
--------------------------------
>
>                 Key: HHH-4961
>                 URL: http://opensource.atlassian.com/projects/hibernate/b=
rowse/HHH-4961
>             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), In=
gres9Dialect
>            Reporter: Ray Fan
>            Assignee: Strong Liu
>             Fix For:  3.5.x
>
>         Attachments: hql-astparserloadingtest.zip
>
>
> org.hibernate.test.hql.ASTParserLoadingTest testPaginationWithPolymorphic=
Query reports an error executing the test with an Ingres exception
> {noformat}
> <error message=3D"could not execute query" type=3D"org.hibernate.exceptio=
n.SQLGrammarException">org.hibernate.exception.SQLGrammarException: could n=
ot execute query
>     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverte=
r.java:91)
>     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionH=
elper.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=
.java:363)
>     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.j=
ava:196)
>     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
>     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
>     at org.hibernate.test.hql.ASTParserLoadingTest.testPaginationWithPoly=
morphicQuery(ASTParserLoadingTest.java:249)
> Caused by: com.ingres.gcf.util.SqlEx: A <column reference> contained a <q=
ualifier> 'product0_'
> which did not correspond to any of the <table reference>s
> within whose scope the &lt;column reference&gt; 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.&lt;init&gt;(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(AbstractBa=
tcher.java:534)
>     at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBa=
tcher.java:452)
>     at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractB=
atcher.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=
(Loader.java:271)
>     at org.hibernate.loader.Loader.doList(Loader.java:2254)
>     ... 38 more
> </error>
> {noformat}
> The SQL query that is produced references product0_ in the WHERE clause o=
f the subselect.
> {noformat}
>     select
>         product0_.productId as productId37_,
>         product0_.description as descript2_37_,
>         product0_.cost as cost37_,
>         product0_.numberAvailable as numberAv4_37_,
>         ( select
>             sum(li.quantity)
>         from
>             LineItem li
>         where
>             li.productId =3D product0_.productId ) as formula2_
>     from
>         Product product0_
> {noformat}
> Ingres does not support this scoping in 9.3.

-- =

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

--===============6545200097194620385==--

From noreply at atlassian.com Tue Apr  6 04:05:03 2010
Content-Type: multipart/mixed; boundary="===============4090024521098688429=="
MIME-Version: 1.0
From: Ray Fan (JIRA) <noreply at atlassian.com>
To: hibernate-issues at lists.jboss.org
Subject: [hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4961)
 org.hibernate.test.hql.ASTParserLoadingTest error running
 testPaginationWithPolymorphicQuery with Ingres
Date: Tue, 06 Apr 2010 03:05:03 -0500
Message-ID: <2007314195.5.1270541103002.JavaMail.j2ee-opensource-projects@vps07.contegix.com>
In-Reply-To: 780922592.1156.1267456908254.JavaMail.j2ee-opensource-projects@vps07.contegix.com

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


    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4961?pa=
ge=3Dcom.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focus=
edCommentId=3D36161#action_36161 ] =


Ray Fan commented on HHH-4961:
------------------------------

Strong Liu,

Ingres does not support scalar sub queries in the select list clause of a q=
uery in versions Ingres 9.3 and prior.

It will be supported in Ingres 10.0.

Thanks

> org.hibernate.test.hql.ASTParserLoadingTest error running  testPagination=
WithPolymorphicQuery with Ingres
> -------------------------------------------------------------------------=
--------------------------------
>
>                 Key: HHH-4961
>                 URL: http://opensource.atlassian.com/projects/hibernate/b=
rowse/HHH-4961
>             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), In=
gres9Dialect
>            Reporter: Ray Fan
>            Assignee: Strong Liu
>             Fix For:  3.5.x
>
>         Attachments: hql-astparserloadingtest.zip
>
>
> org.hibernate.test.hql.ASTParserLoadingTest testPaginationWithPolymorphic=
Query reports an error executing the test with an Ingres exception
> {noformat}
> <error message=3D"could not execute query" type=3D"org.hibernate.exceptio=
n.SQLGrammarException">org.hibernate.exception.SQLGrammarException: could n=
ot execute query
>     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverte=
r.java:91)
>     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionH=
elper.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=
.java:363)
>     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.j=
ava:196)
>     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
>     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
>     at org.hibernate.test.hql.ASTParserLoadingTest.testPaginationWithPoly=
morphicQuery(ASTParserLoadingTest.java:249)
> Caused by: com.ingres.gcf.util.SqlEx: A <column reference> contained a <q=
ualifier> 'product0_'
> which did not correspond to any of the <table reference>s
> within whose scope the &lt;column reference&gt; 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.&lt;init&gt;(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(AbstractBa=
tcher.java:534)
>     at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBa=
tcher.java:452)
>     at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractB=
atcher.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=
(Loader.java:271)
>     at org.hibernate.loader.Loader.doList(Loader.java:2254)
>     ... 38 more
> </error>
> {noformat}
> The SQL query that is produced references product0_ in the WHERE clause o=
f the subselect.
> {noformat}
>     select
>         product0_.productId as productId37_,
>         product0_.description as descript2_37_,
>         product0_.cost as cost37_,
>         product0_.numberAvailable as numberAv4_37_,
>         ( select
>             sum(li.quantity)
>         from
>             LineItem li
>         where
>             li.productId =3D product0_.productId ) as formula2_
>     from
>         Product product0_
> {noformat}
> Ingres does not support this scoping in 9.3.

-- =

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

--===============4090024521098688429==--