Bug report: SQL Window

[ScottMattes]

I have a long running query and result grid set to display 200 rows at a time.

The query fills the first 200 rows of the result set and the status line says 'executing (200)', but not 'more', and I click the Break button and the result grid disappears!

I would expect that the results already showing show stay showing.

Thank you.

 

[Marco Kalter]

The results that are already fetched should remain. Is there any error message?

 

[ScottMattes]

just the 'user requested cancel of the yada yada' displayed down on the status bar. But nothing else.

I did have to click the Break key twice because it didn't seem like it recognized the first one.

 

[Marco Kalter]

Maybe Oracle reports that 0 rows are fetched when the first batch of records are being fetched during the cancel. We'll check it out.