Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0035509 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | minor | have not tried | 2017-03-14 13:12 | 2017-03-17 10:40 | |||
Reporter | caristu | View Status | public | |||||
Assigned To | caristu | |||||||
Priority | high | Resolution | fixed | Fixed in Version | 3.0PR17Q2 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 84ddadc11e41 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | alostale | |||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0035509: OBQuery is not working for queries without an alias and a select clause | |||||||
Description | OBQuery is not working for queries without an alias and a select clause. | |||||||
Steps To Reproduce | 1) 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' | |||||||
Tags | No tags attached. | |||||||
Attached Files | ![]() | |||||||
![]() |
|
![]() |
|
(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 (viewer) 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 (viewer) 2017-03-17 10:40 |
reviewed |
![]() |
|||
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 | OBNetwork customer | => No |
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 |