Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0017176Openbravo ERPA. Platformpublic2011-05-16 13:342011-09-02 20:13
shuehner 
marvintm 
normalminorhave not tried
closedfixed 
5
 
3.0MP33.0MP3 
User Interface Application
No
0017176: MenuData.linkForms uses hql left join which now changed behavior but could just use normal join instead
The hql-query in that function is affected by the hibernate library update which changes the sql-executed for it

However checking the query the use of left-join is not needed as the join fields are all marked as not-null so behave like a normal join.

Attached patch changes the query do do a normal join to simplify it and make that more obvious.
No tags attached.
diff 17176.diff (1,175) 2011-05-16 13:35
https://issues.openbravo.com/file_download.php?file_id=4003&type=bug
Issue History
2011-05-16 13:34shuehnerNew Issue
2011-05-16 13:34shuehnerAssigned To => shuehner
2011-05-16 13:34shuehnerModules => User Interface Application
2011-05-16 13:35shuehnerFile Added: 17176.diff
2011-05-23 08:08alostaleStatusnew => scheduled
2011-06-02 10:53dmitry_mezentsevTarget Version3.0MP0 => 3.0MP1
2011-06-22 19:41dmitry_mezentsevTarget Version3.0MP1 => 3.0MP3
2011-08-30 17:23shuehnerAssigned Toshuehner => marvintm
2011-09-01 16:48hgbotCheckin
2011-09-01 16:48hgbotNote Added: 0040684
2011-09-01 16:48hgbotStatusscheduled => resolved
2011-09-01 16:48hgbotResolutionopen => fixed
2011-09-01 16:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/aec4c4f24da5f041f2205d3b27ddf530d9d73009 [^]
2011-09-02 10:14mtaalNote Added: 0040703
2011-09-02 10:14mtaalStatusresolved => closed
2011-09-02 10:14mtaalFixed in Version => 3.0MP3
2011-09-02 20:13hudsonbotCheckin
2011-09-02 20:13hudsonbotNote Added: 0040733

Notes
(0040684)
hgbot   
2011-09-01 16:48   
Repository: erp/devel/pi
Changeset: aec4c4f24da5f041f2205d3b27ddf530d9d73009
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Sep 01 16:47:28 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/aec4c4f24da5f041f2205d3b27ddf530d9d73009 [^]

Fixed issue 17176. Removed unnecesary left keyword.

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/MenuManager.java
---
(0040703)
mtaal   
2011-09-02 10:14   
Works
(0040733)
hudsonbot   
2011-09-02 20:13   
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/f1065162150e [^]

Maturity status: Test