ENUM default is not handled in quotes

Rapid-eraser's profile image Rapid-eraser posted 3 years ago in General Permalink

Hello there, I have a problem with ENUM handing default values. I am on version on MariaDb 10.3.24

Problem occurs in CRATE code tab that is written not enclosed in quotes. In the default column in the cell is the value is not presented in quotes and when you try to edit the value in the pop modal window Expression radio is selected (Custom value should be selected with the corresponding value selected). Also this problem is present when you try to use table copy functionality, default value is not wrapped in quotes in the SQL query producing an error while trying to copy the table

2 attachment(s):
  • Screenshot-2020-10-02-13.31.28
  • Screenshot-2020-10-02-13.31.38

Please login to leave a reply, or register at first.