Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0025008
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2013-10-24 11:172013-11-27 16:42
ReporterjecharriView Statuspublic 
Assigned Toshankarb 
PriorityurgentResolutionfixedFixed in Version3.0MP30
StatusclosedFix in branchFixed in SCM revisionfc433509a3e6
ProjectionnoneETAnoneTarget Version3.0MP30
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned ToAugustoMauch
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0025008: Sql error using summary functions

DescriptionSql error using summary functions
Steps To Reproduce-Go to window product
-Add "count summary function" to column organization
-Press in the product name with mouse right button and use as filter

After that press in refresh button. You will get error
Exception when creating query select count(join_0.name) from Product as e where ( ( upper(e.name) like :alias_0 escape '|' ) ) and e.organization.id in ('E443A31992CB4635AFCAEABE7183CE85', '0', 'DC206C91AA6A4897B44DA897936E0EC3', '7BABA5FF80494CAFA54DEBD22EC46F01', 'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43') and e.client.id in ('23C59575B9CF467C9620760EB255B389', '0')
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0062274)
hgbot (developer)
2013-11-20 06:58

Repository: erp/devel/pi
Changeset: fc433509a3e64c04de815f3bb0cf83dc437783fd
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Wed Nov 20 11:17:17 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/fc433509a3e64c04de815f3bb0cf83dc437783fd [^]

Fixes Issue 0025008: Sql error using summary function

Handled cases where if the select part contains a summary function, the query builder fails
as the join values are not properly replaced.
Added a new private method replaceJoinsWithValue to replace appropriate value.

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0062333)
hudsonbot (developer)
2013-11-21 15:46

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/44d0ece7c5ab [^]

Maturity status: Test
(0062418)
AugustoMauch (manager)
2013-11-27 16:42

Code reviewed and verified in pi@37745290efe5

- Issue History
Date Modified Username Field Change
2013-10-24 11:17 jecharri New Issue
2013-10-24 11:17 jecharri Assigned To => AugustoMauch
2013-10-24 11:17 jecharri Web browser => Google Chrome
2013-10-24 11:17 jecharri Modules => Core
2013-10-24 11:17 jecharri Resolution time => 1385420400
2013-10-24 11:17 jecharri Triggers an Emergency Pack => No
2013-11-18 08:33 shankarb Assigned To AugustoMauch => shankarb
2013-11-20 05:40 shankarb Review Assigned To => AugustoMauch
2013-11-20 05:40 shankarb Web browser Google Chrome => Google Chrome
2013-11-20 05:40 shankarb Issue Monitored: AugustoMauch
2013-11-20 06:58 hgbot Checkin
2013-11-20 06:58 hgbot Note Added: 0062274
2013-11-20 06:58 hgbot Status new => resolved
2013-11-20 06:58 hgbot Resolution open => fixed
2013-11-20 06:58 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fc433509a3e64c04de815f3bb0cf83dc437783fd [^]
2013-11-21 15:46 hudsonbot Checkin
2013-11-21 15:46 hudsonbot Note Added: 0062333
2013-11-27 16:42 AugustoMauch Note Added: 0062418
2013-11-27 16:42 AugustoMauch Status resolved => closed
2013-11-27 16:42 AugustoMauch Fixed in Version => 3.0MP30


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker