Cannot use column named "key" in generated column expression - results in error

Application ID


Actual Behavior


Expression for generated column “test” is not valid.

Reproducible Test Case

  • Create a table with a string column named “key”
  • Start creating a new column, set as generated string, where expression contains “key”
  • Click create → error

Hi @Nathan_Cousins ,

You receive this error because key is reserved keyword in MySQL. You should quote your column name with “`” symbols. Could you please try this approach and write back about result?

Regards, Andriy

Thanks for the quick response!

That’s understandable, surrounding key with `` did the trick