Notes |
|
(0113735)
|
hgbot
|
2019-07-31 13:20
|
|
Repository: erp/devel/pi
Changeset: 58004f8efa540f17758f4148ea71120eb5e62573
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Jul 31 13:20:31 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/58004f8efa540f17758f4148ea71120eb5e62573 [^]
fixed bug 41460 fixed bug 41366: allow multi col checks, don't upper case check
fixed issue 41460: multi colum FKs are not supported in PG
The query to obtain columns participating in FKs was incorrect in PG as it
assumed FKs have a single column.
As PG catalog stores FK column information as a couple of arrays (one for local
and another one for external column) each of them corresponding each other by
array's position, it is not possible to retrieve all information using a single
query. This has been changed so now column information is retrieved by an additional
query based on array's position.
fixed issue 41366: string literals in check contrains are upper cased
When exporting check constraints in PostgreSQL, they are converted to upper case
in order to keep ORA - PG stability. This conversion was to aggressive as string
literals were also modified.
Now strings are kept while the rest is still transformed.
---
M src-db/database/lib/dbsourcemanager.jar
---
|
|
|
(0113738)
|
hgbot
|
2019-07-31 13:21
|
|
Repository: erp/devel/dbsm-main
Changeset: ea1fbde18d1a250ad6919c46edf189ea89625827
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Jul 30 15:46:31 2019 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/ea1fbde18d1a250ad6919c46edf189ea89625827 [^]
related to issue 41366: added test case
---
M src-test/src/org/openbravo/dbsm/test/model/ModelSuite.java
A src-test/model/constraints/CHK_LOWER_CASE.xml
A src-test/src/org/openbravo/dbsm/test/model/CheckConstraintLowerCase.java
---
|
|
|
(0113739)
|
hgbot
|
2019-07-31 13:21
|
|
Repository: erp/devel/dbsm-main
Changeset: 3517bb63edf9d6b4cbecf841c7c889d6225ee1ad
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Jul 30 15:52:12 2019 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/3517bb63edf9d6b4cbecf841c7c889d6225ee1ad [^]
fixed issue 41366: string literals in check contrains are upper cased
When exporting check constraints in PostgreSQL, they are converted to upper case
in order to keep ORA - PG stability. This conversion was to aggressive as string
literals were also modified.
Now strings are kept while the rest is still transformed.
---
M src/org/apache/ddlutils/model/Check.java
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlCheckTranslation.java
---
|
|
|
(0113772)
|
hgbot
|
2019-08-02 08:59
|
|
|
|
|
|
|
|
|
|
|
|