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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0042450
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2019-11-29 11:272019-12-11 10:53
ReportershuehnerView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version3.0PR20Q1
StatusclosedFix in branchFixed in SCM revisionf951cac53b1a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toalostale
Web browser
ModulesCore
Regression levelPre packaging ( pi )
Regression date2019-11-27
Regression introduced in releasepi
Regression introduced by commithttps://gitlab.com/openbravocode/product/openbravo/commit/410fb3301d8ae51a2 [^]
Triggers an Emergency PackNo
Summary

0042450: Error during create.database with Postgresql11,12 and 13 with user_tab_columns view

DescriptionTrying to user create.database with postgresql-13 devel snapshot the user_tab_columns view fails with:
[createdatabase] 5831 [main] WARN org.apache.ddlutils.platform.PGStandardBatchEvaluator - SQL Command failed with: ERROR: column "attmissingval" has pseudo-type anyarray

Steps To Reproducerun create.database against postgresql-13 devel version
TagsNo tags attached.
Attached Filesdiff file icon fix-42450-pg11.06.diff [^] (1,284 bytes) 2019-12-06 12:20 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
caused by feature request 00420423.0PR20Q1 closedAugustoMauch Add support of materialized views 
blocks feature request 0042449 closedshuehner support PostgreSQL 13 

-  Notes
(0116124)
mauricio_peccorini (developer)
2019-12-06 12:20

Added patch fix-42450-pg11.06.diff that works for PostgreSQL 11.06. I have not tested it on PG12 or PG13.
(0116167)
hgbot (developer)
2019-12-10 13:31

Repository: erp/devel/pi
Changeset: f951cac53b1ab3fb423e9b42c7e9d212f067e4ec
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Dec 09 15:47:18 2019 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f951cac53b1ab3fb423e9b42c7e9d212f067e4ec [^]

fixes BUG-42450: Removes uneeded clause from user_tab_columns view definition

The 'a.*' part at the end of the select clause was not needed. All fields referenced
by the AD_TABLE_IMPORT function are already included in the select clause.

---
M src-db/database/model/prescript-PostgreSql.sql
---
(0116177)
alostale (manager)
2019-12-11 10:53

https://gitlab.com/openbravocode/product/openbravo/merge_requests/26 [^]

- Issue History
Date Modified Username Field Change
2019-11-29 11:27 shuehner New Issue
2019-11-29 11:27 shuehner Assigned To => platform
2019-11-29 11:27 shuehner Modules => Core
2019-11-29 11:27 shuehner Triggers an Emergency Pack => No
2019-11-29 11:49 shuehner Relationship added blocks 0042449
2019-11-29 13:00 alostale Relationship added caused by 0042042
2019-11-29 13:03 alostale Regression level => Pre packaging ( pi )
2019-11-29 13:03 alostale Regression date => 2019-11-27
2019-11-29 13:03 alostale Regression introduced in release => pi
2019-11-29 13:03 alostale Regression introduced by commit => https://gitlab.com/openbravocode/product/openbravo/commit/410fb3301d8ae51a2 [^]
2019-12-06 12:20 mauricio_peccorini File Added: fix-42450-pg11.06.diff
2019-12-06 12:20 mauricio_peccorini Note Added: 0116124
2019-12-09 11:28 alostale Assigned To platform => AugustoMauch
2019-12-09 11:28 alostale Status new => acknowledged
2019-12-09 15:52 AugustoMauch Review Assigned To => alostale
2019-12-09 15:53 AugustoMauch Status acknowledged => scheduled
2019-12-10 13:31 hgbot Checkin
2019-12-10 13:31 hgbot Note Added: 0116167
2019-12-10 13:31 hgbot Status scheduled => resolved
2019-12-10 13:31 hgbot Resolution open => fixed
2019-12-10 13:31 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f951cac53b1ab3fb423e9b42c7e9d212f067e4ec [^]
2019-12-11 10:04 shuehner Summary Error during create.database with Postgresql13 with user_tab_columns view => Error during create.database with Postgresql11,12 and 13 with user_tab_columns view
2019-12-11 10:53 alostale Note Added: 0116177
2019-12-11 10:53 alostale Status resolved => closed
2019-12-11 10:53 alostale Fixed in Version => 3.0PR20Q1


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker