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

ERROR 1901 (HY000) at line 29: Function or expression ... cannot be used in the GENERATED ALWAYS AS clause of ...

    XMLWordPrintable

Details

    Description

      Customer has a database with tables that have columns defined like this:

        `StartDate` datetime(3) GENERATED ALWAYS AS 
          (json_unquote(json_value(`ObjData`,'$.StartDate'))) STORED,

      Table can be understood if software is updated to higher release, such as 10.11 (tested). Table can be dumped by mariadb-dump at any release.

      However, when the table is imported in any DB 10.5 or higher, you get the following error:

      ERROR 1901 (HY000) at line 29: Function or expression 
      'json_unquote(json_value(`ObjData`,'$.StartDate'))' cannot be used 
      in the GENERATED ALWAYS AS clause of `StartDate

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18156 Assertion `0' failed or `btr_validate_index(index, 0, false)' in row_upd_sec_index_entry or error code 126: Index is corrupted upon DELETE with PAD_CHAR_TO_FULL_LENGTH

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              bar Alexander Barkov
              edward Edward Stoever
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.