DBforge crashes using booleans in stored procedures
Posted: Wed 24 Aug 2022 12:04
Hi all,
I'm using Redshift - Postgres databases to compare schema's. DBForge stopped working due to some "boolean" functions (stored procedures) which are giving the error.
How did I found out?
Created two test databases to compare. Everything went fine until I added a specific stored procedure to the database, example:
CREATE OR REPLACE PROCEDURE test_procedure(_var_init bool)
declaring that bool type makes the compare crash (no idea why this is). Seems like DBforge can't handle those booleans like it should. Creating a dummy procedure with a varchar type works fine.
I can reproduce this error and also did it in different schema's and with different functions.
Error message that is created in DBForge:
Comparison failed.
Reason: The given key was not present in the dictionary.
Please help me out with this. Thanks in advance.
With kind regards
I'm using Redshift - Postgres databases to compare schema's. DBForge stopped working due to some "boolean" functions (stored procedures) which are giving the error.
How did I found out?
Created two test databases to compare. Everything went fine until I added a specific stored procedure to the database, example:
CREATE OR REPLACE PROCEDURE test_procedure(_var_init bool)
declaring that bool type makes the compare crash (no idea why this is). Seems like DBforge can't handle those booleans like it should. Creating a dummy procedure with a varchar type works fine.
I can reproduce this error and also did it in different schema's and with different functions.
Error message that is created in DBForge:
Comparison failed.
Reason: The given key was not present in the dictionary.
Please help me out with this. Thanks in advance.
With kind regards