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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.2.14, 10.2, 10.3, 10.4, 10.5
    • 10.2.33, 10.3.24, 10.4.14, 10.5.5
    • Virtual Columns
    • None
    • CentOS virtual machine running on XenServer
    • 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
        2. errorLog.txt
          99 kB

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              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.