Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 11.0.0
    • 11.0.0
    • Optimizer
    • None

    Description

      explain SELECT c_custkey, c_name AS currency2 FROM partsupp LEFT JOIN part ON (
      p_partkey = ps_partkey ) JOIN supplier ON (s_suppkey = ps_suppkey) JOIN lineite
      m ON ( ps_suppkey = l_suppkey ) JOIN orders ON ( l_orderkey = o_orderkey ) JOIN
      customer ON ( o_custkey = c_custkey ) HAVING c_custkey > 150;
      In 11.0 shows the table 'part' which should have been eliminated.
      This also causes a small degradation in performance.

      Attachments

        Issue Links

          Activity

            Some tables where not eliminated when they could have been.
            This was caused because HA_KEYREAD_ONLY is not set anymore for InnoDB
            clustered index and the elimination code was depending on
            field->part_of_key_not_clustered which was not set if HA_KEYREAD_ONLY
            is not present.

            Fixed by moving out field->part_of_key and
            field->part_of_key_not_clustered from under HA_KEYREAD_ONLY (which
            they should never have been part of).

            The fix exposes issues in extended key code, which took a long time to understand and fix.
            The exposed bugs where fixed in another commit

            monty Michael Widenius added a comment - Some tables where not eliminated when they could have been. This was caused because HA_KEYREAD_ONLY is not set anymore for InnoDB clustered index and the elimination code was depending on field->part_of_key_not_clustered which was not set if HA_KEYREAD_ONLY is not present. Fixed by moving out field->part_of_key and field->part_of_key_not_clustered from under HA_KEYREAD_ONLY (which they should never have been part of). The fix exposes issues in extended key code, which took a long time to understand and fix. The exposed bugs where fixed in another commit

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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