search

webyog / sqlyog-community

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.
https://webyog.com/
GNU General Public License v2.0
2.16k stars 318 forks source link

Incorrect SQL generated in 'Table Data' #2335

Closed sibwy closed 7 months ago

sibwy commented 7 months ago

Server affected:

  1. MySQL v8.0.35 and below
  2. MariaDB 11.1.2 and below

Steps to reproduce:

  1. Create the following table,

    CREATE TABLE `test`.`t1` (
`id` INT NOT NULL,
`value` VARCHAR (10) NOT NULL,
PRIMARY KEY (`id`)
);

  2. In the 'Table Data' tab, enter the respective values for the column 'id' and 'values' as "1" and "default".

  3. clicking on the 'Data modified but not saved' link at the bottom right of the 'Table Data' tab displays an incorrect SQL generated by SQLyog.

The user report can be found in SF >> 01024593

sibwy commented 7 months ago

This can be resolved by having the '"smart" KEYWORDS/FUNCTIONS/DEFAULTS handling' checkbox unchecked under the menu "Tools -> Preferences -> Others"