[MDEV-27928] ERROR 1901 (HY000): Function or expression '`UUID_TO_BIN`()' cannot be used in the DEFAULT clause - Jira

Hi,

Supposedly it is possible to run the following:

CREATE TABLE `session` (

  `id` binary(16) NOT NULL DEFAULT (UUID_TO_BIN(UUID(), TRUE)),

  `start_timestamp` timestamp NOT NULL,

  `end_timestamp` timestamp NULL DEFAULT NULL,

  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,

  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  `status` varchar(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

But there's an error saying:

ERROR 1901 (HY000): Function or expression '`UUID_TO_BIN`()' cannot be used in the DEFAULT clause of `id`

And for MariaDB, supposedly all deterministic functions should be supported in the DEFAULT clause, no?

Please help, thanks!

relates to

MDEV-15854 Implement uuid_to_bin, bin_to_uuid and is_uuid functions

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server