Friends,
I am trying to save table with column having primary key of BIGINT datatype with default value to AUTO_INCREMENT and so far it is working fine. But when i try to set the default value to uuid_short() it throws an alert saying: "SQL Error (1366): Incorrect integer value: 'uuid_short()' for column 'id' at row 1".
HeidiSQL runs the following query:
ALTER TABLE hello_world
CHANGE COLUMN id
id
BIGINT(20) NULL DEFAULT 'uuid_short()' FIRST;
Unquoting uuid_short() works:
ALTER TABLE hello_world
CHANGE COLUMN id
id
BIGINT(20) NULL DEFAULT uuid_short() FIRST;
Can you please allow uuid_short() function to work in default?
Or as a new feature, an option to select function can be added along with existing four options:
- No default value
- Custom:
- NULL
- AUTO_INCREMENT
- Function: [NEW] (A list of mariadb functions can be displayed in dropdown for developer to select)
A screenshot is attached for reference.
Thank you.