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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015050
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2010-10-27 17:502010-11-05 12:44
ReportermtaalView Statuspublic 
Assigned Tomtaal 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision438617827527
ProjectionnoneETAnoneTarget Versionpi
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015050: OBQuery: whereclause with alias with a comma direct after the alias fails

DescriptionThis usage of OBQuery:
OBQuery<SyncPointReg> datosTablaOBEliminados = OBDal.getInstance().createQuery(SyncPointReg.class, whereClause.toString());
        
//My whereClause is:

whereClause.append(" AS reg, AD_Audit_Trail_Raw AS au where reg.id = au.recordID ");
whereClause.append(" and au.table.id = '291'");
whereClause.append(" and reg.active=true and action='D' and reg.pointSinc.id='546529A797B545B8BB14C8317795213A'");
whereClause.append(" and au.oldChar=au.client.id ORDER BY au.creationDate");

Results in this error:
select reg, from wss_syncpointreg AS reg, AD_Audit_Trail_Raw AS au where ( reg.identificadorOpenbravo = au.recordID and au.table.id = '291' and reg.active=true and action='D' and reg.pointSinc.id='546529A797B545B8BB14C8317795213A' and au.oldChar=au.client.id ) and reg,.organization.id in ('0', '105DE888FFEB49E18C828E8C45945203') and reg,.client.id in ('AAE2DE59A6654E1097733152573FE150', '0') and reg,.active='Y' ORDER BY au.creationDate

Note, the comma which is added just after the alias in the select clause.

See this forum post:
http://forge.openbravo.com/plugins/espforum/view.php?group_id=100&forumid=549512&topicid=7019996 [^]
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 00150562.50MP24 closedmtaal OBQuery: whereclause with alias with a comma direct after the alias fails 

-  Notes
(0032277)
hgbot (developer)
2010-10-27 21:23

 Repository: erp/devel/pi
Changeset: 4386178275271efff07e1917ce1a2cb37167e242
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Oct 27 21:23:12 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4386178275271efff07e1917ce1a2cb37167e242 [^]

Fixes issue 15050: OBQuery: whereclause with alias with a comma direct after the alias fails
Fixes issue 15056: OBQuery: whereclause with alias with a comma direct after the alias fails

---
M src-test/org/openbravo/test/dal/IssuesTest.java
M src/org/openbravo/dal/service/OBQuery.java
---
(0032291)
mtaal (viewer)
2010-10-28 12:04

 Duplicate of 15056
(0032433)
hudsonbot (viewer)
2010-11-05 12:44

 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/438617827527 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/f2cf138fa03c [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18797.obx [^]

- Issue History
Date Modified Username Field Change
2010-10-27 17:50 mtaal New Issue
2010-10-27 17:50 mtaal Assigned To => mtaal
2010-10-27 17:50 mtaal OBNetwork customer => No
2010-10-27 19:34 networkb Issue cloned 0015056
2010-10-27 19:36 networkb Relationship added has duplicate 0015056
2010-10-27 21:23 hgbot Checkin
2010-10-27 21:23 hgbot Note Added: 0032277
2010-10-27 21:23 hgbot Status new => resolved
2010-10-27 21:23 hgbot Resolution open => fixed
2010-10-27 21:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4386178275271efff07e1917ce1a2cb37167e242 [^]
2010-10-28 12:04 mtaal Note Added: 0032291
2010-10-28 12:04 mtaal Status resolved => closed
2010-10-30 11:24 anonymous sf_bug_id 0 => 3098764
2010-11-05 12:44 hudsonbot Checkin
2010-11-05 12:44 hudsonbot Note Added: 0032433

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker