4 ms·
Your IDE should be able to complete the columns at that point, so when it comes to typing SELECT employee.name, the IDE knows that name is a column of the EMPLO
by jfim 7y ago
Your IDE should be able to complete the columns at that point, so when it comes to typing SELECT employee.name, the IDE knows that name is a column of the EMPLOYEES table.
This works with IntelliJ and Datagrip, I don't know about other IDEs.
- clhodapp 7y agoIt shouldn't, though, because there is no table bound to that name to draw from at that point. You haven't added a from-list that is actually relevant to the current scope yet.
- jfim 7y agoIt does work as described, with column type information and field suggestions, on IntelliJ 2019.2 and Datagrip 2019.2.
- clhodapp 7y agoI totally believe that it gives the suggestions as you describe, what I'm saying is that in order for it do that, the completion must be making faulty assumptions about the way that scoping works in SQL.