Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0035543 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2017-03-16 14:35 | 2017-03-17 10:02 | |||
| Reporter | alostale | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR17Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 839d66eb2879 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | caristu | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0035543: incorrect export of indexes including CASE expressions | |||||||
| Description | Indexes containing a CASE expression are not correctly are not correctly exported. | |||||||
| Steps To Reproduce | 1. Create an index as: create index fin_payment_bpartner_credit on fin_payment ((CASE generated_credit WHEN used_credit THEN 'Y' ELSE 'N' END)); 2. Export database -> check the xml is not correct, having the index in multiple lines | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0095324) hgbot (developer) 2017-03-16 15:25 |
Repository: erp/devel/pi Changeset: b2399983cba65bbaf369322edda57206b79f4ca2 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Mar 16 15:05:03 2017 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/b2399983cba65bbaf369322edda57206b79f4ca2 [^] fixed bug 35543: incorrect export of indexes including CASE expressions Indexes with CASE expressions, were incorrectly and differently exported in PG and ORA. PG transforms the expression in multi line and in both ORA and PG extra blankspaces are added. Fixed in by removing new lines in PG (the same as done in views) and removing extra blankspaces in both cases. --- M src-db/database/lib/dbsourcemanager.jar --- |
|
(0095325) hgbot (developer) 2017-03-16 15:25 |
Repository: erp/devel/dbsm-main Changeset: 839d66eb2879fd960641ec57aed9cf696baad161 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Mar 16 15:03:46 2017 +0100 URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/839d66eb2879fd960641ec57aed9cf696baad161 [^] fixed bug 35543: incorrect export of indexes including CASE expressions Indexes with CASE expressions, were incorrectly and differently exported in PG and ORA. PG transforms the expression in multi line and in both ORA and PG extra blankspaces are added. Fixed in by removing new lines in PG (the same as done in views) and removing extra blankspaces in both cases. --- M src-test/src/org/openbravo/dbsm/test/model/FunctionBasedIndexes.java M src/org/apache/ddlutils/platform/oracle/OracleModelLoader.java M src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java A src-test/model/indexes/FUNCTION_INDEX_CASE.xml --- |
|
(0095349) hudsonbot (developer) 2017-03-17 02:25 |
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/d8d787cce2bb [^] Maturity status: Test |
|
(0095357) caristu (developer) 2017-03-17 10:01 |
Code reviewed + testing OK. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-03-16 14:35 | alostale | New Issue | |
| 2017-03-16 14:35 | alostale | Assigned To | => platform |
| 2017-03-16 14:35 | alostale | Modules | => Core |
| 2017-03-16 14:35 | alostale | Triggers an Emergency Pack | => No |
| 2017-03-16 14:35 | alostale | Review Assigned To | => caristu |
| 2017-03-16 14:35 | alostale | Assigned To | platform => alostale |
| 2017-03-16 15:25 | hgbot | Checkin | |
| 2017-03-16 15:25 | hgbot | Note Added: 0095324 | |
| 2017-03-16 15:25 | hgbot | Status | new => resolved |
| 2017-03-16 15:25 | hgbot | Resolution | open => fixed |
| 2017-03-16 15:25 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/b2399983cba65bbaf369322edda57206b79f4ca2 [^] |
| 2017-03-16 15:25 | alostale | Relationship added | related to 0030179 |
| 2017-03-16 15:25 | hgbot | Checkin | |
| 2017-03-16 15:25 | hgbot | Note Added: 0095325 | |
| 2017-03-16 15:25 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/b2399983cba65bbaf369322edda57206b79f4ca2 [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/839d66eb2879fd960641ec57aed9cf696baad161 [^] |
| 2017-03-17 02:25 | hudsonbot | Checkin | |
| 2017-03-17 02:25 | hudsonbot | Note Added: 0095349 | |
| 2017-03-17 10:01 | caristu | Note Added: 0095357 | |
| 2017-03-17 10:01 | caristu | Status | resolved => closed |
| 2017-03-17 10:01 | caristu | Fixed in Version | => 3.0PR17Q2 |
| 2017-03-17 10:02 | caristu | Relationship added | related to 0035474 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |