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

Mariadb columnstore autoincrement not working

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.0.9
    • Icebox
    • MariaDB Server
    • None
    • github.com/mariadb-corporation/mariadb-columnstore-docker.gi‌​t
      mariadb-columnstore-1.0.8-1-centos7.x86_64.rpm.tar.gz and
      mariadb-columnstore-1.0.9-1-centos7.x86_64.rpm.tar.gz

    Description

      I'm trying to use Mariadb columnstore, but I'm having some errors when inserting data in a table with a autoincrement column defined.

      The issue happens when using the JDBC driver.

      CREATE TABLE schema.mytable
      (
      deaf_id bigint NOT NULL COMMENT 'autoincrement=1',
      name varchar(80) NOT NULL,
      country varchar(14) NOT NULL
      ) ENGINE=ColumnStore;

      Using DBeaver, I try to insert a new data on the table:

      INSERT INTO schema.mytable (name, country) VALUES('ny', 'usa');

      But I get the following error:

      SQL Error [1364] [HY000]: (conn:4) Field 'deaf_id' doesn't have a default value

      But using the mcsmysql, I can add the data successfully:

      MariaDB [schema]> INSERT INTO schema.mytable (name, country) VALUES('ny', 'usa');
      Query OK, 1 row affected, 1 warning (0.28 sec)

      MariaDB [schema]> select * from schema.mytable;
      --------------------

      deaf_id name country

      --------------------

      1 ny usa

      --------------------
      1 row in set (0.07 sec)

      MariaDB [bovespa]>

      I tried to use the both drivers:

      https://downloads.mariadb.com/Connectors/java/connector-java-2.0.1/mariadb-java-client-2.0.1.jar

      https://downloads.mariadb.com/Connectors/java/connector-java-1.5.9/mariadb-java-client-1.5.9.jar

      The SHOW WARNINGS command returns an EMPTY SET.

      Attachments

        Activity

          People

            Unassigned Unassigned
            kleysonr Kleyson Rios
            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.