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

Period name with more than 32 symbols crashes the server

Details

    Description

      The following query:

      create table t2 (s date, e date, period for `asdf123456789012345678901234567890` (s,e));

      leads to a crash.
      As it is noted in https://github.com/MariaDB/server/pull/2146, this is because the constraint name is limited to 32 symbols, while the column name is up to 64 symbols.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18873 Server crashes in Compare_identifiers::operator or in my_strcasecmp_utf8 upon ADD PERIOD IF NOT EXISTS with empty name

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            nikitamalyavin Nikita Malyavin added a comment -

            Fixed in 10.5+ due https://github.com/MariaDB/server/commit/4eb8e51c269eb9447d3765a6e4deba0dc68dfa37

            nikitamalyavin Nikita Malyavin added a comment - Fixed in 10.5+ due https://github.com/MariaDB/server/commit/4eb8e51c269eb9447d3765a6e4deba0dc68dfa37
            nikitamalyavin Nikita Malyavin added a comment -

            Closing since 10.4 is eol

            nikitamalyavin Nikita Malyavin added a comment - Closing since 10.4 is eol

            People

              nikitamalyavin Nikita Malyavin
              nikitamalyavin Nikita Malyavin
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.