Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010592Openbravo ERP09. Financial managementpublic2009-09-14 20:212009-10-06 11:21
Reportershuehner 
Assigned Toshuehner 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
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
Summary0010592: Account_data.xsql (Account selector) has syntax error in optional parameter of countRows query
DescriptionThis xsql file has the following optional parameter defined:

<Parameter name="validcombination" optional="true" after="WHERE "><![CDATA[ C.C_VALIDCOMBINATION_ID = ?) AND ]]></Parameter>

Which has a closing bracket without an opening bracket -> SQL syntax error. This optional parameter is never used in the selectors' countRows query. However this error interferes with planned Sqlc performance improvements.

Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
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:21shuehnerNew Issue
2009-09-14 20:21shuehnerAssigned To => shuehner
2009-09-14 20:21shuehnerOBNetwork customer => No
2009-09-14 20:21shuehnerRelationship addedblocks 0004038
2009-09-14 20:22hgbotCheckin
2009-09-14 20:22hgbotNote Added: 0019954
2009-09-14 20:22hgbotStatusnew => resolved
2009-09-14 20:22hgbotResolutionopen => fixed
2009-09-14 20:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6d5cc529b734b11c90d749c5244bcbbde1d7d3ee [^]
2009-09-14 20:26shuehnerNote Added: 0019955
2009-09-14 20:42hudsonbotCheckin
2009-09-14 20:42hudsonbotNote Added: 0019957
2009-09-14 20:47hudsonbotCheckin
2009-09-14 20:47hudsonbotNote Added: 0019964
2009-09-14 20:48hudsonbotCheckin
2009-09-14 20:48hudsonbotNote Added: 0019969
2009-09-14 21:07hudsonbotCheckin
2009-09-14 21:07hudsonbotNote Added: 0019973
2009-09-14 21:17hudsonbotCheckin
2009-09-14 21:17hudsonbotNote Added: 0019988
2009-09-14 23:15hudsonbotCheckin
2009-09-14 23:15hudsonbotNote Added: 0020003
2009-09-15 00:26hudsonbotCheckin
2009-09-15 00:26hudsonbotNote Added: 0020007
2009-09-15 01:09hudsonbotCheckin
2009-09-15 01:09hudsonbotNote Added: 0020011
2009-09-15 09:45hudsonbotCheckin
2009-09-15 09:45hudsonbotNote Added: 0020024
2009-09-15 09:50hudsonbotCheckin
2009-09-15 09:50hudsonbotNote Added: 0020028
2009-09-15 10:34hudsonbotCheckin
2009-09-15 10:34hudsonbotNote Added: 0020032
2009-09-15 10:57hudsonbotCheckin
2009-09-15 10:57hudsonbotNote Added: 0020042
2009-09-15 11:09hudsonbotCheckin
2009-09-15 11:09hudsonbotNote Added: 0020044
2009-09-15 12:12hudsonbotCheckin
2009-09-15 12:12hudsonbotNote Added: 0020050
2009-09-15 12:35hudsonbotCheckin
2009-09-15 12:35hudsonbotNote Added: 0020068
2009-09-16 15:19sureshbabuStatusresolved => closed
2009-09-16 15:19sureshbabuNote Added: 0020115
2009-09-16 15:19sureshbabuFixed in Version => 2.50MP6
2009-09-17 00:00anonymoussf_bug_id0 => 2860318
2009-09-29 14:11hgbotCheckin
2009-09-29 14:11hgbotNote Added: 0020461
2009-09-29 14:11hgbotStatusclosed => resolved
2009-09-29 14:11hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6d5cc529b734b11c90d749c5244bcbbde1d7d3ee [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/6d5cc529b734b11c90d749c5244bcbbde1d7d3ee [^]
2009-10-06 11:20psarobeStatusresolved => closed
2009-10-06 11:20psarobeNote Added: 0020750

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

Fixed 10592: Fix syntax error in optional parameter of countRows query

---
M src/org/openbravo/erpCommon/info/Account_data.xsql
---
(0019955)
shuehner   
2009-09-14 20:26   
@qa: Should have zero functional impact, as the optional parameter is not used in the selector (hardcoded to ""), perhaps some basic regression testing of the filters of the selector.
(0019957)
hudsonbot   
2009-09-14 20:42   
Fixed Issue 10592

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/352/ [^]
------
(0019964)
hudsonbot   
2009-09-14 20:47   
Fixed Issue 10592

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

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

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

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

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

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-oracle/347/ [^]
------
(0020011)
hudsonbot   
2009-09-15 01:09   
Fixed Issue 10592

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

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

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

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

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

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

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

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/179/ [^]
------
(0020115)
sureshbabu   
2009-09-16 15:19   
Randomly tested the account selector in the accounting reports
(0020461)
hgbot   
2009-09-29 14:11   
Repository: erp/devel/pi-pageddatagrid
Changeset: 6d5cc529b734b11c90d749c5244bcbbde1d7d3ee
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Sep 14 20:22:19 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/6d5cc529b734b11c90d749c5244bcbbde1d7d3ee [^]

Fixed 10592: Fix syntax error in optional parameter of countRows query

---
M src/org/openbravo/erpCommon/info/Account_data.xsql
---
(0020750)
psarobe   
2009-10-06 11:20   
Closed again because hudson has reopened without no reason