• Removed @expectedException annotations as they were causing spurious failures. Checking based on the exception text is more useful in general anyway.

• Alphabetically sorted various columns lists before comparison so that we don’t fail if, e.g., a student lists their PK columns in a different order from what we expected (closes #8).

• Added substitution of values in related columns when testing legal and illegal values (closes #17).

• Modified sqlifyValue() to correctly handle date test values generated by a function.

• Added logging of column aliases, just for informational purposes.

• Extended warning message for aliased column names.

• Added sqlifyList() method. ...

• Tweaked warning about alternative column names.

• Added StringContainsSC and TraversableContainsSC constraints. ...

• Tidied formatting and grammar of error strings.
• Made appropriate use of the *SC assert variants.

• Removed the modified PHPUnit Autoload.php and switched to explicit loading of custom constraint classes. ...

• Added staff/student mode conditional processing so that the more verbose constraints are used for marking.

• Fixed placeholder typo in printf argument.

• Slightly tweaked output for numeric column length assertion.

• Implemented specialised “non-informative” subclasses of various constraints so that we can test assertions without giving away the answers to the students! (closes #13) ...

• Refactored a couple of variable names.
• Fixed punctuation in assertion output.

• Completely re-engineered the way that fixture setup and teardown is managed so that it can be enabled and disabled on demand (closes #3). ...

• Fixed a bug in SimpleTestListener that caused a crash when a table didn’t exist in the schema being tested.
• Added proper error reporting for missing tables.

• Added initial coding for testing UNIQUE constraints. ...

• Removed unused argument to sprintf in assertFKColumns().

• Added support for zero or negative scale values. ...

• Improved reporting of precision/scale vs. length for NUMBER vs. *CHAR.
• Added NVL() to Data_Scale to eliminate spurious errors.
• Added debug output.

• Added NVL() to query on Data_Precision to prevent spurious errors when precision isn’t specified for a NUMBER column (closes #2, I hope!).

Workaround for testing FKs when there is more than one FK in the referenced table.

Added the ability to specify that a number column should include no length or decimal places.

Fixed handling of literal text and date default values.

Added default value testing.

Fixed sense of underflow constraint violation test.

assertColumnLegalValue() now correctly fails if the legal value generates a constraint violation.

Added support for detecting column aliases (can’t do much about it other than warn the user, as the fixture won’t match if the name’s different anyway).

Added a comment explaining why a WITH won’t solve the LONG problem in User_Constraints.

- Changed run mode and verbosity variables to global constants. ...

- Added different output for some tests based on RUN_MODE.
- Cleaned up output for all tests.

Fixed output typos.

Removed some obsolete console output.

Fixed incorrect array nesting in assertFKColumns.

Moved scenario-specific code into scenario subtree and factored out globally defined values into various configuration files. Also replaced a bunch of things with global constants.

Temporarily stripped out text that would reveal information to students. Need a better solution long-term!