Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035543Openbravo ERPA. Platformpublic2017-03-16 14:352017-03-17 10:02
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035543: incorrect export of indexes including CASE expressions
DescriptionIndexes containing a CASE expression are not correctly are not correctly exported.
Steps To Reproduce1. 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0035474 closed alostale Function based indexes do not support arithmetic operations on columns 
related to feature request 00301793.0PR15Q4 closed AugustoMauch DBSourceManager support indexes with functions 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-03-16 14:35alostaleNew Issue
2017-03-16 14:35alostaleAssigned To => platform
2017-03-16 14:35alostaleModules => Core
2017-03-16 14:35alostaleTriggers an Emergency Pack => No
2017-03-16 14:35alostaleReview Assigned To => caristu
2017-03-16 14:35alostaleAssigned Toplatform => alostale
2017-03-16 15:25hgbotCheckin
2017-03-16 15:25hgbotNote Added: 0095324
2017-03-16 15:25hgbotStatusnew => resolved
2017-03-16 15:25hgbotResolutionopen => fixed
2017-03-16 15:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b2399983cba65bbaf369322edda57206b79f4ca2 [^]
2017-03-16 15:25alostaleRelationship addedrelated to 0030179
2017-03-16 15:25hgbotCheckin
2017-03-16 15:25hgbotNote Added: 0095325
2017-03-16 15:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/b2399983cba65bbaf369322edda57206b79f4ca2 [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/839d66eb2879fd960641ec57aed9cf696baad161 [^]
2017-03-17 02:25hudsonbotCheckin
2017-03-17 02:25hudsonbotNote Added: 0095349
2017-03-17 10:01caristuNote Added: 0095357
2017-03-17 10:01caristuStatusresolved => closed
2017-03-17 10:01caristuFixed in Version => 3.0PR17Q2
2017-03-17 10:02caristuRelationship addedrelated to 0035474

Notes
(0095324)
hgbot   
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   
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   
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   
2017-03-17 10:01   
Code reviewed + testing OK.