Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010593Openbravo ERPA. Platformpublic2009-09-14 20:282009-10-06 11:21
Reportershuehner 
Assigned Toshuehner 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50MP6 
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
Summary0010593: ReferencedLink_data.xsql misses to_number call in filter of an optional parameter
DescriptionThis file misses a to_number call in the 'SEQNO < ?' optional filter. The isChild method having this parameter seems not to be used -> no function defect.

However this interferes with a planned SqlC performance improvement.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0010594 closed shuehner ReferencedLink_data.xsql misses to_number call in filter of an optional parameter 
blocks defect 0004038 closed shuehner Slow compilation in sqlC part due to high amount of data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-14 20:28shuehnerNew Issue
2009-09-14 20:28shuehnerAssigned To => shuehner
2009-09-14 20:28shuehnerOBNetwork customer => No
2009-09-14 20:28shuehnerStatusnew => scheduled
2009-09-14 20:28shuehnerfix_in_branch => pi
2009-09-14 20:31hgbotCheckin
2009-09-14 20:31hgbotNote Added: 0019956
2009-09-14 20:31hgbotStatusscheduled => resolved
2009-09-14 20:31hgbotResolutionopen => fixed
2009-09-14 20:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5f2b71efe628fe342e6e3d7caeda27da4fe8d9a9 [^]
2009-09-14 20:32shuehnerRelationship addedblocks 0004038
2009-09-14 20:47hudsonbotCheckin
2009-09-14 20:47hudsonbotNote Added: 0019965
2009-09-14 20:48hudsonbotCheckin
2009-09-14 20:48hudsonbotNote Added: 0019968
2009-09-14 21:07hudsonbotCheckin
2009-09-14 21:07hudsonbotNote Added: 0019972
2009-09-14 21:17hudsonbotCheckin
2009-09-14 21:17hudsonbotNote Added: 0019986
2009-09-14 23:15hudsonbotCheckin
2009-09-14 23:15hudsonbotNote Added: 0020002
2009-09-15 00:26hudsonbotCheckin
2009-09-15 00:26hudsonbotNote Added: 0020008
2009-09-15 00:38hudsonbotCheckin
2009-09-15 00:38hudsonbotNote Added: 0020009
2009-09-15 01:09hudsonbotCheckin
2009-09-15 01:09hudsonbotNote Added: 0020010
2009-09-15 09:45hudsonbotCheckin
2009-09-15 09:45hudsonbotNote Added: 0020023
2009-09-15 09:50hudsonbotCheckin
2009-09-15 09:50hudsonbotNote Added: 0020027
2009-09-15 10:34hudsonbotCheckin
2009-09-15 10:34hudsonbotNote Added: 0020031
2009-09-15 10:57hudsonbotCheckin
2009-09-15 10:57hudsonbotNote Added: 0020040
2009-09-15 11:09hudsonbotCheckin
2009-09-15 11:09hudsonbotNote Added: 0020046
2009-09-15 12:12hudsonbotCheckin
2009-09-15 12:12hudsonbotNote Added: 0020053
2009-09-15 12:35hudsonbotCheckin
2009-09-15 12:35hudsonbotNote Added: 0020067
2009-09-18 13:20psarobeStatusresolved => closed
2009-09-18 13:21psarobeFixed in Version => 2.50MP6
2009-09-19 00:00anonymoussf_bug_id0 => 2861739
2009-09-29 14:11hgbotCheckin
2009-09-29 14:11hgbotNote Added: 0020462
2009-09-29 14:11hgbotStatusclosed => resolved
2009-09-29 14:11hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/5f2b71efe628fe342e6e3d7caeda27da4fe8d9a9 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/5f2b71efe628fe342e6e3d7caeda27da4fe8d9a9 [^]
2009-10-06 11:21psarobeStatusresolved => closed
2009-10-06 11:21psarobeNote Added: 0020751

Notes
(0019956)
hgbot   
2009-09-14 20:31   
Repository: erp/devel/pi
Changeset: 5f2b71efe628fe342e6e3d7caeda27da4fe8d9a9
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Sep 14 20:31:20 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5f2b71efe628fe342e6e3d7caeda27da4fe8d9a9 [^]

Fixed 10593: Add missing to_number in optional parameter

---
M src/org/openbravo/erpCommon/utility/ReferencedLink_data.xsql
---
(0019965)
hudsonbot   
2009-09-14 20:47   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/864/ [^]
------
(0019968)
hudsonbot   
2009-09-14 20:48   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/757/ [^]
------
(0019972)
hudsonbot   
2009-09-14 21:07   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/97/ [^]
------
(0019986)
hudsonbot   
2009-09-14 21:17   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/178/ [^]
------
(0020002)
hudsonbot   
2009-09-14 23:15   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/139/ [^]
------
(0020008)
hudsonbot   
2009-09-15 00:26   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-oracle/347/ [^]
------
(0020009)
hudsonbot   
2009-09-15 00:38   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/353/ [^]
------
(0020010)
hudsonbot   
2009-09-15 01:09   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/98/ [^]
------
(0020023)
hudsonbot   
2009-09-15 09:45   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/865/ [^]
------
(0020027)
hudsonbot   
2009-09-15 09:50   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/758/ [^]
------
(0020031)
hudsonbot   
2009-09-15 10:34   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-smoke-test/64/ [^]
------
(0020040)
hudsonbot   
2009-09-15 10:57   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/866/ [^]
------
(0020046)
hudsonbot   
2009-09-15 11:09   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/759/ [^]
------
(0020053)
hudsonbot   
2009-09-15 12:12   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/99/ [^]
------
(0020067)
hudsonbot   
2009-09-15 12:35   
Fixed Issue 10593

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/179/ [^]
------
(0020462)
hgbot   
2009-09-29 14:11   
Repository: erp/devel/pi-pageddatagrid
Changeset: 5f2b71efe628fe342e6e3d7caeda27da4fe8d9a9
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Sep 14 20:31:20 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/5f2b71efe628fe342e6e3d7caeda27da4fe8d9a9 [^]

Fixed 10593: Add missing to_number in optional parameter

---
M src/org/openbravo/erpCommon/utility/ReferencedLink_data.xsql
---
(0020751)
psarobe   
2009-10-06 11:21   
Closed again because hudson has reopened without no reason