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

Unable to add/alter data with MariaDB v11.1 and above #2336

Open sibwy opened 7 months ago

sibwy commented 7 months ago

With MariaDB v11.1 and above, it is impossible to add/edit the data in the 'Table Data'/'Result' tabs. An empty drop-down is displayed on clicking on the cells and closing the drop-down truncates already existing data in the respective cell.

Also, the string data isn't enclosed inside quotes when exporting the data using "Backup Table(s) As SQL Dump".

Use this sample SQL to reproducible: MariaDB_11.1_issue.sql.zip

The user reports can be found in SF >> 01021644, 01023031, 01106693, 01113068, 01119298

kl3sk commented 6 months ago

I can confirm on 10.6.16

helders commented 1 week ago

Looking forward to a fix to this issue too