How can we help you today? How can we help you today?

Cross Apply blocks "Tab to expand wildcard"

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 ??
PawJ
0

Comments

2 comments

Sort by
  • Josh Head

    I see the same behavior you are describing. It does appear to be a bug. I will get this over to developers to have a look. 

    Josh Head
    0
  • Josh Head

    The developers have identified the bug and are working on a fix. It should likely be included in the next release of SQL Prompt (current version is 10.16.6)

    Josh Head
    0

Add comment

Please sign in to leave a comment.