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

Duplicate column error on 11.4.11

    XMLWordPrintable

Details

    Description

      After upgrade from 11.4.10 to 11.4.11 (Win64, 11.4.11-MariaDB) some selects with UNION ALL produces duplicate columns.
      For example 

      SELECT
      		 
      f.*
      		 
      ,k.pl_v
      		 
      FROM
      		 
      pl f
      		 
      left JOIN rt_pl k ON (f.pl_id = k.pl_id)
      		 
      UNION ALL
      		 
      SELECT
      		 
      f.*
      		 
      ,Nullif(0,0) pl_v
      		 
      FROM
      		 
      pl f

      I had to get back to 11.4.10.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38799 Some views are broken in Oracle mode after upgrade to Q1 2026

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

          Activity

            People

              serg Sergei Golubchik
              balta Tadas Balaišis
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.