Title:
Bug 86908:-(Watson Migration Closure)In HQL SELECT clauses, the presence of whitespace characters other than space (e
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Julian Halliwell / Julian Halliwell (cfSimplicity)
Created: 05/18/2011
Components: ORM Support
Versions: 9.0.1
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Platforms All
Vote Count: 2
Duplicate ID: CF-3041019
Problem:
In HQL SELECT clauses, the presence of whitespace characters other than space (e.g. tab or newline) cause the following exception:org.hibernate.hql.QueryExecutionRequestException: Not supported for select queriesThis only affects the initial SELECT clause. Tabs in the FROM and later clauses work ok.This occurs in HQL executed either using ormExecuteQuery() or within <cfquery dbtype="hql">This bug was reported as 82229, but then closed, hence I am opening a new ticket since it is still present in 9.0.1
Method:
In case the bugtracker removes whitespace, each clause in the following hql should be on a separate line:<cfquery dbtype="hql">SELECTIDFROMobject</cfquery>
Result:
org.hibernate.hql.QueryExecutionRequestException: Not supported for select queries
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3043823
External Customer Info:
External Company:
External Customer Name: Julian Halliwell
External Customer Email: 2D5C74634456F5BE992016E5
External Test Config: 05/18/2011
Attachments:
Comments: