Hi There,
I want to create a table with computed column.
I wish to use current_date as value in one of my columns named ‘l_date’
but I am getting error. Here is my DDL:
create table comp_col(
id varchar(10),
name varchar(10),
l_date as current_date PERSISTED timestamp
);
ERROR:
ERROR 1825 ER_MEMSQL_COMPUTED_IS_TIMESTAMP: Cannot create computed column ‘l_date’ of type TIMESTAMP
Looking forward to hear from you.
Thanks,
Vishwajeet