Author |
Message |
seth.rothman
Joined: 29 Jan 2008 Posts: 54 Country: United States |
|
SSMS Crash |
|
I can reproduce an issue that causes SSMS to crash when selecting the "recommended" join between a table and a sub-select. For example, when typing the ON in the following SQL statement, SQL Assistant pops up a window with the recommended join fields (in this case "n.Loan_stage_ID = vas.loan_stage_id").
SELECT vas.loan_stage_id, vas.Deal, vas.Closed, n.Num AS Notes
FROM dbo.vwAllStages vas
INNER JOIN
(
SELECT n.Loan_stage_ID, COUNT(*) AS Num
FROM dbo.Notes n
WHERE NoteDate > '20100701'
GROUP BY n.Loan_stage_ID
)
AS n
ON n.Loan_stage_ID = vas.loan_stage_id
When I try to highlight the recommendation and press either TAB or ENTER to select it, it isn't insert as you'd expect. I can successfully, type "n." to the the intellisense to pop up and finish the ON myself. The crash occurs when double-clicking the recommended join. SSMS crashes with:
Description:
Stopped working
Problem signature:
Problem Event Name: APPCRASH
Application Name: Ssms.exe
Application Version: 2009.100.1600.1
Application Timestamp: 4bb679e7
Fault Module Name: SqlAssistPrefs.dll
Fault Module Version: 5.1.10.0
Fault Module Timestamp: 4c717385
Exception Code: c0000005
Exception Offset: 00218c56
OS Version: 6.1.7600.2.0.0.256.1
Locale ID: 1033
|
|
Wed Sep 15, 2010 1:30 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7951
|
|
|
|
Would you please post the DDL for Notes and vwAllStages tables? I hope this DDL will allow us to reproduce and fix the issue.
|
|
Wed Sep 15, 2010 11:00 pm |
|
 |
seth.rothman
Joined: 29 Jan 2008 Posts: 54 Country: United States |
|
|
|
The issue is reproducible on any join with a sub-select regardless of the schema. Pick any table you have and join it to a sub-select of itself and you'll see the problem.
|
|
Fri Sep 17, 2010 2:46 pm |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
5.1.10 Pro
SSMS
I just found this too. I was going to report it. Mine crashed on the double-click of the recommended join. Enter to select the join failed to insert.
I thought it was from instability after a recent Code Snippet edit, but perhaps not.
|
|
Fri Sep 17, 2010 5:30 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7951
|
|
|
|
Thank you. I was able to reproduce this problem and logged a bug report.
Issue tracking # SA11504
|
|
Fri Sep 17, 2010 7:10 pm |
|
 |
|