Select Top 1000

[nathangmahler1987]

Issue Type: Bug

Steps to Reproduce:

1. Open Azure Data Studio
2. Connect to database
3. right click on one of the tables in the database
4. select 'SELECT TOP 1000' option
5. sit back and watch nothing happen:) On this and the last version of Azure Data Studio (maybe others too I don't know) the 'SELECT TOP 1000' does nothing. No error message, no nothing. This is a crucial feature please fix promptly

Azure Data Studio version: azuredatastudio 1.39.1 (7553f799e175f471b7590302dd65c997b838b29b, 2022-08-30T01:11:13.047Z) OS version: Windows_NT x64 10.0.19043 Restricted Mode: No

System Info

Item	Value
CPUs	AMD Ryzen 7 PRO 5850U with Radeon Graphics (16 x 1896)
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)	11.83GB (4.97GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions: none

[smartguest]

@nathangmahler1987 Issue currently does not reproduce on our side via a local database, can you please describe the server database configuration you are using along with the type of the database? Also, can you try and create a simple database with integer numbers to see if that works?

[nathangmahler1987]

I am not sure. I work for a medium organization and we are connecting to Azure. Wouldn’t our configuration be set by IT or those that set the DB up?

On Tue, Sep 6, 2022 at 4:13 PM Alex Ma @.***> wrote:

Issue currently does not reproduce on our side via a local database, can you please describe the server database configuration you are using?

— Reply to this email directly, view it on GitHub https://github.com/microsoft/azuredatastudio/issues/20551#issuecomment-1238704839, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARQ36C2EE6RWKMPLJSV6LFDV466Y3ANCNFSM6AAAAAAQGHEERY . You are receiving this because you authored the thread.Message ID: @.***>

[smartguest]

@nathangmahler1987

That is correct, they should know what the database type/configuration is.

This issue appears to be similar to this previously submitted issue: https://github.com/microsoft/azuredatastudio/issues/20241

Ask your IT department or those who set the DB up if they are using Azure Synapse or not, we currently have an issue where Select Top 1000 does not work for those kinds of Databases, we want to make sure that this is the same problem you are seeing.

I am not sure. I work for a medium organization and we are connecting to Azure. Wouldn’t our configuration be set by IT or those that set the DB up? … On Tue, Sep 6, 2022 at 4:13 PM Alex Ma @.> wrote: Issue currently does not reproduce on our side via a local database, can you please describe the server database configuration you are using? — Reply to this email directly, view it on GitHub <#20551 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARQ36C2EE6RWKMPLJSV6LFDV466Y3ANCNFSM6AAAAAAQGHEERY . You are receiving this because you authored the thread.Message ID: @.>

[smartguest]

Closing as duplicate

[github-actions[bot]]

We need more info to debug your particular issue. If you could attach your logs to the issue (ensure no private data is in them), it would help us fix the issue much faster. First open the Settings page, find the Mssql: Tracing Level setting and change that to All then restart ADS and repro your issue. Next there are two types of logs to collect:

Console Logs

• Open Developer Tools (Help -> Toggle Developer Tools)
• Click the Console tab
• Click in the log area and select all text (CTRL+A)
• Save this text into a file named console.log and attach it to this issue.

Application Logs

• Open command palette (Click View -> Command Palette)
• Run the command: Developer: Open Logs Folder
• This will open the log folder locally. Please zip up this folder and attach it to the issue.

[alanrenmsft]

@nathangmahler1987 please try it again when the new version is available in a month or so.

[nathangmahler1987]

Thanks!

On Fri, Oct 14, 2022 at 8:50 PM Alan Ren @.***> wrote:

@nathangmahler1987 https://github.com/nathangmahler1987 please try it again when the new version is available in a month or so.

— Reply to this email directly, view it on GitHub https://github.com/microsoft/azuredatastudio/issues/20551#issuecomment-1279640931, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARQ36C2G4F6YBAAUMP2HJQLWDILW3ANCNFSM6AAAAAAQGHEERY . You are receiving this because you were mentioned.Message ID: @.***>