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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035509
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2017-03-14 13:122017-03-17 10:40
ReportercaristuView Statuspublic 
Assigned Tocaristu 
PriorityhighResolutionfixedFixed in Version3.0PR17Q2
StatusclosedFix in branchFixed in SCM revision84ddadc11e41
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toalostale
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035509: OBQuery is not working for queries without an alias and a select clause

DescriptionOBQuery is not working for queries without an alias and a select clause.
Steps To Reproduce1) Apply the attached patch, it contains two new tests: testOBQueryWithoutAlias and testOBQueryWithAlias. Both of them launch exactly the same query, but the second one includes an alias for the main entity of the query.

2) Run the tests. Notice that testOBQueryWithoutAlias fails. It is failing because an space is missing before the from clause:

Exception when creating query select descriptionfrom Currency where (iSOCode = :isoCode) and organization.id in ('0', 'E443A31992CB4635AFCAEABE7183CE85', 'B843C30461EA4501935CB1D125C9C25A', 'BAE22373FEBE4CCCA24517E23F0C8A48', 'DC206C91AA6A4897B44DA897936E0EC3', '19404EAD144C49A0AF37D54377CF452D', '2E60544D37534C0B89E765FE29BC0B43', '7BABA5FF80494CAFA54DEBD22EC46F01') and client.id in ('23C59575B9CF467C9620760EB255B389', '0') and active='Y'
 
TagsNo tags attached.
Attached Filesdiff file icon test.diff [^] (2,145 bytes) 2017-03-14 13:12 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0095001)
hgbot (developer)
2017-03-14 16:56

Repository: erp/devel/pi
Changeset: 84ddadc11e413380f06b43baf784bb7e0b361180
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Tue Mar 14 16:55:41 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/84ddadc11e413380f06b43baf784bb7e0b361180 [^]

fixes bug 35509: OBQuery without an alias and a select clause is not working

---
M src-test/src/org/openbravo/test/dal/DalTest.java
M src/org/openbravo/dal/service/OBQuery.java
---
(0095299)
hudsonbot (developer)
2017-03-15 20:22

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/54e102bef53e [^]
Maturity status: Test
(0095360)
alostale (manager)
2017-03-17 10:40

reviewed

- Issue History
Date Modified Username Field Change
2017-03-14 13:12 caristu New Issue
2017-03-14 13:12 caristu Assigned To => platform
2017-03-14 13:12 caristu Modules => Core
2017-03-14 13:12 caristu Triggers an Emergency Pack => No
2017-03-14 13:12 caristu Assigned To platform => caristu
2017-03-14 13:12 caristu Status new => scheduled
2017-03-14 13:12 caristu File Added: test.diff
2017-03-14 13:14 caristu Summary OBQuery is not working for queries without an alias => OBQuery is not working for queries without an alias and a select clause
2017-03-14 13:14 caristu Description Updated View Revisions
2017-03-14 13:16 caristu Steps to Reproduce Updated View Revisions
2017-03-14 16:56 hgbot Checkin
2017-03-14 16:56 hgbot Note Added: 0095001
2017-03-14 16:56 hgbot Status scheduled => resolved
2017-03-14 16:56 hgbot Resolution open => fixed
2017-03-14 16:56 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/84ddadc11e413380f06b43baf784bb7e0b361180 [^]
2017-03-14 16:57 caristu Review Assigned To => alostale
2017-03-15 20:22 hudsonbot Checkin
2017-03-15 20:22 hudsonbot Note Added: 0095299
2017-03-17 10:40 alostale Note Added: 0095360
2017-03-17 10:40 alostale Status resolved => closed
2017-03-17 10:40 alostale Fixed in Version => 3.0PR17Q2


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker