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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0022932
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2013-01-30 09:552013-02-26 12:57
ReportermiruritaView Statuspublic 
Assigned ToAugustoMauch 
PriorityhighResolutionfixedFixed in Version3.0MP21
StatusclosedFix in branchpiFixed in SCM revision66d0835d6c60
ProjectionnoneETAnoneTarget Version3.0MP21
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionpiSCM revision 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0022932: Computed columns (foreign key reference) are not ignored in the linked items

Description
computed columns with a foreign key reference (tabledir, ...) are not ignored in the linked items computation.

as the computed column does not exists in the database the select fails on

getLinkedItemCategories method on UsedByLink class

data = UsedByLinkData.select(this, vars.getClient(), vars.getLanguage(), vars.getRole(), keyColumnId, keyColumn, tableId, linkedColumnsQuery.toString());

Steps To Reproduce1) Install the following modules
https://code.openbravo.com/erp/mods/org.openbravo.contract/ [^]
https://code.openbravo.com/erp/pmods/org.openbravo.contract.services/ [^]
https://code.openbravo.com/private/eulen/org.openbravo.contract.services.template [^]
https://code.openbravo.com/private/eulen/org.openbravo.contract.hierarchical/ [^]
https://code.openbravo.com/private/eulen/org.openbravo.contract.hierarchical.template/ [^]
https://code.openbravo.com/private/eulen/org.openbravo.eulen/ [^]
https://code.openbravo.com/private/eulen/org.openbravo.project.budget/ [^]

2) Apply dataset for previous modules

3) Go to contract window
 3.1) Create a new contract header
 3.2) Create a new contract line

4) Click on 'Linked Items' and see the error
TagsNo tags attached.
Attached Filesdiff file icon issue22932.diff [^] (763 bytes) 2013-02-04 15:06 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0056132)
AugustoMauch (administrator)
2013-02-04 15:07

 A fix for this issue has been attached. It will be pushed to pi once pi is unfrozen.
(0056374)
hgbot (developer)
2013-02-12 12:49

 Repository: erp/devel/pi
Changeset: 66d0835d6c60680700bf23e85b5ac54c0dd8a301
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue Feb 12 12:49:06 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/66d0835d6c60680700bf23e85b5ac54c0dd8a301 [^]

Fixes issue 22932: Computed columns are ignored in the linked items

Computed columns (columns with sqllogic not null) are ignored in the linked items, to prevent trying to search for its physical column (they don't have one).

---
M src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql
---
(0056580)
hudsonbot (viewer)
2013-02-20 04:50

 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/d828167a9e83 [^]

Maturity status: Test
(0056773)
shankarb (viewer)
2013-02-26 12:56

 Reopened to modify Closed note.
(0056774)
shankarb (viewer)
2013-02-26 12:57

 Code reviewed and tested in pi changeset 059d60b862a4

- Issue History
Date Modified Username Field Change
2013-01-30 09:55 mirurita New Issue
2013-01-30 09:55 mirurita Assigned To => AugustoMauch
2013-01-30 09:55 mirurita Modules => Core
2013-01-30 09:55 mirurita OBNetwork customer => Yes
2013-01-30 09:55 mirurita Triggers an Emergency Pack => No
2013-02-04 15:06 AugustoMauch File Added: issue22932.diff
2013-02-04 15:07 AugustoMauch Note Added: 0056132
2013-02-04 15:07 AugustoMauch Status new => scheduled
2013-02-04 15:07 AugustoMauch fix_in_branch => pi
2013-02-12 12:49 hgbot Checkin
2013-02-12 12:49 hgbot Note Added: 0056374
2013-02-12 12:49 hgbot Status scheduled => resolved
2013-02-12 12:49 hgbot Resolution open => fixed
2013-02-12 12:49 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/66d0835d6c60680700bf23e85b5ac54c0dd8a301 [^]
2013-02-12 12:50 AugustoMauch Review Assigned To => shankarb
2013-02-12 12:51 AugustoMauch Issue Monitored: shankarb
2013-02-20 04:50 hudsonbot Checkin
2013-02-20 04:50 hudsonbot Note Added: 0056580
2013-02-26 12:56 shankarb Note Added: 0056772
2013-02-26 12:56 shankarb Status resolved => closed
2013-02-26 12:56 shankarb Fixed in Version => 3.0MP21
2013-02-26 12:56 shankarb Note Added: 0056773
2013-02-26 12:56 shankarb Status closed => new
2013-02-26 12:56 shankarb Resolution fixed => open
2013-02-26 12:56 shankarb Fixed in Version 3.0MP21 =>
2013-02-26 12:56 shankarb Note Deleted: 0056772
2013-02-26 12:57 shankarb Status new => scheduled
2013-02-26 12:57 shankarb Status scheduled => resolved
2013-02-26 12:57 shankarb Resolution open => fixed
2013-02-26 12:57 shankarb Note Added: 0056774
2013-02-26 12:57 shankarb Status resolved => closed
2013-02-26 12:57 shankarb Fixed in Version => 3.0MP21

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker