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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010592
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminorhave not tried2009-09-14 20:212009-10-06 11:21
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PriorityhighResolutionfixedFixed in Version2.50MP6
StatusclosedFix in branchFixed in SCM revision6d5cc529b734
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
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
Summary

0010592: 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.

TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0004038 closedshuehner Slow compilation in sqlC part due to high amount of data 

-  Notes
(0019954)
hgbot (developer)
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 (administrator)
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 (viewer)
2009-09-14 20:42

 Fixed Issue 10592

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

 Fixed Issue 10592

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

 Fixed Issue 10592

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

 Fixed Issue 10592

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/97/ [^]
------
(0019988)
hudsonbot (viewer)
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 (viewer)
2009-09-14 23:15

 Fixed Issue 10592

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

 Fixed Issue 10592

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

 Fixed Issue 10592

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

 Fixed Issue 10592

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

 Fixed Issue 10592

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

 Fixed Issue 10592

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

 Fixed Issue 10592

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

 Fixed Issue 10592

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

 Fixed Issue 10592

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/99/ [^]
------
(0020068)
hudsonbot (viewer)
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 (viewer)
2009-09-16 15:19

 Randomly tested the account selector in the accounting reports
(0020461)
hgbot (developer)
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 (viewer)
2009-10-06 11:20

 Closed again because hudson has reopened without no reason

- Issue History
Date Modified Username Field Change
2009-09-14 20:21 shuehner New Issue
2009-09-14 20:21 shuehner Assigned To => shuehner
2009-09-14 20:21 shuehner OBNetwork customer => No
2009-09-14 20:21 shuehner Relationship added blocks 0004038
2009-09-14 20:22 hgbot Checkin
2009-09-14 20:22 hgbot Note Added: 0019954
2009-09-14 20:22 hgbot Status new => resolved
2009-09-14 20:22 hgbot Resolution open => fixed
2009-09-14 20:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6d5cc529b734b11c90d749c5244bcbbde1d7d3ee [^]
2009-09-14 20:26 shuehner Note Added: 0019955
2009-09-14 20:42 hudsonbot Checkin
2009-09-14 20:42 hudsonbot Note Added: 0019957
2009-09-14 20:47 hudsonbot Checkin
2009-09-14 20:47 hudsonbot Note Added: 0019964
2009-09-14 20:48 hudsonbot Checkin
2009-09-14 20:48 hudsonbot Note Added: 0019969
2009-09-14 21:07 hudsonbot Checkin
2009-09-14 21:07 hudsonbot Note Added: 0019973
2009-09-14 21:17 hudsonbot Checkin
2009-09-14 21:17 hudsonbot Note Added: 0019988
2009-09-14 23:15 hudsonbot Checkin
2009-09-14 23:15 hudsonbot Note Added: 0020003
2009-09-15 00:26 hudsonbot Checkin
2009-09-15 00:26 hudsonbot Note Added: 0020007
2009-09-15 01:09 hudsonbot Checkin
2009-09-15 01:09 hudsonbot Note Added: 0020011
2009-09-15 09:45 hudsonbot Checkin
2009-09-15 09:45 hudsonbot Note Added: 0020024
2009-09-15 09:50 hudsonbot Checkin
2009-09-15 09:50 hudsonbot Note Added: 0020028
2009-09-15 10:34 hudsonbot Checkin
2009-09-15 10:34 hudsonbot Note Added: 0020032
2009-09-15 10:57 hudsonbot Checkin
2009-09-15 10:57 hudsonbot Note Added: 0020042
2009-09-15 11:09 hudsonbot Checkin
2009-09-15 11:09 hudsonbot Note Added: 0020044
2009-09-15 12:12 hudsonbot Checkin
2009-09-15 12:12 hudsonbot Note Added: 0020050
2009-09-15 12:35 hudsonbot Checkin
2009-09-15 12:35 hudsonbot Note Added: 0020068
2009-09-16 15:19 sureshbabu Status resolved => closed
2009-09-16 15:19 sureshbabu Note Added: 0020115
2009-09-16 15:19 sureshbabu Fixed in Version => 2.50MP6
2009-09-17 00:00 anonymous sf_bug_id 0 => 2860318
2009-09-29 14:11 hgbot Checkin
2009-09-29 14:11 hgbot Note Added: 0020461
2009-09-29 14:11 hgbot Status closed => resolved
2009-09-29 14:11 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/6d5cc529b734b11c90d749c5244bcbbde1d7d3ee [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/6d5cc529b734b11c90d749c5244bcbbde1d7d3ee [^]
2009-10-06 11:20 psarobe Status resolved => closed
2009-10-06 11:20 psarobe Note Added: 0020750

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker