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
        2. errorLog.txt
          99 kB

          Issue Links

            Activity

              People

              Assignee:
              nikitamalyavin Nikita Malyavin
              Reporter:
              rmhumphries Robert Humphries
              Votes:
              3 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: