Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.0.9
-
None
-
github.com/mariadb-corporation/mariadb-columnstore-docker.git
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.