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

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

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

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            		35d 1h 38m 1
            Nikita Malyavin made transition -
            Confirmed In Progress
            		458d 18h 22m 1
            Nikita Malyavin made transition -
            Stalled In Progress
            		288d 40m 2
            Nikita Malyavin made transition -
            In Progress In Review
            		16d 15h 6m 3
            Oleksandr Byelkin made transition -
            In Review Stalled
            		18d 1h 24m 3
            Nikita Malyavin made transition -
            Stalled Closed
            		54m 36s 1

            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.