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

@@optimizer_switch = 'join_cache_hashed=off' changes answer of query

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.10
    • None
    • Optimizer
    • None

    Description

      mysql aria@127.0.0.1:bi-test (;)> set @@optimizer_switch='join_cache_hashed=off';
      Query OK, 0 rows affected (0.017 sec)
       
      mysql aria@127.0.0.1:bi-test (;)> select count(*) from v_thirdparty_reflektion_categories where description is not null;
      +----------+
      | count(*) |
      +----------+
      |      217 |
      +----------+
      1 row in set (0.087 sec)
       
      mysql aria@127.0.0.1:bi-test (;)> set @@optimizer_switch='join_cache_hashed=on';
      Query OK, 0 rows affected (0.016 sec)
       
      mysql aria@127.0.0.1:bi-test (;)> select count(*) from v_thirdparty_reflektion_categories where description is not null;
      +----------+
      | count(*) |
      +----------+
      |        1 |
      +----------+
      1 row in set (0.075 sec)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            aredridel Aria Stewart
            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.