Inconsistent Results when Executing Statements in a Loop about azuredatastudio HOT 3 CLOSED

I was unable to reproduce this bug with the script you provided (also on 0.23.6). I did notice, however, that there is a noticeable delay on the result sets data (the header loads immediately) when scrolling. If I scroll quickly and then stop, then the results show after a brief delay, even if I have already viewed them.

from azuredatastudio.

@arinwt That's really odd! I ran this multiple times before submitting this issue, and each time I paused as I scrolled through the list of results and never saw anything show up past the first 3!
I just re-ran the script and now it works as you describe.

For what it's worth, the "actual" script I observed this in I was calling into a sproc multiple times with different sets of parameters and saw only the first few executions return data. I expected results, so ran the process in SSMS and immediately saw the results I was looking for. Went back to SQL OPS and saw the reported behavior, so I created a simple script to illustrate what I was seeing.

from azuredatastudio.

@tlentine I wasn't able to repro this on the latest build with the attached script. I saw similar to @arinwt where there is a small delay to render the result sets when scrolling.

That said, we do have other active bugs related to failed rendering with lots of resultsets, so perhaps we may fix the underlying issue here when we resolve those. Please reactive if you're still hitting this issue. Thanks!

from azuredatastudio.