 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
FR: popup for USING clause |
|
Currently, there's no popup listing the column candidates triggered by the USING clause, meaning that one has to know the possible column names without any hints from SA at all. I know that natural joins (and USING) are frown upon most of the times but they tend to come in handy when hastily constructing queries for investigating data contents, so it would be nice if SA could provide some aid there too.
|
|
Mon Nov 04, 2019 8:34 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Are you referring to a case like
 |
 |
SELECT film.title, film_id -- film_id is not prefixed
FROM film
JOIN film_actor USING (film_id)
WHERE ... |
|
|
Wed Nov 06, 2019 10:03 am |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
|
|
Affirmative.
|
|
Wed Nov 06, 2019 10:35 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
I can whisper that 11.1 is now out, and this is one of the enhancements available in that new version. A formal announcement may come at the end of the week, yet 11.1 is already available for download.
|
|
Tue Nov 26, 2019 2:38 am |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
|
|
This seems to be working to an extent. It works automatically when I try to INNER JOIN two tables that are not actually connected by foreign keys. If it finds common columns it adds them using USING (instead of using ON with the columns and equality).
However, I might want to use USING even if there's a foreign key defined (to eliminate column duplicates, for example). I expected it to show a popup after the keyword USING with the matching columns (similar to that the ON keyword triggers) but nothing happened. Wasn't that the intended behavior here?
|
|
Sat Dec 14, 2019 10:16 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|