search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.56k stars 898 forks source link

Running a Select returns Query Failed : Object reference not set to an instance of an object #20292

Closed peperami97 closed 1 year ago

peperami97 commented 2 years ago

Issue Type: Bug

I have run a simple select statement of the form

select * from table1 e inner join table2 eph on e.field1 = eph.field1 inner join table3 eh on eh.field1 = e.field1 left join table4 el on e.field1 = el.field1

This causes the following message

16:39:52Started executing query at Line 1 (169 rows affected) Total execution time: 00:00:00.157

The results grid is available but contains 166 rows.

When run in managment studio 2018 I get no error message and 169 rows returned.

I have tried restarting azure data studio

Azure Data Studio version: azuredatastudio 1.38.0 (dff93c4736269ef2a7e8a225737a0d8354bf0246, 2022-07-26T23:56:16.217Z) OS version: Windows_NT x64 10.0.19042 Restricted Mode: No

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-8665U CPU @ 1.90GHz (8 x 2112)| |GPU Status|2d_canvas: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
oop_rasterization: enabled
opengl: enabled_on
rasterization: enabled
skia_renderer: enabled_on
video_decode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled| |Load (avg)|undefined| |Memory (System)|31.82GB (13.35GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (13) Extension|Author (truncated)|Version ---|---|--- demo-mode|dre|1.1.0 admin-pack|Mic|0.0.2 admin-tool-ext-win|Mic|0.0.4 agent|Mic|0.48.0 dacpac|Mic|1.10.1 import|Mic|1.5.0 profiler|Mic|0.11.0 query-history|Mic|0.2.1 schema-compare|Mic|1.15.0 schema-visualization|R0t|0.8.2 sql-prompt|Red|0.2.11 simple-data-scripter|sea|0.1.6 vscodeintellicode|Vis|1.2.1 (2 theme extensions excluded)
alanrenmsft commented 2 years ago

@peperami97 could you please share a screenshot of the results grid with it scrolled all the way to the bottom, also include the xxx rows in the status bar.

image

alanrenmsft commented 1 year ago

dupe of #18714