Skip to content

[YDBOcto#948] Remove `REPLACE` function redefinition and make use of Octo's REPLACE function

Ganesh Mahesh requested to merge zylog1O1/YDBOctoVistA:ydbocto948 into master

This change is in preparation for YDBOcto!1523 which makes Octo not allow drop statements on tables and function in octo_seed.sql. The drop statement executed for REPLACE function in _YDBOCTOVISTAF.sql will generate the following error after Octo's changes are merged.

4: # [ERROR]: ERR_INVALID_DROP: Dropping "replace" is disallowed as it is a system object
4: # [ERROR]: ERR_CANNOT_CREATE_FUNCTION: Function "replace(VARCHAR, VARCHAR, VARCHAR)" already exists with same argument types

REPLACE function definition and its M implementation defined in YDBOctoVistA is removed by this change as the needed functionality is provided by Octo. Its usage is tested by TVD003 in the pipeline.

Edited by Ganesh Mahesh

Merge request reports