START TEST mysql.lease6_dump_test
Wiping whole database keatest
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Checking if there is a database initialized already. Please ignore errors.
Warning: Using a password on the command line interface can be insecure.
Initializing database using script /home/thomson/devel/kea2/src/bin/admin/scripts/mysql/dhcpdb_create.mysql
Warning: Using a password on the command line interface can be insecure.
mysql returned status code 0
Lease DB version reported after initialization: Warning: Using a password on the command line interface can be insecure.
4.0

Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
lease6 successfully dumped to /home/thomson/devel/kea2/src/bin/admin/tests/data/mysql.lease6_dump_test.output.csv
Assertion failure: 0 != 1, for val1=0, val2=1
dump file does not match reference file, expected exit code 0, actual 1
FAILED mysql.lease6_dump_test

Makefile:695: recipe for target 'check-local' failed
make[3]: *** [check-local] Error 1
make[3]: Leaving directory '/home/thomson/devel/kea2/src/bin/admin/tests'
Makefile:571: recipe for target 'check-am' failed
make[2]: *** [check-am] Error 2
make[2]: Leaving directory '/home/thomson/devel/kea2/src/bin/admin/tests'
Makefile:423: recipe for target 'check-recursive' failed
make[1]: *** [check-recursive] Error 1
make[1]: Leaving directory '/home/thomson/devel/kea2/src/bin/admin/tests'
Makefile:552: recipe for target 'check-recursive' failed
make: *** [check-recursive] Error 1
thomson@billabong:~/devel/kea2/src/bin/admin$ diff tests/data/mysql.lease6_dump_test.output.csv tests/data/mysql.lease6_dump_test.reference.csv
1a2
> 10,3230,30,2015-04-04 01:15:30,40,50,IA_TA,60,70,1,1,one.example.com,3830,90,HWADDR_SOURCE_REMOTE_ID,default
4d4
< 10,3230,30,2015-04-04 01:15:30,40,50,IA_TA,60,70,1,1,one.example.com,3830,90,HWADDR_SOURCE_REMOTE_ID,default
thomson@billabong:~/devel/kea2/src/bin/admin$ cat tests/data/mysql.lease6_dump_test.reference.csv
address,duid,valid_lifetime,expire,subnet_id,pref_lifetime,lease_type,iaid,prefix_len,fqdn_fwd,fqdn_rev,hostname,hwaddr,hwtype,hwaddr_source,state
10,3230,30,2015-04-04 01:15:30,40,50,IA_TA,60,70,1,1,one.example.com,3830,90,HWADDR_SOURCE_REMOTE_ID,default
11,,30,2015-05-05 02:30:45,40,50,IA_TA,60,70,1,1,,3830,90,HWADDR_SOURCE_RAW,declined
12,3231,30,2015-06-06 11:01:07,40,50,IA_TA,60,70,1,1,three.example.com,3830,90,HWADDR_SOURCE_DUID,expired-reclaimed
thomson@billabong:~/devel/kea2/src/bin/admin$ cat tests/data/mysql.lease6_dump_test.output.csv
address,duid,valid_lifetime,expire,subnet_id,pref_lifetime,lease_type,iaid,prefix_len,fqdn_fwd,fqdn_rev,hostname,hwaddr,hwtype,hwaddr_source,state
11,,30,2015-05-05 02:30:45,40,50,IA_TA,60,70,1,1,,3830,90,HWADDR_SOURCE_RAW,declined
12,3231,30,2015-06-06 11:01:07,40,50,IA_TA,60,70,1,1,three.example.com,3830,90,HWADDR_SOURCE_DUID,expired-reclaimed
10,3230,30,2015-04-04 01:15:30,40,50,IA_TA,60,70,1,1,one.example.com,3830,90,HWADDR_SOURCE_REMOTE_ID,default