Bug in SQLCl 20.3
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 8 Nov 2020 15:06:02 -0500
Message-ID: <b19002a4-88df-e1d5-33cb-bb823f8afb26_at_gmail.com>
The "repeat" command cannot be interrupted by Ctrl-C. I wrote a script which loads a CSV file into a table using PyODBC and wanted to see how fast it is. I was repeating "select count(*) from test_tab" 10 times, 60 seconds between the iterations. When my script completed, I tried killing the "repeat" using Ctrl-C, a keyboard interrupt. The "repeat" would not be interrupted and I had to kill it with some more force (Ctrl-Z is a suspend signal, then follow that by kill -9 %1). In 20.2, breaking out of the repeat command would get me out of the SQLCl entirely, back to the OS prompt.
Date: Sun, 8 Nov 2020 15:06:02 -0500
Message-ID: <b19002a4-88df-e1d5-33cb-bb823f8afb26_at_gmail.com>
The "repeat" command cannot be interrupted by Ctrl-C. I wrote a script which loads a CSV file into a table using PyODBC and wanted to see how fast it is. I was repeating "select count(*) from test_tab" 10 times, 60 seconds between the iterations. When my script completed, I tried killing the "repeat" using Ctrl-C, a keyboard interrupt. The "repeat" would not be interrupted and I had to kill it with some more force (Ctrl-Z is a suspend signal, then follow that by kill -9 %1). In 20.2, breaking out of the repeat command would get me out of the SQLCl entirely, back to the OS prompt.
Regards
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Sun Nov 08 2020 - 21:06:02 CET