2014-03-14
• Fixed incorrectly nested check for whether testPKColumns had succeeded (closes #7).
Nigel Stanger committed on 14 Mar 2014
• Completely re-engineered the way that fixture setup and teardown is managed so that it can be enabled and disabled on demand (closes #3). ...
Nigel Stanger committed on 14 Mar 2014
• Added initial coding for testing UNIQUE constraints. ...
Nigel Stanger committed on 14 Mar 2014
• Fixed inadvertently duplicated Username test value (also inconsistent with the other test values).
Nigel Stanger committed on 14 Mar 2014
2014-03-12
• Added support for zero or negative scale values. ...
Nigel Stanger committed on 12 Mar 2014
• Removed null min_length and decimals values from WEIGHTED_MARK as they were confusing the schema checker. It makes more sense for them to not just be specified anyway.
Nigel Stanger committed on 12 Mar 2014
• Added constants for verbosity levels. ...
Nigel Stanger committed on 12 Mar 2014
• Made verbosity comparisons more explicit. ...
Nigel Stanger committed on 12 Mar 2014
• Corrected argument name in comment.
Nigel Stanger committed on 12 Mar 2014
2014-03-11
• Added NVL() to query on Data_Precision to prevent spurious errors when precision isn’t specified for a NUMBER column (closes #2, I hope!).
Nigel Stanger committed on 11 Mar 2014
• Updated solution code to reflect changes to specification. ...
Nigel Stanger committed on 11 Mar 2014
2014-03-10
• Changed minimum age of employees to 18. ...
Nigel Stanger committed on 10 Mar 2014
• Added note about subtypes. ...
Nigel Stanger committed on 10 Mar 2014
2014-03-06
• Removed references to “design-level” ERDs and modeified statement about analysis phase.
Nigel Stanger committed on 6 Mar 2014
• Switched to Information Engineering notation to be consistent with INFO 211.
Nigel Stanger committed on 6 Mar 2014
• Initial switch of scenario for 2014.
Nigel Stanger committed on 6 Mar 2014
2013-12-12
• Clarified salaries for senior staff (closes #14).
Nigel Stanger committed on 12 Dec 2013
2013-09-19
Updated solution and comments for 2013 results.
Nigel Stanger committed on 19 Sep 2013
Added some optional constraints.
Nigel Stanger committed on 19 Sep 2013
2013-09-12
Changed the test values for rank and salary to avoid problems with clevel folks who restrict senior salaries to >$100000.
Nigel Stanger committed on 12 Sep 2013
2013-09-05
Workaround for testing FKs when there is more than one FK in the referenced table.
Nigel Stanger committed on 5 Sep 2013
2013-09-04
Added legal boundary values for Salary.
Nigel Stanger committed on 4 Sep 2013
2013-09-03
Added automated true/false value setting to the marking configuration.
Nigel Stanger committed on 3 Sep 2013
Added the ability to specify that a number column should include no length or decimal places.
Nigel Stanger committed on 3 Sep 2013
Added support for alternative true/false values in PHP, placeholders for them in XML, and a quick and dirty shell script to set them.
Nigel Stanger committed on 3 Sep 2013
Changed sample username to be the same as one in the fixture in order to show up any UNIQUE constraint.
Nigel Stanger committed on 3 Sep 2013
Added legal boundary values.
Nigel Stanger committed on 3 Sep 2013
Corrected reporting of overflow and underflow tests.
Nigel Stanger committed on 3 Sep 2013
Added legal boundary values.
Nigel Stanger committed on 3 Sep 2013
2013-09-02
Fixed handling of literal text and date default values.
Nigel Stanger committed on 2 Sep 2013