SQLcl 20.2 places two blank lines at top of CSV file

Jayson

Hi folks,

I'm finding a strange issue in which SQLcl 20.2 in explicably places two blank lines at the top of any CSV file I create using SET SQLFORMAT CSV / SPOOL myfile.csv.

Here is a simple set of commands that produce the behavior:

SET ECHO OFF

SET SQLFORMAT CSV

SPOOL myfile.csv

SELECT * FROM SOME_TABLE;

EXIT

Using identical commands doesn't do this in SQLcl 18.2 or 17.3.

This is running from the command line on Red Hat Enterprise Linux 7.8.

Am I missing something or doing something wrong without realizing it? Thanks for any help anyone can give.

Erik van Roon

Maybe you're running into this bug:

SQLCL: extra link breaks/blank lines comparing with SQL*PLUS

It's probablg solved in the next version.