Bug: DEFAULT (CURRENT_TIMESTAMP) in Table Columns with Storage Engine “MEMORY”

[raubv0gel]

Trying

Code: Select all

CREATE TABLE access_protection_test (
	ip_address VARBINARY(16) NOT NULL,
	last_access_time TIMESTAMP NOT NULL DEFAULT (CURRENT_TIMESTAMP) ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (ip_address)
)
ENGINE = MEMORY,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_0900_ai_ci;

throws error “'Specified storage engine' is not supported for default value expressions. SQL1.sql 1 1”. If one omits “DEFAULT (CURRENT_TIMESTAMP)”, it’s working. But whole SQL statement it’s working on phpmyadmin for example.

dbForge Studio 9.0.391
MySQL 8.0.21

Best regards!

[alexa]

We were not able to execute the script in Workbench either.

Could you please provide us the server settings?

You can send the reply straight to our support system at supportATdevartDOTcom.