Visual Query Builder is buggy with INNER JOIN
Visual Query Builder is buggy with INNER JOIN
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
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
Re: Visual Query Builder is buggy with INNER JOIN
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.
A video or screenshots would be also of help.
You can send the reply straight to our support system at supportATdevartDOTcom.
Re: Visual Query Builder is buggy with INNER JOIN
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
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
Last edited by mrcat on Fri 16 Jul 2021 10:17, edited 4 times in total.
Re: Visual Query Builder is buggy with INNER JOIN
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
=========================
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
Re: Visual Query Builder is buggy with INNER JOIN
Thank you for the reply.
We were able to reproduce this issue and will fix it in one of the next product builds.
We were able to reproduce this issue and will fix it in one of the next product builds.
Re: Visual Query Builder is buggy with INNER JOIN
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".
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".
Re: Visual Query Builder is buggy with INNER JOIN
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!
... 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!
Re: Visual Query Builder is buggy with INNER JOIN
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.
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.
Re: Visual Query Builder is buggy with INNER JOIN
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)"
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)"
Re: Visual Query Builder is buggy with INNER JOIN
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.
We will fix it in one of the next product builds and will notify you once it's available for downloading.