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.57k stars 901 forks source link

star expansion not working anymore #23423

Open Ossy81 opened 1 year ago

Ossy81 commented 1 year ago

Steps to Reproduce:

  1. ctrl+space after an aterics * is not giving me the column names anymore. It worked.

Does this issue occur when all extensions are disabled?: Yes/No

alanrenmsft commented 1 year ago

@aasimkhan30 could you please take a look?

aasimkhan30 commented 1 year ago

@Ossy81 , I have tried it and it works on my end. Can you please confirm if your editor was connected?

Ossy81 commented 1 year ago

my

Strange thing is that it works occasionally.. Is there a way to "hard reset" all settings etc? Or is a clean install needed?

aasimkhan30 commented 1 year ago

@cheenamalhotra, do you think the editor dropped the connection, which might cause the expansion to fail somehow?

aasimkhan30 commented 1 year ago

@Ossy81 , I don't think it has anything to do with settings in ads.

cheenamalhotra commented 1 year ago

@cheenamalhotra, do you think the editor dropped the connection, which might cause the expansion to fail somehow?

I'm not sure what might be contributing here without looking into logs.

@Ossy81 Can you try with the latest insiders build and gather logs? Please let us know if you experience the issue again, with logs attached.

github-actions[bot] commented 1 year ago

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.

  1. First open the Settings page, find the Mssql: Tracing Level setting and change that to All then restart Azure Data Studio.
  2. Open command palette (Click View -> Command Palette) and run the command Developer: Set Log Level... and set the level to Trace.
  3. Run the repro scenarios.
  4. Collect the following logs:

    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.
    • Developer Tools can be closed via Help -> Toggle Developer Tools

    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.
  5. Now you can revert the Log/Tracing levels changes made in step 1 and step 2.
silverl commented 1 year ago

Stopped working in mine as well. Could this have anything to do with CoPilot interference?

cssuh commented 1 year ago

@silverl Are you able to provide logs for us to look into to fix this issue?

busyfritz commented 1 month ago

Just had this issue. Seems the editor needs to be open with a connection for a minute or two before it allows this.

Merganser2 commented 1 month ago

Also bit me. Restarted ADS and it now works again.