Hi,
I've came across a bug during exporting data to Excel.
Basic info:
Windows 7 64 bit,
SQL Developer Version 4.1.3.20 Build MAIN-20.78,
Java(TM) SE Runtime Environment (build 1.8.0_66-b18)
Java HotSpot(TM) 64-Bit Server VM (build 25.66-b18, mixed mode)
Description:
2 connections to DB (different connections names, same credentials).
2 SQL queries run simultaneously by Run as Statement (longer ones)
After partial results are returned (complete results are bigger ones, with over 100 000 rows) right click on grid and Export as Excel 2003 to 2 different files.
Task Progress shows 2 processes. Firstly Executing Query, then Exporting and count of rows exported.
Bug arises when results of one query is being exported, and then kicks in exporting for second query.
First one finishes immediately, second goes on till the end but resulting file for first query is damaged and for second has 0 length and cannot be removed utils closing results grid in SQL Developer.
Looks like when second export starts during ongoing export of first query first one is being killed and results from second query are written to file of first query. Second file just sits there and waits for data that never will came.
Has anyone noticed similar behavior?