Skip to content

Add config to disable execution regular expressions used to parse exec and call statements #2483

@jtduffy

Description

@jtduffy

Description

The regular expression patterns used for attempting to parse exec and call SQL statements are extremely complex. For large query sizes, executing the regex on those statements can take a very long time. A customer had a 48k SQL statement that went through these regexs and it took almost 2 minutes.

We need a new config to disable the running of these patterns. Potential config:

common: &default_settings
  transaction_tracer:

    # For large SQL statements, executing the regular expressions that attempt to parse exec and
    # call statements can take a significant amount of time. Setting this to true will disable the
    # execution of these complex regular expressions.
    # Default is false.
    exec_call_sql_regex_disabled: false

If this is set to true, we would skip the execution of those 2 problem expressions.

DefaultDatabaseStatementParser patterns

GTSE

Metadata

Metadata

Assignees

Labels

2Story Point Estimate

Type

No type

Projects

Status

Code Complete/Done

Relationships

None yet

Development

No branches or pull requests

Issue actions