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

Attempt to create a table without columns produces ER_ILLEGAL_HA instead of ER_TABLE_MUST_HAVE_COLUMNS

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.3
    • Fix Version/s: 10.0.6
    • Component/s: None
    • Labels:
      None

      Description

      Starting from 10.0.2, an attempt to create a table with some more or less traditional engine and without columns produces ER_ILLEGAL_HA ("engine doesn't have this option") instead of ER_TABLE_MUST_HAVE_COLUMNS ("table must have at least 1 column"), as it did before.

      MariaDB [test]> create table t1 ;
      ERROR 1031 (HY000): Storage engine InnoDB of the table `test`.`t1` doesn't have this option

      I suppose it has something to do with table discovery, but the older message seemed to be more helpful, it would be good to preserve it when appropriate, if possible.

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.