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 | ||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | No | |||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| 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 (viewer) 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 | OBNetwork customer | => No | 
| 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 |