Visual Query Builder Bug

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Sandy
Posts: 53
Joined: Fri 07 Feb 2014 18:11

Visual Query Builder Bug

Post by Sandy » Fri 27 Oct 2017 22:02

When trying to use a table name like `trim` the query builder doesn't seems to escape the table name. So it's not possible to use the Visual Query Builder tool with table names like `trim`

If you try to select/check any fields from the displayed list from the `trim` table you get an error message.

If you view the SQL that's trying to be generated it's text stops at the `trim` name (without tick marks).

Might just need to internally escape reserved names in the visual query builder.

I have a screen shot of that helps as well (not sure if possible to attach).
Sandy
Running dbForge Professional version 7.2.78

alexa

Re: Visual Query Builder Bug

Post by alexa » Mon 30 Oct 2017 11:34

We will fix this issue in one of the next product versions and will notify you once it's available for downloading.

Sandy
Posts: 53
Joined: Fri 07 Feb 2014 18:11

Re: Visual Query Builder Bug

Post by Sandy » Tue 31 Oct 2017 22:46

Thanks!

Post Reply