Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26311

Fulltext searches on ARIA tables don't respect max_statement_time

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.3
    • None
    • Full-text Search
    • None

    Description

      I have a long running fulltext query but limiting the execution time doesn't work on ARIA tables, while it works fine on InnoDB tables.

      Example

      SET STATEMENT max_statement_time=1 FOR SELECT * FROM mytable WHERE MATCH(name) against ('+rareword' IN BOOLEAN MODE);

      Attachments

        Activity

          People

            Unassigned Unassigned
            willamowius Jan Willamowius
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.