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.
The 'Expression' field (that contains a Generated column's condition) of the Create/Alter table grid clips the condition. This issue is also reflected in the 'Schema Synchronisation tool'.
Reproducible case (Server used: MySQL v8.0.27):
CREATE TABLE `t1` (
`Id` INT NOT NULL AUTO_INCREMENT,
`MemberId` INT,
`TriggeredAlertId` INT,
`SentAlertID` INT,
`Date` DATE,
`CreatedByID` INT DEFAULT 0,
`CreatedDate` DATETIME DEFAULT CURRENT_TIMESTAMP,
`UpdatedById` INT DEFAULT 0,
`UpdatedDate` DATETIME,
`Active` TINYINT (1) NOT NULL DEFAULT 1,
`Deleted` TINYINT (1) NOT NULL DEFAULT 0,
`Scheduled` TINYINT (1) AS (
(
(`Date` IS NOT NULL)
AND (`SentAlertID` IS NULL)
)
) VIRTUAL COMMENT '((`Date` is not null) and (`SentAlertID` is null))',
PRIMARY KEY (`Id`)
);
The user report can be found in SF 00952763 (check the case comment for the issue desc).
sibwy
commented
1 year ago
The 'Expression' field (that contains a Generated column's condition) of the Create/Alter table grid clips the condition. This issue is also reflected in the 'Schema Synchronisation tool'.
Reproducible case (Server used: MySQL v8.0.27):
The user report can be found in SF 00952763 (check the case comment for the issue desc).