Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
CREATE TABLE `test` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`val` INT(11)COMMENT 'abcd' CHECK (`val` = 1 OR `val` IS NULL),
PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
Select the respective table in the 'Object Browser' and click on 'Alter Table'.
This issue is reproducible with MariaDB 10.8.3 (and v10.4 and v10.5 as reported by the user) in SQLyog v13.2.0. The issue is not reproducible if the COMMENT is not passed to the column with the 'CHECK' constraint.
Reproducible test case:
This issue is reproducible with MariaDB 10.8.3 (and v10.4 and v10.5 as reported by the user) in SQLyog v13.2.0. The issue is not reproducible if the COMMENT is not passed to the column with the 'CHECK' constraint.
The user report can be found in SF >> 00979220