Problem with populating customers.cvs and supplementary_demographics.cvs

[maierh7]

I am using the latest version of SqlCL and also the latest Oracle FREE database with podman. When I install the sales history then the "customers.cvs" and also the "supplementary_demographics.csv" files are not loaded because of null string in form of '""'.

Table                            provided    actual
_____________________________ ___________ _________
channels                                5         5
costs                               82112     82112
countries                              35        35
customers                           55500         0
products                               72        72
promotions                            503       503
sales                              918843    918843
times                                1826      1826
supplementary_demographics           4500         2

When I changed the nulls from '""' to '' then the files will be loaded.

Table                            provided    actual 
_____________________________ ___________ _________ 
channels                                5         5 
costs                               82112     82112 
countries                              35        35 
customers                           55500     55500 
products                               72        72 
promotions                            503       503 
sales                              918843    918843 
times                                1826      1826 
supplementary_demographics           4500      4500 

Harald

Oracle Version: 23.26.0.0.0 2025-12-31 2025-12-28 d316a9f31a02 FREE
SqlCL Version: 25.4.0.346.1855

[gvenzl]

Thanks for the report, @maierh7.

Initial tests show that this might be a possible regression introduced in the latest version of SQLcl 25.4, as the install succeeds with the previous version of SQLcl 25.3.2:

gvenzl@gvenzl-mac sales_history % ~/Downloads/sqlcl-25.3.2/bin/sql -version

SQLcl: Release 25.3.2.0 Production Build: 25.3.2.317.1117
gvenzl@gvenzl-mac sales_history % ~/Downloads/sqlcl-25.3.2/bin/sql system@localhost/freepdb1


SQLcl: Release 25.3 Production on Thu Jan 15 11:47:57 2026

Copyright (c) 1982, 2026, Oracle.  All rights reserved.

Password? (**********?) *********
SP2-0268: linesize option not a valid number

Last Successful login time: Thu Jan 15 2026 11:47:59 -08:00

Connected to:
Oracle AI Database 26ai Free Release 23.26.0.0.0 - Develop, Learn, and Run for Free
Version 23.26.0.0.0

SQL> @sh_install
...
...
...
******  Gathering statistics for schema ...

PL/SQL procedure successfully completed.


End time: 15-JAN-26 07.48.34.810046 PM +00:00

1 row selected.


Installation verification
____________________________
Verification:

Table                            provided    actual
_____________________________ ___________ _________
channels                                5         5
costs                               82112     82112
countries                              35        35
customers                           55500     55500
products                               72        72
promotions                            503       503
sales                              918843    918843
times                                1826      1826
supplementary_demographics           4500      4500

Thank you!
___________________________________________________________
The installation of the sample schema is now finished.
Please check the installation verification output above.
You will now be disconnected from the database.
Thank you for using Oracle Database!
Disconnected from Oracle AI Database 26ai Free Release 23.26.0.0.0 - Develop, Learn, and Run for Free
Version 23.26.0.0.0

[gvenzl]

Hi @maierh7,

This is confirmed to be a bug in SQLcl that will be fixed in the next version, which is expected to be released in about a week.