Open YajunJohnsonTR opened 1 month ago
YajunJohnsonTR
commented
1 month ago maybe I am not doing this right. even compare 2 identical dump files still getting errors java -jar apgdiff-2.4.jar wfilingsmetadoc0_1.sql wfilingsmetadoc0_1.sql Exception in thread "main" java.lang.RuntimeException: Cannot find ending semicolon of statement: CREATE FUNCTION wfilingsmetadoc0."sidetab_del_t$cms_content"() RETURNS trigger
fordfrog
commented
1 month ago @YajunJohnsonTR i suggest you first try the latest apgdiff.
YajunJohnsonTR
commented
1 month ago I think I amusing the lastest 2.4
https://www.apgdiff.com/download.php
Yajun Johnson Lead DBA Thomson Reuters Legal @.***
From: Miroslav Šulc @.> Sent: Thursday, July 11, 2024 11:10 AM To: fordfrog/apgdiff @.> Cc: Johnson, Yajun (TR Technology) @.>; Mention @.> Subject: [EXT] Re: [fordfrog/apgdiff] apgdiff2.4 is not working for me (Issue #298)
External Email: Use caution with links and attachments.
@YajunJohnsonTRhttps://urldefense.com/v3/__https:/github.com/YajunJohnsonTR__;!!GFN0sa3rsbfR8OLyAw!el1-JMTakBBidrluq5HE50UvITtL4wO_02wHU-KMmNnIp2qmIlEkkI7kgIVTRmG6Vt_FKSlp57ckF-q06nm2cCtZYoc_IGH2JA$ i suggest you first try the latest apgdiff.
— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/fordfrog/apgdiff/issues/298*issuecomment-2223337222__;Iw!!GFN0sa3rsbfR8OLyAw!el1-JMTakBBidrluq5HE50UvITtL4wO_02wHU-KMmNnIp2qmIlEkkI7kgIVTRmG6Vt_FKSlp57ckF-q06nm2cCtZYocWo3yW5Q$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/APM4HHVRIAB6M7VPDMZKCPTZL2U6LAVCNFSM6AAAAABKXBJ336VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMRTGMZTOMRSGI__;!!GFN0sa3rsbfR8OLyAw!el1-JMTakBBidrluq5HE50UvITtL4wO_02wHU-KMmNnIp2qmIlEkkI7kgIVTRmG6Vt_FKSlp57ckF-q06nm2cCtZYodavH0C9A$. You are receiving this because you were mentioned.Message ID: @.**@.>>
fordfrog
commented
1 month ago @YajunJohnsonTR you can download 2.7.0 here: https://github.com/fordfrog/apgdiff/tree/develop/releases
YajunJohnsonTR
commented
1 month ago Are we sure @.***
Yajun Johnson Lead DBA Thomson Reuters Legal @.***
From: Miroslav Šulc @.> Sent: Thursday, July 11, 2024 11:58 AM To: fordfrog/apgdiff @.> Cc: Johnson, Yajun (TR Technology) @.>; Mention @.> Subject: [EXT] Re: [fordfrog/apgdiff] apgdiff2.4 is not working for me (Issue #298)
External Email: Use caution with links and attachments.
@YajunJohnsonTRhttps://urldefense.com/v3/__https:/github.com/YajunJohnsonTR__;!!GFN0sa3rsbfR8OLyAw!fiOzn4neYzeCIsqsguhiTgHQ0zsTuFkFEUf2OTjavKBC5zv7KdqeH53vcRCQf4eZMd9-tZMKl6GLHqOfqQrS9dt0XR_2R2dlhw$ you cah download 2.7.0 here: https://github.com/fordfrog/apgdiff/tree/develop/releaseshttps://urldefense.com/v3/__https:/github.com/fordfrog/apgdiff/tree/develop/releases__;!!GFN0sa3rsbfR8OLyAw!fiOzn4neYzeCIsqsguhiTgHQ0zsTuFkFEUf2OTjavKBC5zv7KdqeH53vcRCQf4eZMd9-tZMKl6GLHqOfqQrS9dt0XR_L3WN0bg$
— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/fordfrog/apgdiff/issues/298*issuecomment-2223433767__;Iw!!GFN0sa3rsbfR8OLyAw!fiOzn4neYzeCIsqsguhiTgHQ0zsTuFkFEUf2OTjavKBC5zv7KdqeH53vcRCQf4eZMd9-tZMKl6GLHqOfqQrS9dt0XR9ZlJbxcg$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/APM4HHVO4273FPICM22VLLTZL22SHAVCNFSM6AAAAABKXBJ336VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMRTGQZTGNZWG4__;!!GFN0sa3rsbfR8OLyAw!fiOzn4neYzeCIsqsguhiTgHQ0zsTuFkFEUf2OTjavKBC5zv7KdqeH53vcRCQf4eZMd9-tZMKl6GLHqOfqQrS9dt0XR95plv5UQ$. You are receiving this because you were mentioned.Message ID: @.**@.>>
it does not seem the apgdiff is working for me - the 2 dump files are create I extract the apgdiff2.4 to my folder and run the command from that folder see exception
java -jar apgdiff-2.4.jar wfilingsmetadoc0_1.sql wfilingsmetadoc0_2.sql
EAD+0161935@TR-6RVX4Y3 MINGW64 ~/apgdiff24/apgdiff-2.4 $ java -jar apgdiff-2.4.jar wfilingsmetadoc0_1.sql wfilingsmetadoc0_2.sql Exception in thread "main" java.lang.RuntimeException: Cannot find ending semicolon of statement: CREATE FUNCTION wfilingsmetadoc0."sidetab_del_t$cms_content"() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN DELETE FROM wfilingsmetadoc0.cms_multiple WHERE old.root_id = wfilingsmetadoc0.cms_multiple.root_id; RETURN OLD; END; $$;