0000552: ReportBankJR_data.xsql fails to compile in pgsql

Description

[java] 10689 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ad_reports/ReportBankJR_data.xsql processed
     [java] 10706 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java]
     [java] SELECT C_BANK.NAME AS NAME, C_BANKSTATEMENT.NAME AS NAME2, C_BANKSTATEMENT.C_BANKACCOUNT_ID AS C_BANKACCOUNT_ID,
     [java] AD_COLUMN_IDENTIFIER('C_BANKACCOUNT',C_BANKACCOUNT.C_BANKACCOUNT_ID,'es_ES') AS bankaccount,
     [java] C_BANKSTATEMENTLINE.STMTAMT AS TRXAMT, C_DEBT_PAYMENT.AMOUNT AS PAYAMT, C_BANKSTATEMENT.C_BANKSTATEMENT_ID AS BANKSTATEMENT_ID,
     [java] C_BANKSTATEMENTLINE.DATEACCT AS STATEMENTDATE, C_BANKSTATEMENT.BEGINNINGBALANCE AS BEGINING, C_BANKSTATEMENT.ENDINGBALANCE AS ENDING,
     [java] C_CURRENCY.DESCRIPTION AS CURRENCY, C_BANKSTATEMENTLINE.LINE AS LINE, C_BANKSTATEMENTLINE.DESCRIPTION AS DESCRIPTION,
     [java] INITIALBALANCE.TOTAL_AMT AS INITIALBALANCE
     [java] FROM C_BANKSTATEMENTLINE left join C_DEBT_PAYMENT on C_BANKSTATEMENTLINE.C_DEBT_PAYMENT_ID = C_DEBT_PAYMENT.C_DEBT_PAYMENT_ID,
     [java] C_BANK, C_BANKACCOUNT, C_BANKSTATEMENT, C_CURRENCY, (
     [java] SELECT SUM(TOTAL_AMT) AS TOTAL_AMT, C_BANKACCOUNT_ID FROM
     [java] (SELECT COALESCE(SUM(C_BANKSTATEMENTLINE.STMTAMT),0) AS TOTAL_AMT, C_BANKACCOUNT.C_BANKACCOUNT_ID
     [java] FROM C_BANK, C_BANKACCOUNT, C_BANKSTATEMENT, C_BANKSTATEMENTLINE
     [java] WHERE C_BANK.C_BANK_ID = C_BANKACCOUNT.C_BANK_ID
     [java] AND C_BANKACCOUNT.C_BANKACCOUNT_ID = C_BANKSTATEMENT.C_BANKACCOUNT_ID
     [java] AND C_BANKSTATEMENT.C_BANKSTATEMENT_ID = C_BANKSTATEMENTLINE.C_BANKSTATEMENT_ID
     [java] AND 3=3 AND C_BANK.AD_CLIENT_ID IN ('2')
     [java] AND 3=3 AND C_BANK.AD_ORG_ID IN ('2')
     [java] AND C_BANKSTATEMENTLINE.DATEACCT < TO_DATE(?)
     [java] AND C_BANKSTATEMENT.PROCESSED='Y'
     [java] GROUP BY C_BANKACCOUNT.C_BANKACCOUNT_ID
     [java] UNION ALL
     [java] SELECT 0 AS TOTAL_AMT, C_BANKACCOUNT_ID
     [java] FROM C_BANKACCOUNT)
     [java] GROUP BY C_BANKACCOUNT_ID
     [java] ) INITIALBALANCE
     [java] WHERE C_BANK.c_bank_id = C_BANKACCOUNT.C_BANK_ID
     [java] AND C_BANKACCOUNT.C_BANKACCOUNT_ID = C_BANKSTATEMENT.C_BANKACCOUNT_ID
     [java] AND C_BANKSTATEMENT.C_BANKSTATEMENT_ID = C_BANKSTATEMENTLINE.C_BANKSTATEMENT_ID
     [java] AND C_BANKACCOUNT.C_CURRENCY_ID = C_CURRENCY.C_CURRENCY_ID
     [java] AND C_BANKACCOUNT.C_BANKACCOUNT_ID = INITIALBALANCE.C_BANKACCOUNT_ID
     [java] AND 4=4 AND C_BANK.AD_CLIENT_ID IN ('1')
     [java] AND 4=4 AND C_BANK.AD_ORG_ID IN ('1')
     [java] AND 1=1
     [java] AND C_BANKSTATEMENT.PROCESSED='Y'
     [java] ORDER BY C_BANK.NAME, STATEMENTDATE, LINE
     [java] Exception:org.postgresql.util.PSQLException: ERROR: subquery in FROM must have an alias
     [java] org.postgresql.util.PSQLException: ERROR: subquery in FROM must have an alias

Steps To Reproduce

1. Get the latest trunk (r4832 at this moment).
2. Run "ant install.source".

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0000553

2.40

closed

alostale

Build should stop when sqlc fails

Notes
(0000444) svnbot (viewer) 2008-06-05 10:44	Repository: openbravo Revision: 4834 Author: cromeroherrero Date: 2008-06-05 10:44:00 +0200 (Thu, 05 Jun 2008) Fixed bug 552 : ReportBankJR_data.xsql does not compile for PostgreSQL - Corrected invocation to AD_COLUMN_IDENTIFIER and added an alias for a subquery --- U trunk/src/org/openbravo/erpCommon/ad_reports/ReportBankJR_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=4834&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-06-05 08:10	jpabloae	New Issue
2008-06-05 08:10	jpabloae	Assigned To	=> cromero
2008-06-05 08:10	jpabloae	OBNetwork customer	=> N
2008-06-05 08:30	jpabloae	Relationship added	related to 0000553
2008-06-05 10:44	svnbot	Checkin
2008-06-05 10:44	svnbot	Note Added: 0000444
2008-06-05 10:44	svnbot	Status	new => resolved
2008-06-05 10:44	svnbot	Resolution	open => fixed
2008-06-05 10:44	svnbot	svn_revision	=> 4834
2008-06-11 12:46	cromero	Target Version	=> 2.40
2008-06-11 14:33	cromero	Fixed in Version	=> 2.40alpha r3
2008-06-19 11:14	plujan	Status	resolved => closed
2008-07-01 17:56	anonymous	sf_bug_id	0 => 2007927