Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005354Openbravo ERPA. Platformpublic2008-10-01 12:522022-02-01 08:08
Reportershuehner 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityN/A
StatusnewResolutionopen 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005354: Sqlc methods with return type String, have to use alias AS <existing field> without need for it
DescriptionWhen a xsql file contains the following two methods

a.) SELECT a,b,c from table (return="multiple")
b.) SELECT COUNT(*) AS A from table (return="String")

then the second one has to alias its return value as an existing returnvalue of the previous one, so that the alias-name is equal to one of the fields in the generated _data.java file. As the second method directly returns the result without using the fields in the java-class this should not be needed.
Steps To Reproduce
Proposed Solution
Additional Information
TagsToBeReviewed
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-01 12:52shuehnerNew Issue
2008-10-01 12:52shuehnerAssigned To => cromero
2008-10-01 12:52shuehnersf_bug_id0 => 2140131
2008-10-01 12:52shuehnerRegression testing => No
2008-10-06 22:15svnbotCheckin
2008-10-06 22:15svnbotNote Added: 0009403
2008-10-06 22:15svnbotsvn_revision => 8296
2008-11-10 13:09cromeroAssigned Tocromero => pjuvara
2008-11-17 07:04pjuvaraTag Attached: ToBeReviewed
2009-05-22 19:34pjuvaraAssigned Topjuvara => iciordia
2018-04-08 17:05shuehnerAssigned Toiciordia => platform
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base

Notes
(0009403)
svnbot   
2008-10-06 22:15   
Repository: openbravo
Revision: 8296
Author: huehner
Date: 2008-10-06 22:15:45 +0200 (Mon, 06 Oct 2008)

Place set-method in changes xsql files directly after a select-method which returns all fields,
not after a count-method as then sqlc will generate the set-methods content based on this one field only
Needed to workaround issue 5354

---
U branches/r2.40performance/src/org/openbravo/erpCommon/info/BusinessPartner_data.xsql
U branches/r2.40performance/src/org/openbravo/erpCommon/info/InvoiceLine_data.xsql
U branches/r2.40performance/src/org/openbravo/erpCommon/info/Invoice_data.xsql
U branches/r2.40performance/src/org/openbravo/erpCommon/info/Product_data.xsql
U branches/r2.40performance/src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql
U branches/r2.40performance/src/org/openbravo/erpCommon/info/SalesOrder_data.xsql
---

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