HDMF gave us the sample SQL that they run during the alter table on ropa_purchase.\nAlthough we are getting sequence problem and minor error due to update part.\n\nSee actual test result below:\n\nINGRES TERMINAL MONITOR Copyright 2019 Actian Corporation\nIngres Linux Version II 11.1.0 (a64.lnx/100) login\nMon Apr 11 15:42:41 2022\nEnter \\g to execute commands, "help help\\g" for general help,\n"help tm\\g" for terminal monitor help, \\q to quit\n\ncontinue\n* * /* SQL Startup File */\nalter table ropa_purchase add column fp_date date\nExecuting . . .\n\ncontinue\n* * * * *\ncreate table purchase_fpdate as\nselect  a.purchase_id , a.ropa_id, b.pfrdate from ropa_purchase a LEFT JOIN ropa_payment b ON a.ropa_id = b.ropa_id\nwhere a.paymode = 1 and a.stat_cd NOT IN (3,4,5) and a.fp_date IS NULL and b.pay_type = 19\nExecuting . . .\n\n(3550 rows)\ncontinue\n* * * * * *\nupdate ropa_purchase as rp\nfrom purchase_fpdate as pf\nset rp.fp_date = pf.pfrdate\nwhere rp.purchase_id = pf.purchase_id\nExecuting . . .\n\nE_US125D Ambiguous replace: you have specified several replacements for\n    the same row.\n    (Mon Apr 11 15:42:42 2022)\n\ncontinue\n* * *\nDROP TABLE purchase_fpdate;\nExecuting . . .\n\ncontinue\n* * *\nYour SQL statement(s) have been committed.\n\nIngres Version II 11.1.0 (a64.lnx/100) logout\n