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

The supertype check in virtual column substitution is too strict

    XMLWordPrintable

Details

    • Q3/2026 Server Maintenance

    Description

      If we apply the supertype check in the current MDEV-38752 patch to WHERE substitution, the optimization will stop working on some cases enabled by the 11.8 feature MDEV-35616.

      see https://jira.mariadb.org/browse/MDEV-38752?focusedCommentId=329327&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-329327 and https://jira.mariadb.org/browse/MDEV-38752?focusedCommentId=329407&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-329407

      This means:

      • MDEV-39525 should be fixed in a different way from the current MDEV-38752 patch
      • If the current MDEV-38752 patch is adopted for ORDER/GROUP BY substitutions, the MDEV-39525 fix should be applied to these substitutions as well if possible, to improve the fix.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38752 Wrong result upon GROUP BY on a table with indexed virtual column after INSERT IGNORE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          split from

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38752 Wrong result upon GROUP BY on a table with indexed virtual column after INSERT IGNORE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              ycp Yuchen Pei
              ycp Yuchen Pei
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.