Skip to content

Bug when cleaning up triggers on tables with archived names > 64 characters #174

@jmccormick11

Description

@jmccormick11

When running a cleanup of the current run, if the associated table name is too long the generated query to show the triggers to delete is not picking up any triggers and not cleaning them up.

This is because the query to find the triggers is doing a

show triggers like '%long_table_name%'

But when the archive table is too long the table name looks more like: lhma_TIMESTAMP_long_tab and this causes no triggers to be found because the full origin table name isn't present

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions