[MDEV-31914] 11.0.2 exporting of varchar/text fields fails from SQLYog Created: 2023-08-14  Updated: 2023-10-06  Resolved: 2023-10-06

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 11.0.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Abigail Hicks Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

Windows 2019



 Description   

I use SQLyog in conjuction with MariaDB for Windows/IIS work. I've been using 10.9 for nearly a year just fine. I posted another seemingly unrelated issue for the same environment just now.

SQLYog Community has a tool to copy database elements (tables, triggers, etc) to other databases/hosts. I use it regularly in development. Naturally, I assume it's letting MariaDB render the SQL

However, when I try to copy from a server using MariaDB 11.0.2, I get an invalid syntax error, because none of the text-values (varchar, text in my case) are quoted. The same issue arises when I try to dump the database to sql. But I can do this fine from 10.9.

I was able to use HeidiSQL from the same machine to backup my database, which i needed to do before I uninstalled and reinstalled the server to try to address the issue her and the issue in MDEV-31913 (fields have uneditable dropdown textareas)



 Comments   
Comment by Sergei Golubchik [ 2023-09-05 ]

I suspect it's ultimately a SQLyog issue, like "SQLyou works incorrectly with MariaDB 11.0.2".

But could you show an example of this incorrect export? May be we'll be able to figure out what is going wrong and if there's a workaround you could use

Generated at Thu Feb 08 10:27:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.