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

After upgrading Mariadb to v10.6.19 a case in a view crashes server

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.6.19
    • 10.5.27
    • Server, Views
    • Docker linux (FROM mariadb:10.6.19)

    Description

      After upgrading Mariadb from v10.6.18 to v10.6.19
      A case in a select clause crashes the whole MariaDb server

      If you need more debug i can give it to you for sure.

      My examples in attachment

      On the failing case, we wrote the case like that

       case
              myfield when 1 then 0
              when null then 0
              else myfield
          end as myalias_
      

      On the successful case we wrote the case like that

       case
           *   when myfield = 1 then 0*
              when null then 0
              else myfield
          end as myalias_
      

      the fact is, this could happened everywhere we used a case keyword ...

      So could you please give us a feedback on this issue ?

      Sorry in advance if you have not put this bug on the right topic

      Best

      David

      Attachments

        1. 2024-09-17_16h43_50-1.png
          2024-09-17_16h43_50-1.png
          55 kB
        2. 2024-09-17_16h47_57.png
          2024-09-17_16h47_57.png
          10 kB
        3. 2024-09-18_08h25_06.png
          2024-09-18_08h25_06.png
          107 kB
        4. 2024-09-18_08h25_53.png
          2024-09-18_08h25_53.png
          6 kB
        5. databaseScheme.sql
          5 kB
        6. query.sql
          0.4 kB

        Issue Links

          Activity

            People

              danblack Daniel Black
              dgagnaire DGA
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.