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 899 forks source link

Incorrect sorting in notebook result #24072

Closed orcawave-dliu closed 1 year ago

orcawave-dliu commented 1 year ago

Type: Bug

Notebook result does not follow the sorting in the sql query

example: I have a table with the following data Name David Susan Kent

if I do select name from table order by name asc The sorting in the result returned in the notebook ignores the sorting in the query

Azure Data Studio version: azuredatastudio 1.45.0 (8eff468100f02157f2219335f7a566d14451ca49, 2023-07-24T18:22:12.106Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|11th Gen Intel(R) Core(TM) i7-1165G7 @ 2.80GHz (8 x 1690)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|15.73GB (1.87GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (14) Extension|Author (truncated)|Version ---|---|--- admin-pack|Mic|0.0.2 admin-tool-ext-win|Mic|0.1.3 agent|Mic|0.49.0 azuredatastudio-mysql|Mic|1.0.0 cms|Mic|0.9.3 dacpac|Mic|1.14.0 import|Mic|1.5.5 managed-instance-dashboard|Mic|0.4.2 profiler|Mic|0.14.0 schema-compare|Mic|1.20.0 sql-database-projects|Mic|1.2.0 whoisactive|Mic|0.1.5 sql-search|Red|0.4.2 simple-data-scripter|sea|0.1.6
Charles-Gagnon commented 1 year ago

@orcawave-dliu Can you include a screenshot of the query + results grid? It seems to work fine for me, so I want to make sure there isn't something going on with your setup that I'm missing

image

cheenamalhotra commented 1 year ago

Rrelated with https://github.com/microsoft/azuredatastudio/issues/24095 ?

Charles-Gagnon commented 1 year ago

Thanks Cheena, forgot about this one. It's likely the same issue so I'm going to close it as dupe/fixed. @orcawave-dliu - if you get a chance to try out the latest insiders build, that has the fix in it. Let us know if you still see the issue after that!