Add PostgreSQL pl/pgSQL implementation of “NVL” function.
The initial idea of replacing “NVL” with “Coalesce” is drop after it cause compatibility problem with Oracle (inconsistent datatype error for Coalesce(<nvarchar column>,<string literal>)).
The change from NVL to COALESCE affected badly our oracle installation.
Log into System client on https://test-oracle.idempiere.org/webui/
Open window Dashboard Preference
search shows 6 records - but all the fields are empty
The log shows 13 errors like:
Practically all windows are broken.
I think about two possible fixes:
1 - Revert the java part of this commit to restore back using NVL for oracle.
2 - implement the changes on to change all NVARCHAR columns (3395 columns in core seed, this is a big change and still any implementation will need to fix all their custom tables using NVARCHAR
I think better go for option 1.
Hi , yes, needs to goes back to nvl. If you have time, you can goes ahead to revert that, otherwise I will do it early next week.
Ready, committed the partial revert.
In theory, because of - this would not be required anymore - but anyways is harmless to have the NVL function.