Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1577

ColumnStore to allow CREATE TABLE table_name LIKE ... Syntax

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.6
    • 1.2.0
    • None
    • None
    • 2018-15, 2018-16, 2018-17

    Description

      It would be nice if ColumnStore supported the CREATE TABLE table_name LIKE ... syntax.

      For instance, if you try to execute this CREATE TABLE command:

      CREATE TABLE table2 LIKE table1;
      

      It throws the following error:

      The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.
      

      Here is the CREATE TABLE for the existing table, table1:

      CREATE TABLE `table1` (
      `col1` int(10) NOT NULL,
      `col2` varchar(255) DEFAULT NULL,
      `col3` tinyint(127) DEFAULT NULL,
      `col4` tinyint(1) DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8;
      

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            ccalender Chris Calender (Inactive)
            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.