No announcement yet.

Query builder issue (MS SQL Server)

  • Filter
  • Time
  • Show
Clear All
new posts

  • Query builder issue (MS SQL Server)

    Recent trial version of Navicat for SQL Server have issue with query builder with specific MS SQL dialect.

    When you add several tables in joins with aliases (like "Join ... [dbo].xxx as yyy"), query builder adds scheme name "[dbo].[yyy].[field_name" in "select" and "from" sections of query for aliased table name.

    The issue that scheme name "[dbo]." should not be present with aliases - only table alias should be mentioned! Scheme name should be presen when you reference real table name. When you use table alias you should use only alias name without scheme name.

    Please fix this issue - this makes query builder unusable for any none-trivial query.

  • #2
    Hi Deksden,

    Thanks for reporting this issue to us. We are able to identify the problem and our development team is trying to fix it. We sincerely hope the next version will be published together with the bug-fixing. We will contact you if any news.