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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0004810
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Otherscriticalalways2008-09-03 20:492008-11-25 23:26
ReporterjpabloaeView Statuspublic 
Assigned Toalostale 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision6806
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version1.5.0_16
OS VersionGentoo - 2.6.24Database version10.2.0.4Ant version1.7.0
Product VersionSCM 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

0004810: ReportBudgetGenerateExcel_data.xsql doesn't compile

DescriptionThe xsql file has MAX(M_PRODUCT_CATEGORY_ID) and MAX(C_BP_GROUP_ID). Those IDs are varchar, so a maximum of a varchar does not make sense.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0008878)
alostale (viewer)
2008-09-04 09:04
edited on: 2008-09-04 09:04

Actually that is not the problem (max ID will just take a single record). The problem is with one of the CASEs it does something like

  CASE number ELSE varchar

which is not consistent

(0008879)
svnbot (viewer)
2008-09-04 09:20

Repository: openbravo
Revision: 6806
Author: alostale
Date: 2008-09-04 09:20:07 +0200 (Thu, 04 Sep 2008)

fixed bug 4810: src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel_data.xsql did not compile

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=6806&sc=1 [^]

- Issue History
Date Modified Username Field Change
2008-09-03 20:49 jpabloae New Issue
2008-09-03 20:49 jpabloae Assigned To => cromero
2008-09-03 20:49 jpabloae sf_bug_id 0 => 2091654
2008-09-03 20:49 jpabloae OBNetwork customer => No
2008-09-03 20:49 jpabloae Regression testing => No
2008-09-04 09:02 cromero Status new => scheduled
2008-09-04 09:02 cromero Assigned To cromero => alostale
2008-09-04 09:02 cromero fix_in_branch => trunk
2008-09-04 09:04 alostale Note Added: 0008878
2008-09-04 09:04 alostale Note Edited: 0008878
2008-09-04 09:20 svnbot Checkin
2008-09-04 09:20 svnbot Note Added: 0008879
2008-09-04 09:20 svnbot Status scheduled => resolved
2008-09-04 09:20 svnbot Resolution open => fixed
2008-09-04 09:20 svnbot svn_revision => 6806
2008-11-25 23:26 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker