Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0005354 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
feature request | [Openbravo ERP] A. Platform | minor | N/A | 2008-10-01 12:52 | 2022-02-01 08:08 | |||||||
Reporter | shuehner | View Status | public | |||||||||
Assigned To | Triage Platform Base | |||||||||||
Priority | normal | Resolution | open | Fixed in Version | ||||||||
Status | new | Fix in branch | Fixed in SCM revision | 8296 | ||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | Any | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | pi | SCM revision | ||||||||||
Review Assigned To | ||||||||||||
Web browser | ||||||||||||
Modules | Core | |||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0005354: Sqlc methods with return type String, have to use alias AS <existing field> without need for it | |||||||||||
Description | When 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. | |||||||||||
Tags | ToBeReviewed | |||||||||||
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 |