When I try to save the data as a CSV file from the notebook, it truncates the results - Githubissues

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

When I try to save the data as a CSV file from the notebook, it truncates the results #24585

Open bernatrm opened 1 year ago

bernatrm commented 1 year ago

Azure Data Studio Version: 1.46.1
OS Version: 10.0.22621

Steps to Reproduce:

Configure Notebook: Max Table Row to 5000000

2.Generate a SQL query with about 30000 rows result

3.Save Result as CSV, and see how it is truncated:

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

bernatrm commented 1 year ago

and It doesn't always save the same number of rows; here's another attempt.

chlafreniere commented 1 year ago

Hi @bernatrm does this same behavior also repro on the query editor -> save results as csv?

bernatrm commented 11 months ago

Yes it does