 \unset ECHO
 \i unit_launch.sql
-SELECT plan(194);
+SELECT plan(257);
 
 SELECT diag('Chronostratigraphy level/parent update tests');
 

SELECT ok('' = (SELECT sub_section_botany_indexed FROM taxonomy WHERE id = 32), 'New sub_section_botany_indexed of unit 32: ''''');
SELECT ok(30 = (SELECT serie_ref FROm taxonomy WHERE id = 32), 'New serie_ref of unit 32: 30');
SELECT ok('serie' = (SELECT serie_indexed FROM taxonomy WHERE id = 32), 'New serie_indexed of unit 32: serie');
SELECT ok(31 = (SELECT super_species_ref FROM taxonomy WHERE id = 32), 'New sub_species_ref of unit 32: 31');
SELECT ok('superspecies' = (SELECT super_species_indexed FROM taxonomy WHERE id = 32), 'New species_indexed of unit 32: superspecies');

SELECT * FROM finish();
ROLLBACK;

SELECT ok('serie' = (SELECT serie_indexed FROM taxonomy WHERE id = 30), 'New serie_indexed of unit 30: serie');
SELECT ok(0 = (SELECT species_ref FROM taxonomy WHERE id = 30), 'New species_ref of unit 30: 0');
SELECT ok('' = (SELECT species_indexed FROM taxonomy WHERE id = 30), 'New species_indexed of unit 30: ''''');
SELECT ok(33 = (SELECT genus_ref FROM taxonomy WHERE id = 30), 'New genus_ref of unit 30: 33');
SELECT ok('genusdub' = (SELECT genus_indexed FROm taxonomy WHERE id = 30), 'New genus_indexed of unit 30: genusdub');
SELECT ok(29 = (SELECT sub_genus_ref FROM taxonomy WHERE id = 30), 'New sub_genus_ref of unit 30: 29');
SELECT ok('neosubgenus' = (SELECT sub_genus_indexed FROM taxonomy WHERE id = 30), 'New sub_genus_indexed of unit 30: neosubgenus');
SELECT ok(0 = (SELECT section_botany_ref FROM taxonomy WHERE id = 30), 'New section_botany_ref of unit 30: 0');
SELECT ok('' = (SELECT section_botany_indexed FROM taxonomy WHERE id = 30), 'New section_botany_indexed of unit 30: ''''');
SELECT ok(0 = (SELECT sub_section_botany_ref FROM taxonomy WHERE id = 30), 'New sub_section_botany_ref of unit 30: 0');
SELECT ok('' = (SELECT sub_section_botany_indexed FROM taxonomy WHERE id = 30), 'New sub_section_botany_indexed of unit 30: ''''');
SELECT ok(30 = (SELECT serie_ref FROm taxonomy WHERE id = 30), 'New serie_ref of unit 30: 30');
SELECT ok('serie' = (SELECT serie_indexed FROM taxonomy WHERE id = 30), 'New serie_indexed of unit 30: serie');
SELECT ok(0 = (SELECT super_species_ref FROM taxonomy WHERE id = 30), 'New super_species_ref of unit 30: 31');
SELECT ok('' = (SELECT super_species_indexed FROM taxonomy WHERE id = 30), 'New super_species_indexed of unit 30: superspecies');
SELECT ok(33 = (SELECT genus_ref FROM taxonomy WHERE id = 32), 'New genus_ref of unit 32: 33');
SELECT ok('genusdub' = (SELECT genus_indexed FROm taxonomy WHERE id = 32), 'New genus_indexed of unit 32: genusdub');
SELECT ok(29 = (SELECT sub_genus_ref FROM taxonomy WHERE id = 32), 'New sub_genus_ref of unit 32: 29');
