Failed Tests - ZEROFILL Syntax Errors

[Jay Pipes]

Going through all tests in order to bring the test suite up.

main.alias test failed:

 failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(11) NOT NULL

Fix should be simple. We no longer support the ZEROFILL argument, so many tests need to be updated to remove the INT(XX) syntax.

This should be an easy bug for a contributor to work on.

To repeat:

Build Drizzle:

cd myrepos/ # Change to whatever directory your repos are in...
bzr branch lp:drizzle trunk
cd trunk
./config/autorun.sh && ./configure && make
cd tests
./dtr --force

Find all tests which fail with syntax errors...

Fix the syntax in the test file, re-run:

./dtr --force $testname

For instance, fix the main.alias test, then:

./dtr --force main.alias

[Jay Pipes (jaypipes)]

tests are critical for us right now. Setting priority to high.

[Jay Pipes (jaypipes)]

Test cases have now all been corrected for these syntax errors.