$ podman run --rm -d -e MARIADB_USER=bob -e MARIADB_PASSWORD=entry -e MARIADB_DATABASE=uuidtest -e MARIADB_RANDOM_ROOT_PASSWORD=1 --name mariadb-uuid quay.io/mariadb-foundation/mariadb-devel:10.7-mdev-4958-uuid-amd64
|
|
|
$ podman exec -ti mariadb-uuid mariadb -u bob -pentry uuidtest
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 3
|
Server version: 10.7.0-MariaDB-MDEV-4958-uuid mariadb.org binary distribution
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [uuidtest]> create table uuidtest ( id uuid primary key default (uuid()));
|
Query OK, 0 rows affected (0.021 sec)
|
|
MariaDB [uuidtest]> insert into uuidtest values (),(),();
|
Query OK, 3 rows affected (0.004 sec)
|
Records: 3 Duplicates: 0 Warnings: 0
|
|
MariaDB [uuidtest]> select * from uuidtest;
|
+--------------------------------------+
|
| id |
|
+--------------------------------------+
|
| 2ed904c4-16bc-11ec-a724-7e502e50dded |
|
| 2ed90772-16bc-11ec-a724-7e502e50dded |
|
| 2ed90913-16bc-11ec-a724-7e502e50dded |
|
+--------------------------------------+
|
|
MariaDB [uuidtest]> insert into uuidtest values ('2ed904c4-16bc-11ec-a724-7e502e50dded'),('2ed904c4-16bc-11ec-a724-7e502e50dded'),('2ed904c4-16bc-11ec-a724-7e502e50dded');
|
ERROR 1062 (23000): Duplicate entry '2ed904c4-16bc-11ec-a724-7e502e50dded' for key 'PRIMARY'
|