0020528: A SQL query is not compatible with 8.3 making the upgrade from 2.50 to fail

Description

When trying to update a 2.50 to 3.0 MP11 I've got an error:

[java] 2083 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: select ad_tab.ad_tab_id as tabid, ad_column.ad_column_id as columnid, ad_window.name as windowname, ad_tab.name as tabname,
     [java] ad_field.name fieldname,ad_column.name as columnname, ad_field.ad_module_id as moduleid, ad_module.name as modulename
     [java] from ad_window, ad_tab, ad_field, ad_column, ad_module
     [java] where ad_field.ad_column_id = ad_column.ad_column_id
     [java] and ad_field.ad_module_id = ad_module.ad_module_id
     [java] and ad_tab.ad_tab_id = ad_field.ad_tab_id
     [java] and ad_window.ad_window_id = ad_tab.ad_window_id
     [java] and (ad_module.javapackage in (
     [java] '1') or to_char('Y')=to_char(?))
     [java] and exists (select * from ad_field subFld where
     [java] subFld.ad_tab_id = ad_field.ad_tab_id
     [java] and subFld.ad_column_id = ad_field.ad_column_id
     [java] and ad_field.ad_field_id <> subFld.ad_field_id)
     [java] order by ad_tab.ad_tab_id, ad_column.ad_column_id
     [java]
     [java] org.postgresql.util.PSQLException: ERROR: syntax error at or near "fieldname"

Steps To Reproduce

rebuild after upgrading from 2.50 to 3.0 MP11

Tags

Regression QA

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0019986

closed

guilleaer

If two modules add same field to a tab compilation fails (even if field is non-visible)

Notes
(0048711) hgbot (developer) 2012-05-16 18:22	Repository: erp/devel/pi Changeset: 3075c0f96cd7a616902890e779a2744f11098a4c Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Wed May 16 18:21:14 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/3075c0f96cd7a616902890e779a2744f11098a4c [^] Fixed 20528: Add missing 'as' in select to fix compatibility with pgsql 8.3 --- M src-wad/src/org/openbravo/wad/validation/WADValidator_data.xsql ---

(0048720) AugustoMauch (administrator) 2012-05-17 11:20	Code reviewed and verified in pi@5e580de24a96

(0049150) hudsonbot (viewer) 2012-05-25 12:12	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5401e185a8b0 [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2012-05-16 17:32	plujan	New Issue
2012-05-16 17:32	plujan	Assigned To	=> guilleaer
2012-05-16 17:32	plujan	Modules	=> Core
2012-05-16 17:32	plujan	OBNetwork customer	=> No
2012-05-16 17:33	plujan	Relationship added	related to 0019986
2012-05-16 17:33	plujan	Tag Attached: Regression QA
2012-05-16 17:35	plujan	Assigned To	guilleaer => shuehner
2012-05-16 18:22	hgbot	Checkin
2012-05-16 18:22	hgbot	Note Added: 0048711
2012-05-16 18:22	hgbot	Status	new => resolved
2012-05-16 18:22	hgbot	Resolution	open => fixed
2012-05-16 18:22	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/3075c0f96cd7a616902890e779a2744f11098a4c [^]
2012-05-17 11:20	AugustoMauch	Note Added: 0048720
2012-05-17 11:20	AugustoMauch	Status	resolved => closed
2012-05-17 11:20	AugustoMauch	Fixed in Version	=> 3.0MP12
2012-05-25 12:12	hudsonbot	Checkin
2012-05-25 12:12	hudsonbot	Note Added: 0049150