Cross Apply blocks "Tab to expand wildcard"

PawJPawJ Posts: 13 Bronze 1
edited January 28, 2025 8:38AM in SQL Prompt
Promt Version: 10.16.3.14709

We have this very simple code, were we cannot use the Tab to expand wildcard
Code Example:
SELECT *
FROM [sys].[indexes] [i]
	JOIN [sys].[stats] [s] ON [s].[object_id] = [i].[object_id] AND [s].[stats_id] = [i].[index_id]
	CROSS APPLY [sys].dm_db_stats_properties ([s].[object_id], [s].[stats_id]) [sp]
WHERE [i].[object_id] > 999

When we put the cursor at the wildcard, we get the following suggestion ???:



If we move the mouse over, we see all the columns as expected!:



If we do an INTO #d for a temp table and hover over it, we get the following:



If we comment out the cross apply it seems to work:




Any ideer what we are doing wrong or is there a small bug ??
Sign In or Register to comment.