Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035543
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2017-03-16 14:352017-03-17 10:02
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q2
StatusclosedFix in branchFixed in SCM revision839d66eb2879
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035543: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0035474 closedalostale Function based indexes do not support arithmetic operations on columns 
related to feature request 00301793.0PR15Q4 closedAugustoMauch DBSourceManager support indexes with functions 

-  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.

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker