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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005354
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. PlatformminorN/A2008-10-01 12:522022-02-01 08:08
ReportershuehnerView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision8296
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005354: 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.
TagsToBeReviewed
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0009403)
svnbot (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-10-01 12:52 shuehner New Issue
2008-10-01 12:52 shuehner Assigned To => cromero
2008-10-01 12:52 shuehner sf_bug_id 0 => 2140131
2008-10-01 12:52 shuehner Regression testing => No
2008-10-06 22:15 svnbot Checkin
2008-10-06 22:15 svnbot Note Added: 0009403
2008-10-06 22:15 svnbot svn_revision => 8296
2008-11-10 13:09 cromero Assigned To cromero => pjuvara
2008-11-17 07:04 pjuvara Tag Attached: ToBeReviewed
2009-05-22 19:34 pjuvara Assigned To pjuvara => iciordia
2018-04-08 17:05 shuehner Assigned To iciordia => platform
2022-02-01 08:08 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker