Devart Forums

Posted: **Wed 30 Sep 2020 07:18**

Trying

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!

Posted: **Wed 30 Sep 2020 16:31**

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.

Devart Forums

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

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

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