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

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.3
    • 10.0.6
    • None
    • 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

            serg Sergei Golubchik
            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.