CQL upgrade script not working on ubuntu 18.04
When trying to run unit-tests for !138 (merged) (compiled with --with-cql), I've encountered this unrelated issue:
cd src/bin/admin
make check
START TEST cql.unused_subnet_id_test
Processing /home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_1.0_to_2.0.sh file...
Schema upgraded to 2.0
Lease DB version reported before upgrade: 2.0
Processing /home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_1.0_to_2.0.sh file...
This script upgrades 1.0 to 2.0. Reported version is 2.0. Skipping upgrade.
Processing /home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh file...
Exporting host_reservation data to /home/thomson/devel/kea-premium/src/share/database/scripts/cql/cql_export.csv ...
Using 7 child processes
Starting copy of keatest.host_reservations with columns [id, host_ipv4_subnet_id, host_ipv6_subnet_id, option_subnet_id].
Processed: 5 rows; Rate: 39 rows/s; Avg. rate: 39 rows/s
5 rows exported to 1 files in 0.136 seconds.
/home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: 191: /home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: let: not found
/home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: 217: /home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: let: not found
/home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: 217: /home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: let: not found
/home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: 217: /home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: let: not found
/home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: 217: /home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: let: not found
/home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: 75: [: /home/thomson/devel/kea-p: unexpected operator
/home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: 80: [: /home/thomson/devel/kea-p: unexpected operator
Data Migration FAILURE! Line# 0, too few values, wrong or corrupt file
/home/thomson/devel/kea-premium/src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh: 105: exit: Illegal number: -1
Lease DB version reported after upgrade: 3.0
Exporting host_reservation data to /home/thomson/devel/kea-premium/src/bin/admin/tests/data/cql.subnet_id_test.csv ...
Assertion failure: 0 != 1, for val1=0, val2=1
export file does not match reference file, expected exit code 0, actual 1
FAILED cql.unused_subnet_id_test
this is on ubuntu 18.04. Note the /bin/sh is coming from dash package, it is not a bash script.