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

Crash when selecting virtual columns generated using functions with DAYNAME()

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.2, 10.3, 10.2.14, 10.4, 10.5
    • Fix Version/s: 10.2.33, 10.3.24, 10.4.14, 10.5.5
    • Component/s: Virtual Columns
    • Labels:
      None
    • Environment:
      CentOS virtual machine running on XenServer
    • Sprint:
      10.4.0-1

      Description

      Good Afternoon,

      I have encountered a crash on a number of operations after a small amount of time has passed, where that table has a virtual column, where in its expression it uses the JSON_VALUE function, with the JSON value selected by a CONCAT to get '$.'<Current Day Name>. (Please see example).

      Commands crash occurs on:

      • SELECT on table
      • Insert/Update on table
      • DROP TABLE
      • SHOW FULL TABLES FROM <database table is in> WHERE table_type = 'BASE TABLE';

      If I don't use both JSON_VALUE and DAYNAME(), it works fine.

      I have attached my debug machine's error log, showing all the crashes occurred while testing

      Thanks,
      Robert

        Attachments

        1. error.sql
          0.5 kB
          Robert Humphries
        2. errorLog.txt
          99 kB
          Robert Humphries

          Issue Links

            Activity

              People

              Assignee:
              nikitamalyavin Nikita Malyavin
              Reporter:
              rmhumphries Robert Humphries
              Votes:
              3 Vote for this issue
              Watchers:
              12 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.