auto incremente ?

[Coustillas Pierre-Adrien]

Hi,

is that auto_increment are possible ?

MariaDB [mcs]> CREATE TABLE `test_numauto` (   `num_auto` int(11) NOT NULL AUTO_INCREMENT,   `id_unique` int(11) NOT NULL ) ENGINE=columnstore;
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

MariaDB [mcs]> CREATE TABLE `test_numauto` (   `num_auto` int(11) NOT NULL AUTO_INCREMENT,   `id_unique` int(11) NOT NULL,PRIMARY KEY (`num_auto`) ) ENGINE=columnstore;
ERROR 1069 (42000): Too many keys specified; max 0 keys allowed


Thnaks


Pierre

[Dipti Joshi]

Yes auto_increment is possible.

The syntax for it is different though.

Please refer to https://mariadb.com/kb/en/mariadb/columnstore-create-table/ for the syntax.

Thanks,

Dipti

--
You received this message because you are subscribed to the Google Groups "MariaDB ColumnStore" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mariadb-columns...@googlegroups.com.
To post to this group, send email to mariadb-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mariadb-columnstore/e2132b19-52e6-4e02-b30c-bf1c78825a7f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Coustillas Pierre-Adrien]

merci :-)