SQLcl 24.3: "liquibase Generate" Command Generates Files With Trailing White Space (Doc ID 3062389.1)

Last updated on DECEMBER 18, 2024

Applies to:

Symptoms

Using SQLcl 24.3 (version: 24.3.0.0 build: 24.3.0.285.0053) to generate the schema using the "liquibase generate-schema" command shows many of the created files with trailing white spaces in lines and/or no EOF newline characters causing diff issues when trying to use git repositories.

Files are expected to be created with:
A) End-of-line white space trimming
B) Newlines at end-of-file consistently

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install SQLcl version: 24.3.0.0 build: 24.3.0.285.0053.
2. Install JDK 11.0.5 to use with SQLcl for testing purposes.
3. Set the JDK in the PATH.
4. Run sql script to create the schema objects on a database.
5. Connect to the database with SQLcl:
6. Run liquibase generate-schema
7. Search for files with trailing white space:

8. Tail the files.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.