Visual Query Builder is buggy with INNER JOIN

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
mrcat
Posts: 7
Joined: Fri 16 Jul 2021 08:29

Visual Query Builder is buggy with INNER JOIN

Post by mrcat » Fri 16 Jul 2021 08:34

1) Create a New Query
2) Select "Text" and copy this SQL code:

SELECT
table1.*, table2.*, table3.*
FROM
table1
Inner Join table2
Inner Join table3 ON
table2.id2 = table3.id3 ON table1.id1 = table3.id3

3) Select "Query Builder"
4) Select and Move a Table in the graph (for example table1)
5) Select "Text" and observe the code:

SELECT
table1.*, table2.*, table3.*
FROM
dbo.table1
Inner Join dbo.table2
Inner Join dbo.table3 ON
table2.id2 = table3.id3 AND table1.ID1 = table3.id3

The code is wrong and contains AND in place of ON

alexa

Re: Visual Query Builder is buggy with INNER JOIN

Post by alexa » Fri 16 Jul 2021 09:14

Could you please provide us the full name of the product along with its version?

A video or screenshots would be also of help.

You can send the reply straight to our support system at supportATdevartDOTcom.

mrcat
Posts: 7
Joined: Fri 16 Jul 2021 08:29

Re: Visual Query Builder is buggy with INNER JOIN

Post by mrcat » Fri 16 Jul 2021 09:23

OK
I have a video .AVI
but how I can insert a video in this forum?

P.S.: I send you an email with the video.

Here the video

Image
Last edited by mrcat on Fri 16 Jul 2021 10:17, edited 4 times in total.

mrcat
Posts: 7
Joined: Fri 16 Jul 2021 08:29

Re: Visual Query Builder is buggy with INNER JOIN

Post by mrcat » Fri 16 Jul 2021 09:38

The Product is this
=========================
General
=========================
Application: dbForge Studio 2021 for SQL Server
Product: Devart dbForge Studio 2021 for SQL Server
Product Edition: Enterprise
Product Locale: Italian
Assembly: dbforgesql, Version=6.0.470.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Studio for SQL Server\dbforgesql.exe
Global cache: False
Framework: 4.7.2 or later

alexa

Re: Visual Query Builder is buggy with INNER JOIN

Post by alexa » Fri 16 Jul 2021 10:42

Thank you for the reply.

We were able to reproduce this issue and will fix it in one of the next product builds.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: Visual Query Builder is buggy with INNER JOIN

Post by dzhanhira » Fri 10 Sep 2021 14:59

Thank you for your patience!
We would like to kindly inform you that we have released a new version of the tool. This version includes a lot of fixes.
You can upgrade to the new version within the app, just look on the bar on top for "Help->Check for updates".

mrcat
Posts: 7
Joined: Fri 16 Jul 2021 08:29

Re: Visual Query Builder is buggy with INNER JOIN

Post by mrcat » Thu 16 Sep 2021 11:43

Thanks I see that query builder dont'have this bug now
... but graphically it shows incorrectly only one inner join (and not two)

However I have an other problem, try this:

SELECT
table1.*
,table2.*
,table3.*
FROM dbo.table1
INNER JOIN dbo.table2
INNER JOIN dbo.table3
ON table2.id2 = table3.id3
ON table1.ID1 = table3.id3
UNION ALL
SELECT
table1.*
,table2.*
,table3.*
FROM dbo.table1
INNER JOIN dbo.table2
INNER JOIN dbo.table3
ON table2.id2 = table3.id3
ON table1.ID1 = table3.id3

I receive thes error message: "It is impossible to open Query Builder because either a query text is invalid, or the functionality of the edition you use is limited.
Do you want to continue editing the latest correct query?
"

I'm using Enterprise Edition (trial) and this is only a simple UNION ALL of the same two queries !!!
I suggest you to correct this problem showing the two queries separately in the query builder and asking to the user what of the two query to edit!

alexa

Re: Visual Query Builder is buggy with INNER JOIN

Post by alexa » Thu 16 Sep 2021 12:57

UNION is not supported in dbForge. Though, you can vote for the following suggestion on the UserVoice forum
Query Builder Union Support

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.

mrcat
Posts: 7
Joined: Fri 16 Jul 2021 08:29

Re: Visual Query Builder is buggy with INNER JOIN

Post by mrcat » Thu 16 Sep 2021 14:24

Hi Alexa,
I think this is a wrong approach to see the problem!

This is not a feature that needs to be rated, rather it is a bug to be fixed, because the UNION is a reserved word of the SQL syntax that needs to be implemented.

https://www.w3schools.com/sql/sql_ref_keywords.asp

If the visual query builder doesn't implement the UNION ... then it is wrong, it contains a bug!


P.S.: About the original bug... " graphically it shows incorrectly only one inner join (and not two)"

alexa

Re: Visual Query Builder is buggy with INNER JOIN

Post by alexa » Fri 17 Sep 2021 09:13

Thank you for the reply.

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

Post Reply