Appears to be
SQL> show version
Oracle SQLDeveloper Command-Line (SQLcl) version: 19.2.0.0
SQL> set history fails
SQL> show history
HISTORY
enabled
blacklist: show,history,connect,set
Show failed statements:(20 statements)
SQL> select 1 form dual;
Error starting at line : 1 in command -
select 1 form dual
Error at Command Line : 1 Column : 15
Error report -
SQL Error: ORA-00923: FROM keyword not found where expected
00923. 00000 - "FROM keyword not found where expected"
*Cause:
*Action:
Elapsed: 00:00:00.387
SQL> history
History:
1 lb help genobjecet
2 lb help genobject
3 cd c:\SQLDev\sqlcl\192-final\sqlcl\lb\rest-demo\v1
4 desc locations
5 info locations
6 info+ locations
7 select * employees;
…
49 select * from regions;
50 select 1 form dual;
SQL>
From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
Sent: Friday, July 12, 2019 10:40 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Another SQLcl quirk
I can't get it to show failed lines:
SQL> set history limit 50 fails
SQL> show history
HISTORY
enabled
blacklist: show,history,connect,set
Do not show failed statements
Max Size: 50
SQL> show version
Oracle SQLDeveloper Command-Line (SQLcl) version: 19.1.0.0
SQL>
This looks like a bug. Will it be fixed in the next release, which is due in a
couple of days?