#14166: Sql server-2014 : Execution plan not displayed in result set and Throws "NPE" in view log After clicking on Execute Explain icon.

nileshhmali reported 2016-01-11T10:24:25Z · niraj.pandey(*) last modified 2016-02-02T08:54:52Z

Sql server-2014 : Execution plan not displayed in result set and Throws "NPE" in view log After clicking on Execute Explain icon.

Dev	tomconrad
QA	ivangron

Priority	Low
Complexity	Unknown

Component	Q Analyzer
Version	16.0

Product: Aqua Data Studio

Version: 17.0.0-ga-23

Build #: 48147

Build Date: 2016-Jan-10 04:53:35 PM

Operating Environment: Linux (3.19.0-15-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_40-b26

Memory: Max=704,643,072; Total=656,408,576; Free=400,282,328; CPUs=8

Connect Ms-sql server-2014

Execute sql script on query analyzer.

CREATE TABLE [dbo].[Employee] (

[E_id] float NULL,

[Fname] varchar(255) NULL,

[City] varchar(255) NULL,

[Salary] float NULL,

[Age] float NULL,

[Joining_p_date] datetime NULL,

[Project_date_time] datetime NULL

)

GO

CREATE PROCEDURE [dbo].[uspGetAddress] @City nvarchar(30)

AS

SELECT *

FROM dbo.Employee

WHERE City = @City

GO

Expand database node

Expand Stored procedure node.

Right click Created SP([uspGetAddress]) and select Script object to window as->EXECUTE option.

Execute script generated on Query analyzer.

declare @City nvarchar(60)

set @City = '-'

EXECUTE [dbo].[uspGetAddress] @City

print '@City: ' + @City

GO

Click on Execute Explain icon.

Actual result:

Here,you can see that,Execution plan not displayed in result set and Throws "NPE" in view log.

Expected Result:

Execution plan should display the result.

Observation:

1)When we have executed above scenario on Table and user defined function objects.

We can see that,Execution plan display the result .

2)We have executed above scenario in postgreSQL-9.4 and Sybase ASE-16.0,

We can see that,Execution plan display the result .

3)Broken build info:

ADS-16.0.0-beta-28.

In ADS-16.0.0-beta-26,Execution plan is displayed in result set.

Check view:

java.lang.NullPointerException

at \\.\\.\\हिñçêČάй語简�?한\\.Kꂥꃈ᛭ꎐ.V(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.Yꎘꌒ̹ꉌfloatshort.getValueAt(Unknown Source)

at com.jidesoft.grid.TreeTableModel.getValueAt(Unknown Source)

at javax.swing.JTable.getValueAt(JTable.java:2717)

at com.jidesoft.grid.JideTable.getValueAt(Unknown Source)

at com.jidesoft.grid.CellSpanTable.getValueAt(Unknown Source)

at com.jidesoft.grid.JideTable.prepareRenderer(Unknown Source)

at com.jidesoft.grid.CellStyleTable.prepareRenderer(Unknown Source)

at com.jidesoft.plaf.basic.BasicJideTableUIDelegate.paintCell(Unknown Source)

at com.jidesoft.plaf.basic.BasicJideTableUIDelegate.a(Unknown Source)

at com.jidesoft.plaf.basic.BasicJideTableUIDelegate.paint(Unknown Source)

at com.jidesoft.plaf.basic.BasicCellSpanTableUIDelegate.paint(Unknown Source)

at com.jidesoft.plaf.basic.BasicCellSpanTableUI.paint(Unknown Source)

at javax.swing.plaf.ComponentUI.update(ComponentUI.java:161)

at javax.swing.JComponent.paintComponent(JComponent.java:780)

at com.jidesoft.grid.CellStyleTable.paintComponent(Unknown Source)

at javax.swing.JComponent.paint(JComponent.java:1056)

at javax.swing.JComponent.paintChildren(JComponent.java:889)