MariaDB [test]> create table t1(i int not null, c char(3)) engine=columnstore comment 'autoincrement=i';
|
Query OK, 0 rows affected (0.57 sec)
|
|
MariaDB [test]> insert into t1 (c) values ('ABC');
|
Query OK, 1 row affected, 1 warning (0.33 sec)
|
|
MariaDB [test]> show warnings;
|
+---------+------+----------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------+
|
| Warning | 1364 | Field 'i' doesn't have a default value |
|
+---------+------+----------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> insert into t1 (i,c) values (0, 'ABC');
|
Query OK, 1 row affected (0.27 sec)
|