Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0030737 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2015-09-02 12:27 | 2015-09-14 17:57 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | a98b85433a15 | ||||
| Projection | none | ETA | none | Target Version | 3.0PR15Q4 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | inigosanchez | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0030737: New ad_table_navigation_mod_trg is broken for updates (It has wrong coalesce mixing varchar & numeric data) | |||||||
| Description | That trigger is broken and does not work for updates because if has a wrong sql code doing the following: COALESCE(NEW.SeqNo , '.') != COALESCE(OLD.SeqNo , '.') OR Which is mixing numeric column seqno with a varchar '.' which is wrong. Probably cause copy'n'paste of other text column and then no testing done for the update case of that trigger ERROR: invalid input syntax for type numeric: "." Where: PL/pgSQL function ad_table_navigation_mod_trg() line 66 at IF | |||||||
| Steps To Reproduce | Preparation: On a postgres db Search for a table having a ad_table_navigation entry or create such an entry for any table. then without any module in development try to edit in UI the ad_table_navigation entry and check the error message appearing. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0080017) shuehner (administrator) 2015-09-02 12:29 |
Adding target version Q4 as that is new project merged for Q4 so the error in the project has not been published yet and should be fixed before publishing. |
|
(0080189) hgbot (developer) 2015-09-07 13:15 |
Repository: erp/devel/pi Changeset: a98b85433a15ff3d76ea47fef0dd7992e75a0e3f Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Mon Sep 07 13:13:46 2015 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/a98b85433a15ff3d76ea47fef0dd7992e75a0e3f [^] fixed bug 30737: broken ad_table_navigation_mod_trg for updates ad_table_navigation_mod_trg trigger had a coalesce that was mxing types (varchar and numeric) which is not allowed raising an error in when this code was exectued. Fixed by completely removing this colasce as it was in seqNo column which is mandatory. --- M src-db/database/model/triggers/AD_TABLE_NAVIGATION_MOD_TRG.xml --- |
|
(0080249) hudsonbot (developer) 2015-09-08 19:28 |
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/16e399c2fccf [^] Maturity status: Test |
|
(0080385) inigosanchez (developer) 2015-09-14 17:57 |
Code reviewed and verified in pi@d45d2896cfa6 Tested in PostgreSQL 9.1.14 & Oracle 11.2 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-09-02 12:27 | shuehner | New Issue | |
| 2015-09-02 12:27 | shuehner | Assigned To | => platform |
| 2015-09-02 12:27 | shuehner | Modules | => Core |
| 2015-09-02 12:27 | shuehner | Triggers an Emergency Pack | => No |
| 2015-09-02 12:27 | shuehner | Severity | minor => major |
| 2015-09-02 12:29 | shuehner | Note Added: 0080017 | |
| 2015-09-02 12:29 | shuehner | Target Version | => 3.0PR15Q4 |
| 2015-09-07 13:05 | alostale | Status | new => scheduled |
| 2015-09-07 13:05 | alostale | Assigned To | platform => alostale |
| 2015-09-07 13:14 | alostale | Review Assigned To | => inigosanchez |
| 2015-09-07 13:15 | hgbot | Checkin | |
| 2015-09-07 13:15 | hgbot | Note Added: 0080189 | |
| 2015-09-07 13:15 | hgbot | Status | scheduled => resolved |
| 2015-09-07 13:15 | hgbot | Resolution | open => fixed |
| 2015-09-07 13:15 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/a98b85433a15ff3d76ea47fef0dd7992e75a0e3f [^] |
| 2015-09-08 19:28 | hudsonbot | Checkin | |
| 2015-09-08 19:28 | hudsonbot | Note Added: 0080249 | |
| 2015-09-14 17:57 | inigosanchez | Note Added: 0080385 | |
| 2015-09-14 17:57 | inigosanchez | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |