Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

ENUM default is not handled in quotes

Rapid-eraser's profile image Rapid-eraser posted 4 weeks ago in General Permalink

Hello there, I have a problem with ENUM handing default values. I am on version 11.0.0.6096 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.