0012819: The variable length of the variable v_ClassName on the trigger ad_tab_trg2 is not correct

Description

The variable length of the variable v_ClassName on the trigger ad_tab_trg2 is not correct.

The length of the variable is 60 and should be bigger because on the trigger
the variable is filled with the mane of the window that could have 60 caracteres plus the tab id.

See the following code of the trigger:

       SELECT AD_MAPPING_FORMAT(TO_CHAR(W.NAME)),
               AD_MAPPING_FORMAT(TO_CHAR(:new.NAME))
        INTO v_WindowName, v_ClassName
        FROM AD_WINDOW W
        WHERE W.AD_WINDOW_ID = :new.AD_WINDOW_ID;

        --Add tab id to name for non core modules
        IF (:new.AD_Module_ID != '0') THEN
          v_ClassName := v_ClassName || :new.AD_Tab_ID;
         END IF;

Steps To Reproduce

-Starting on a 2.50mp8 create a new window with name with length 59.
-Add a tab
-Update to the last release
-You will get errors.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0025884) hgbot (developer) 2010-04-06 09:06	Repository: erp/devel/pi Changeset: cdfd97ab9a819e1855bb105d0d4ccb54fde370d8 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Tue Apr 06 09:17:40 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/cdfd97ab9a819e1855bb105d0d4ccb54fde370d8 [^] fixed bug 12819: The variable length of the variable v_ClassName incorrect --- M src-db/database/model/triggers/AD_TAB_TRG2.xml ---

(0026028) marvintm (viewer) 2010-04-09 13:04	The fix is correct

(0026411) hudsonbot (viewer) 2010-04-19 21:12	A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/cdfd97ab9a81 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]

Issue History
Date Modified	Username	Field	Change
2010-03-26 13:05	egoitz	New Issue
2010-03-26 13:05	egoitz	Assigned To	=> alostale
2010-03-26 13:05	egoitz	OBNetwork customer	=> Yes
2010-03-29 08:18	alostale	Status	new => scheduled
2010-03-29 08:18	alostale	fix_in_branch	=> pi
2010-04-06 09:06	hgbot	Checkin
2010-04-06 09:06	hgbot	Note Added: 0025884
2010-04-06 09:06	hgbot	Status	scheduled => resolved
2010-04-06 09:06	hgbot	Resolution	open => fixed
2010-04-06 09:06	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/cdfd97ab9a819e1855bb105d0d4ccb54fde370d8 [^]
2010-04-09 13:04	marvintm	Note Added: 0026028
2010-04-09 13:04	marvintm	Status	resolved => closed
2010-04-09 13:04	marvintm	Fixed in Version	=> 2.50MP15
2010-04-10 00:00	anonymous	sf_bug_id	0 => 2984776
2010-04-19 21:12	hudsonbot	Checkin
2010-04-19 21:12	hudsonbot	Note Added: 0026411
2010-05-18 12:12	gorka_gil	Target Version	2.50MP15 => 2.50MP17