Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042450Openbravo ERPA. Platformpublic2019-11-29 11:272019-12-11 10:53
Reportershuehner 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR20Q1 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
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
Summary0042450: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 00420423.0PR20Q1 closed AugustoMauch Add support of materialized views 
blocks feature request 0042449 closed shuehner support PostgreSQL 13 
Attached Filesdiff fix-42450-pg11.06.diff (1,284) 2019-12-06 12:20
https://issues.openbravo.com/file_download.php?file_id=13633&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-11-29 11:27shuehnerNew Issue
2019-11-29 11:27shuehnerAssigned To => platform
2019-11-29 11:27shuehnerModules => Core
2019-11-29 11:27shuehnerTriggers an Emergency Pack => No
2019-11-29 11:49shuehnerRelationship addedblocks 0042449
2019-11-29 13:00alostaleRelationship addedcaused by 0042042
2019-11-29 13:03alostaleRegression level => Pre packaging ( pi )
2019-11-29 13:03alostaleRegression date => 2019-11-27
2019-11-29 13:03alostaleRegression introduced in release => pi
2019-11-29 13:03alostaleRegression introduced by commit => https://gitlab.com/openbravocode/product/openbravo/commit/410fb3301d8ae51a2 [^]
2019-12-06 12:20mauricio_peccoriniFile Added: fix-42450-pg11.06.diff
2019-12-06 12:20mauricio_peccoriniNote Added: 0116124
2019-12-09 11:28alostaleAssigned Toplatform => AugustoMauch
2019-12-09 11:28alostaleStatusnew => acknowledged
2019-12-09 15:52AugustoMauchReview Assigned To => alostale
2019-12-09 15:53AugustoMauchStatusacknowledged => scheduled
2019-12-10 13:31hgbotCheckin
2019-12-10 13:31hgbotNote Added: 0116167
2019-12-10 13:31hgbotStatusscheduled => resolved
2019-12-10 13:31hgbotResolutionopen => fixed
2019-12-10 13:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f951cac53b1ab3fb423e9b42c7e9d212f067e4ec [^]
2019-12-11 10:04shuehnerSummaryError 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:53alostaleNote Added: 0116177
2019-12-11 10:53alostaleStatusresolved => closed
2019-12-11 10:53alostaleFixed in Version => 3.0PR20Q1

Notes
(0116124)
mauricio_peccorini   
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   
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   
2019-12-11 10:53   
https://gitlab.com/openbravocode/product/openbravo/merge_requests/26 [^]