Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012853Openbravo ERPA. Platformpublic2010-03-31 03:212010-04-19 21:11
Reportermtaal 
Assigned Tomtaal 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionpiFixed in Version2.50MP15 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012853: OBQuery count not working with a query with aliases
DescriptionWhen a query has an alias then the OBquery.count operation is not working correctly. Hibernate throws an error while parsing the query.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0012903 closed mtaal Error in OBQuery when using with hql clause having order by but not where part 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-31 03:21mtaalNew Issue
2010-03-31 03:21mtaalAssigned To => mtaal
2010-03-31 03:27hgbotCheckin
2010-03-31 03:27hgbotNote Added: 0025825
2010-03-31 03:27hgbotStatusnew => resolved
2010-03-31 03:27hgbotResolutionopen => fixed
2010-03-31 03:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9b38a35f182ba334533fa15f720026c636236d5e [^]
2010-04-07 17:32shuehnerRelationship addedrelated to 0012903
2010-04-07 17:33shuehnerNote Added: 0025954
2010-04-07 17:33shuehnerStatusresolved => closed
2010-04-07 17:33shuehnerFixed in Version => 2.50MP15
2010-04-08 00:00anonymoussf_bug_id0 => 2983501
2010-04-19 21:11hudsonbotCheckin
2010-04-19 21:11hudsonbotNote Added: 0026400

Notes
(0025825)
hgbot   
2010-03-31 03:27   
Repository: erp/devel/pi
Changeset: 9b38a35f182ba334533fa15f720026c636236d5e
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Mar 31 03:37:37 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9b38a35f182ba334533fa15f720026c636236d5e [^]

Fixes issue 12853: OBQuery count not working with a query with aliases

---
M src-test/org/openbravo/test/dal/IssuesTest.java
M src/org/openbravo/dal/service/OBQuery.java
---
(0025954)
shuehner   
2010-04-07 17:33   
Tested in pi/oracle, rev: 6ba00074e974. count with alias is now working fine -> Closing. However a new issue 12903 was found while reviewing this one.
(0026400)
hudsonbot   
2010-04-19 21:11   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/9b38a35f182b [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]