Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004810Openbravo ERPZ. Otherspublic2008-09-03 20:492008-11-25 23:26
jpabloae 
alostale 
immediatecriticalalways
closedfixed 
30Gentoo - 2.6.24
 
 
Core
No
0004810: ReportBudgetGenerateExcel_data.xsql doesn't compile
The 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.
No tags attached.
Issue History
2008-09-03 20:49jpabloaeNew Issue
2008-09-03 20:49jpabloaeAssigned To => cromero
2008-09-03 20:49jpabloaesf_bug_id0 => 2091654
2008-09-03 20:49jpabloaeRegression testing => No
2008-09-04 09:02cromeroStatusnew => scheduled
2008-09-04 09:02cromeroAssigned Tocromero => alostale
2008-09-04 09:02cromerofix_in_branch => trunk
2008-09-04 09:04alostaleNote Added: 0008878
2008-09-04 09:04alostaleNote Edited: 0008878
2008-09-04 09:20svnbotCheckin
2008-09-04 09:20svnbotNote Added: 0008879
2008-09-04 09:20svnbotStatusscheduled => resolved
2008-09-04 09:20svnbotResolutionopen => fixed
2008-09-04 09:20svnbotsvn_revision => 6806
2008-11-25 23:26psarobeStatusresolved => closed

Notes
(0008878)
alostale   
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   
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 [^]