Taxonomy move_term tests fail for mysql, but not sqlite

[mikelietz]

Test results for move_term vary by database engine. The following two errors appear for mysql, but not sqlite:

Fail: When $before is true the Term should be inserted before $target_term
/var/www/habari/tests/test_taxonomy.php:298
Fail: Without arguments the Term should be moved all the way to the right
/var/www/habari/tests/test_taxonomy.php:304

[ringmaster]

My schema shows the terms table as UNSIGNED, as does the schema definition. This makes it impossible to place term id's into negative, temporary space as required when moving.

[ringmaster]

Confirmed, changing the mptt_left and mptt_right fields to be unsigned allows all test_taxonomy tests (including the most recent changes) to pass. Probably need to write a versioned migration, because I doubt that db_update will deal properly with the sign change.

[ringmaster]

Whaddaya know? db_update will change the sign of the field.

[chrismeller]

Just for reference, habari/system commit 35735ae is related.