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

Malformed error message for ER_KEY_CONTAINS_PERIOD_FIELDS

Details

    Description

      10.5 f544a712

      		 
      MariaDB [test]> create or replace table t1 (a int, s date, e date, period for p(s,e), primary key(a, s, p without overlaps));
      		 
      ERROR 4170 (HY000): Key `(null)` cannot explicitly include column `s`
      		 
       
      		 
      MariaDB [test]> create or replace table t1 (a int, s date, e date, period for p(s,e), unique(a, s, p without overlaps));
      		 
      ERROR 4170 (HY000): Key `(null)` cannot explicitly include column `s`

      It only populates the name when it is explicitly provided:

      MariaDB [test]> create or replace table t1 (a int, s date, e date, period for p(s,e), unique ind(a, s, p without overlaps));
      		 
      ERROR 4170 (HY000): Key `ind` cannot explicitly include column `s`

      Of course it is not always done for UNIQUE and almost never done for PRIMARY KEY (as an explicit name for primary key is ignored and causes a warning).

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          nikitamalyavin Nikita Malyavin made changes -
          Priority Major [ 3 ] Minor [ 4 ]
          nikitamalyavin Nikita Malyavin made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          nikitamalyavin Nikita Malyavin made changes -
          Assignee Nikita Malyavin [ nikitamalyavin ] Oleksandr Byelkin [ sanja ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          sanja Oleksandr Byelkin made changes -
          Assignee Oleksandr Byelkin [ sanja ] Nikita Malyavin [ nikitamalyavin ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          nikitamalyavin Nikita Malyavin made changes -
          Fix Version/s 10.5.7 [ 25019 ]
          Fix Version/s 10.5 [ 23123 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 108415 ] MariaDB v4 [ 157742 ]

          People

            nikitamalyavin Nikita Malyavin
            elenst Elena Stepanova
            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.