[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 |
| 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 |