[Hibernate-issues] [Hibernate-JIRA] Updated: (HB-297) Named Parameters not recognized in 'order by' section of Query

[<leg...@at...>]

The following issue has been updated:

    Updater: Roberto S. Tyley (mailto:Rob...@re...)
       Date: Fri, 29 Aug 2003 7:13 AM
    Comment:
I've attached a patch to correct OrderByParser, and updated FooBarTest.testNamedParams() to make a test for named parameters in the Order By clause.

I hope the patch is in the correct format - I'm currently in a windows-only environment, so I used the excellent win32 port of the GNU diff tool provided by http://unxutils.sourceforge.net/ . If there's a problem with the patch, please let me know and I'll re-diff it.
    Changes:
             Attachment changed to HB-297-Patch.txt
    ---------------------------------------------------------------------
For a full history of the issue, see:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-297&page=history

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-297


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-297
    Summary: Named Parameters not recognized in 'order by' section of Query
       Type: Bug

     Status: Assigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.1
             2.0.2
             2.1 beta 1
             2.1 beta 2

   Assignee: Gavin King
   Reporter: Roberto S. Tyley

    Created: Thu, 28 Aug 2003 8:39 AM
    Updated: Fri, 29 Aug 2003 7:13 AM
Environment: java.version=1.4.2
os.name=Windows 2000
Mckoi DB 1.0.2

Description:

The following query using named parameters fails:

Query q=session.createQuery("from Location loc where (loc.lonLat.UnitX between :minX and :maxX) order by ABS( loc.lonLat.UnitX - :centX )");
q.setDouble("minX", x - r);
q.setDouble("maxX", x + r);
q.setDouble("centX", x);
Iterator locs = q.iterate(); // Fails with QueryException

The final bit with 'centX' causes the problem, as the following query, with the 'centX' removed, succeeds:

Query q=session.createQuery("from Location loc where (loc.lonLat.UnitX between :minX and :maxX) order by ABS( loc.lonLat.UnitX )");
q.setDouble("minX", x - r);
q.setDouble("maxX", x + r);
Iterator locs = q.iterate(); // Succeeds

Also, using JDBC-style un-named parameters works:

Query q=session.createQuery("from Location loc where (loc.lonLat.UnitX between ? and ?) order by ABS( loc.lonLat.UnitX - ? )");
q.setDouble(0, x - r);
q.setDouble(1, x + r);
q.setDouble(2, x);
Iterator locs = q.iterate(); // Succeeds

Both of these two succeeding queries bring back all the results I would expect, with the correct ordering - so none of the function-calls or presence of a parameter in the order-by clause should be illegal.

The full stack trace is:

net.sf.hibernate.QueryException: Named parameter does not appear in Query: centX [from com.thisbedisonfire.madgag.persistence.Location loc where (loc.lonLat.UnitX between :minX and :maxX) order by ABS( loc.lonLat.UnitX - :centX )]
	at net.sf.hibernate.hql.QueryTranslator.getNamedParameterLocs(QueryTranslator.java:437)
	at net.sf.hibernate.hql.QueryTranslator.bindNamedParameters(QueryTranslator.java:817)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:575)
	at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:832)
	at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1436)
	at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:29)
	at com.thisbedisonfire.madgag.Main.main(Main.java:105)

So, something's going wrong with binding of named parameters...

Hope you can help!
Roberto S. Tyley



---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira