Customer is receiving these errors while attempting to upgrade their database - this is an in-place upgrade where everything is currently working under version Aurora 13.8 with Babelfish 1.4.0
Some examples of the error are:
-
Errors with numeric >= integer and numeric + integer operators where operator is not unique. Recreate with select 5::numeric >= 5::integer
-
call dbo.u_RecordUserActivity( 'b2c2661c-fed8-4c51-ba2d-1bf577cc1a6e', 136442, 'PaymentImport', 36);
fails when called from Postgres with database "" does not exist
-
f_pa_batch_create fails with “nondeterministic collations are not supported for substring searches Where: PL/tsql function
-
f_pa_batch_create fails with “nondeterministic collations are not supported for substring searches Where: PL/tsql function f_getactionid(sys."varchar") line 6 at assignment PL/tsql function
-u_recordclientactivity(integer,uniqueidentifier,sys."varchar",datetime,integer,sys."varchar") line 7 at assignment SQL statement "call u_recordclientactivity(client_id, user_id, 'Batch - Create', NULL, batch_id, 'Batch')" PL/pgSQL function p_pa_batch_initialize(integer,integer,uniqueidentifier,text,datetime) line 107 at C”