Toad World® Forums

CROSS APPLY and OUTER APPLY in FROM Clause breaks Toad Insight


#1

ToadInsightAPPLYclauseBug.jpeg

If you write SQL Statement that includes either OUTER APPLY or CROSS APPLY in the FROM clause, as soon as you type that phrase Toad Insight breaks everywhere else in the editor.

For example, if you type this using AdventureWorks database:

SELECT
c.CustomerID
, c.PersonID
, c. – <<<<< Put your cursor here and Toad Insight / Intellisense works.
FROM Sales.Customer c

But as soon as you add an OUTER APPLY:

SELECT
c.CustomerID
, c.PersonID
, c. – <<<<<< Toad Insight / Intellisense stops working

, per. – <<<<< Doesn’t work for the fields from the APPLY statement either
FROM Sales.Customer c
OUTER APPLY (SELECT TOP 1 FROM Person.Person p WHERE p.BusinessEntityID = c.PersonID) per

Darren


#2

Hi Darren,

Tank you very much for your support!

I Create a story TSS-771 for this.

Thanks again.

Kelly