Line 501 is missing when exporting results to csv or Excel

[anthonydresser]

• Azure Data Studio Version:
  • Version: 1.27.0 (user setup)
  • Commit: 765c7064d46253d88393e0e1ff78874b6fe8fa64
  • Date: 2021-03-16T21:24:59.168Z
  • VS Code: 1.51.0
  • Electron: 9.4.3
  • Chrome: 83.0.4103.122
  • Node.js: 12.14.1
  • V8: 8.3.110.13-electron.0
  • OS: Windows_NT x64 10.0.19042

Steps to Reproduce:

1. Open new Notebook
2. Create new Code Cell
3. Select Kernel SQL, Connect to a database
4. Enter Statement: WITH x AS (SELECT 1 n UNION ALL SELECT n + 1 FROM x WHERE n < 600) SELECT * FROM x OPTION (MAXRECURSION 1000)
5. Run the cell
6. From the Results Grid, click 'Save as CSV', save the file
7. Open the csv file from the previous step in a text editor, e.g. NotePad++, Visual Studio
8. Line 501 is missing from the file, i.e.
   • 498
   • 499
   • 500
   • !!! This Row Is Missing !!!
   • 502
   • 503