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

Bug
1

image
image1405×889 82.1 KB

Application ID

532CF1B7-693E-48CA-B1B1-F16FCB709609

Actual Behavior

Error:

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
2

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

3

Thanks for the quick response!

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