Thu, 09 Mar 2017 08:59:50 +0100fixed bug 35467: views with several IN or NOT IN clasues fail in PG 3.0PR17Q1
Asier Lostalé <asier.lostale@openbravo.com> [Thu, 09 Mar 2017 08:59:50 +0100] rev 925
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 ].

Thu, 09 Mar 2017 08:56:11 +0100related to bug 35467: added test cases
Asier Lostalé <asier.lostale@openbravo.com> [Thu, 09 Mar 2017 08:56:11 +0100] rev 924
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.

Thu, 09 Mar 2017 08:59:50 +0100fixed bug 29492: views with several IN or NOT IN clasues fail in PG
Asier Lostalé <asier.lostale@openbravo.com> [Thu, 09 Mar 2017 08:59:50 +0100] rev 923
fixed bug 29492: 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 ].

Thu, 09 Mar 2017 08:56:11 +0100related to bug 29492: added test cases
Asier Lostalé <asier.lostale@openbravo.com> [Thu, 09 Mar 2017 08:56:11 +0100] rev 922
related to bug 29492: 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.

Tue, 28 Feb 2017 10:26:34 +0100fixes bug 35370: Partial Index info lost under some circumnstances using Oracle
Carlos Aristu <carlos.aristu@openbravo.com> [Tue, 28 Feb 2017 10:26:34 +0100] rev 921
fixes bug 35370: Partial Index info lost under some circumnstances using Oracle

Partial Index information was not being saved properly in Oracle, after executing update.database having the following changes in the model:

1) A new column
2) A new partial index for the new column
3) Changes in another column of the same table which forces recreation

In this scenario, the partial index information was being overriden after executing the writeColumnCommentStmt method. To fix this problem now we keep the existing column comments at that point and concatenate them with the comments to be added to the new column (if any).

Note that this fix does not affect when there is no recreation because in this case, the partial index comments will be handled with the AddIndexChange model changes.

Mon, 27 Feb 2017 13:55:56 +0100related to issue 35284: apply fix in DbsmTest
Carlos Aristu <carlos.aristu@openbravo.com> [Mon, 27 Feb 2017 13:55:56 +0100] rev 920
related to issue 35284: apply fix in DbsmTest

Fri, 17 Feb 2017 12:28:59 +0100fixed bug 35297: PL with optional constant params is not correctly standardized
Asier Lostalé <asier.lostale@openbravo.com> [Fri, 17 Feb 2017 12:28:59 +0100] rev 919
fixed bug 35297: PL with optional constant params is not correctly standardized

The standardization tranforms slect in a function call, the number of different
expressions should be function of the number of optional paramters, but it was
considering optional paramters only in case the default value was either null
or a function, but not a constant.

Fri, 17 Feb 2017 12:26:20 +0100fixed bug 35296: pl with out and defaults params is slow to standardize
Asier Lostalé <asier.lostale@openbravo.com> [Fri, 17 Feb 2017 12:26:20 +0100] rev 918
fixed bug 35296: pl with out and defaults params is slow to standardize

Applying the regexp to do these transformations is very slow in case of many
paramters and non matching pattern.

Fixed by preventing it to be applied in case the number of parameters in the
evaluated string doesn't match with the number defined in the pattern.

Fri, 17 Feb 2017 12:23:04 +0100related to issue 35296: added missing license and reformat
Asier Lostalé <asier.lostale@openbravo.com> [Fri, 17 Feb 2017 12:23:04 +0100] rev 917
related to issue 35296: added missing license and reformat

Thu, 16 Feb 2017 14:24:08 +0100fixed issue 35284: update.database unnecessarily standardizes DB PL code
Asier Lostalé <asier.lostale@openbravo.com> [Thu, 16 Feb 2017 14:24:08 +0100] rev 916
fixed issue 35284: update.database unnecessarily standardizes DB PL code

Do not standardize PL when updating db as it's not used.