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

Bug found in SQL Prompt

Here are the repro steps.
In a query window that has AdventureWorks2012 as the active DB (probably works in other AW versions too), paste the following code: 
SELECT sod.SalesOrderID,
      (SELECT soh.OrderDate
       FROM Sales.SalesOrderHeader AS soh
       WHERE soh.SalesOrderNumber = 'SO' + CAST(sod.SalesOrderID AS varchar(10))
       GROUP BY)
FROM Sales.SalesOrderDetail AS sod
WHERE sod.OrderQty = 12;
Position the cursor directly after BY, before the closing parenthesis. Type a single space; this should bring up a list of auto-complete options. The first one is "All non-aggregated columns" (an option which I absolutely love, BTW, except in this specific case). Select it.
It should enter "soh.OrderDate" at the cursor position. Instead, it REPLACES the entire subquery with "soh.OrderDate".

Tried several times, reproduces consistently. SSMS 17.3, SQL Prompt 8.2.5.2924.
HugoKornelis
0

Comments

3 comments

Sort by
  • way0utwest
    Reproduced in 8.8.8.2657 as well. I'll report this.
    way0utwest
    0
  • Tianjiao_Li
    Hi @HugoKornelis

    Thanks for reporting it! We have reproduced the issue in Prompt 9.0.0.3116 as well. It's logged as a bug now and please keep an eye on the release note!
    Tianjiao_Li
    0
  • FabiolaB
    Hello @HugoKornelis

    This issue should be fixed in our latest version of SQL Prompt 9.0.3.3299 (installer here).

    You can find more information about this release in this forum post.

    Kind regards,
    Fabiola
    FabiolaB
    0

Add comment

Please sign in to leave a comment.