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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035467
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformminoralways2017-03-09 12:532017-03-09 14:16
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q1
StatusclosedFix in branchFixed in SCM revisiona87f1ae21860
ProjectionnoneETAnoneTarget Version3.0PR17Q1
OSLinux 64 bitDatabasePostgreSQLJava version1.7.0_45
OS VersionCentOS 6.4Database version8.4.18Ant version1.7.1
Product Version3.0PR14Q3.5SCM revision3.0.24063 
Review Assigned Tocaristu
Web browserGoogle Chrome, Mozilla Firefox
ModulesOpenbravo 3.0 Framework
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035467: Wrong export of a view

DescriptionOpenbravo exports bad a view (with ant export.database), what causes rebuild error. I created a SRCT_INVOICE_DDPPRL (view in the attached file)
Steps To ReproduceCreate view (in the example without some columns no-standard)in the database (and Openbravo Application Dictionary) and export it, try reinstall the module.
Proposed SolutionI changed xml file content and it works, but I think it will generate error in the future in the ant export.database with the module.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0035341 closedmcobas Wrong orders shown in "Create Invoices From Orders" window 
related to design defect 0029492 closedalostale Wrong export of a view 

-  Notes
(0094874)
hgbot (developer)
2017-03-09 13:11

 Repository: erp/devel/dbsm-main
Changeset: dc1d0235612a8bf06506ffe110b25723ef3b07e9
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Mar 09 08:56:11 2017 +0100
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/dc1d0235612a8bf06506ffe110b25723ef3b07e9 [^]

related to bug 35467: added test cases

  Added failing (before fix 29492) test cases: views with more than one IN or
  NOT IN clauses are not correctly converted in PG.

---
M src-test/src/org/openbravo/dbsm/test/model/Views.java
A src-test/model/views/IN_VIEW.xml
A src-test/model/views/NOT_IN_VIEW.xml
---
(0094875)
hgbot (developer)
2017-03-09 13:11

 Repository: erp/backports/3.0PR17Q1
Changeset: a87f1ae218605558ca84411c1cd63ab19a4744cd
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Mar 09 13:08:47 2017 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR17Q1/rev/a87f1ae218605558ca84411c1cd63ab19a4744cd [^]

fixed bug 35467: views with several IN or NOT IN clasues fail in PG

  In PG, views that contain more than one IN or NOT IN clauses were not correctly
  exported.

  The regexps that parses and PG IN and NOT IN clauses was including from the begining
  of 1st clause till the end of the last one.

  These regexps have been fixed to be more restrictive so that they stop looking
  for the IN contents on first ].

---
M src-db/database/lib/dbsourcemanager.jar
---
(0094876)
hgbot (developer)
2017-03-09 13:11

 Repository: erp/backports/3.0PR17Q1
Changeset: a87f1ae218605558ca84411c1cd63ab19a4744cd
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Mar 09 13:08:47 2017 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR17Q1/rev/a87f1ae218605558ca84411c1cd63ab19a4744cd [^]

fixed bug 35467: views with several IN or NOT IN clasues fail in PG

  In PG, views that contain more than one IN or NOT IN clauses were not correctly
  exported.

  The regexps that parses and PG IN and NOT IN clauses was including from the begining
  of 1st clause till the end of the last one.

  These regexps have been fixed to be more restrictive so that they stop looking
  for the IN contents on first ].

---
M src-db/database/lib/dbsourcemanager.jar
---
(0094879)
caristu (developer)
2017-03-09 14:16

 Code reviewed + tested OK.

- Issue History
Date Modified Username Field Change
2017-03-09 12:53 alostale New Issue
2017-03-09 12:53 alostale Assigned To => alostale
2017-03-09 12:53 alostale Web browser => Google Chrome, Mozilla Firefox
2017-03-09 12:53 alostale Modules => Openbravo 3.0 Framework
2017-03-09 12:53 alostale Triggers an Emergency Pack => No
2017-03-09 12:53 alostale Issue generated from 0029492
2017-03-09 12:53 alostale Relationship added related to 0035341
2017-03-09 12:53 alostale Web browser Google Chrome, Mozilla Firefox => Google Chrome, Mozilla Firefox
2017-03-09 12:53 alostale Target Version => 3.0PR17Q1
2017-03-09 12:54 alostale Relationship added related to 0029492
2017-03-09 13:11 hgbot Checkin
2017-03-09 13:11 hgbot Note Added: 0094874
2017-03-09 13:11 hgbot Checkin
2017-03-09 13:11 hgbot Note Added: 0094875
2017-03-09 13:11 hgbot Status new => resolved
2017-03-09 13:11 hgbot Resolution open => fixed
2017-03-09 13:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR17Q1/rev/a87f1ae218605558ca84411c1cd63ab19a4744cd [^]
2017-03-09 13:11 hgbot Checkin
2017-03-09 13:11 hgbot Note Added: 0094876
2017-03-09 13:12 alostale Review Assigned To => caristu
2017-03-09 13:12 alostale Web browser Google Chrome, Mozilla Firefox => Google Chrome, Mozilla Firefox
2017-03-09 14:16 caristu Note Added: 0094879
2017-03-09 14:16 caristu Status resolved => closed
2017-03-09 14:16 caristu Fixed in Version => 3.0PR17Q1
2017-03-10 13:47 alostale Relationship added related to 0035474
2017-03-10 13:50 alostale Relationship deleted related to 0035474

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker