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

    Details

    • Type: Bug
    • Status: Closed
    • 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.

        Gliffy Diagrams

          Attachments

            Activity

            There are no comments yet on this issue.

              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:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 10 minutes
                  10m