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

DDL for creation of a new table in columnstore produces syntax error when it runs on columnstore

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.6
    • 1.1.7
    • None
    • None
    • 2018-17, 2018-18, 2018-19, 2018-20, 2018-21

    Description

      1. Create a new table in TX:

      CREATE TABLE `test` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `col` varchar(100) DEFAULT NULL,
        UNIQUE KEY `id` (`id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
      

      2. Run
      mxs_adapter -c /etc/Columnstore.xml -u cdcuser -p cdcpassword -h localhost -P 4001 cdc_eli test

      Result:
      Table was not found in Columnstore. A DDL statement is suggested to create a respective table in Columnstore. The DDL contains syntax error:

      CREATE TABLE cdc_eli.test (col varchar(100), domain int, event_number int, event_type varchar(50), id serial, sequence int, server_id int, timestamp int) ENGINE=ColumnStore;
      

      Error is:
      Error Code: 1069. Too many keys specified; max 0 keys allowed

      Problem is in id serial. Columnstore doesn't support this.

      Attachments

        Activity

          People

            winstone Zdravelina Sokolovska (Inactive)
            elena.kotsinova Elena Kotsinova (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.