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(EOL), 10.3(EOL), 10.4(EOL), 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. errorLog.txt
          99 kB
        2. error.sql
          0.5 kB

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17653 replace into generated columns is unstable

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17986 crash when I insert on a table

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19788 Interplay between function based default and lock tables

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20380 Server crash during update

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25672 table alias from previous statement interferes later commands

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25794 vcol_info refix during lock_tables() leads to memory leak until table flush

          • Major - Major loss of function.
          • Open

          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.