15.04 Unit tests fail using MySql
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
Low
|
Unassigned | ||
15.04 |
Fix Released
|
Low
|
Unassigned | ||
15.10 |
Fix Released
|
Low
|
Unassigned |
Bug Description
To replicate:
1. Install Mahara on MySQL
2. In the terminal, cd to your docroot (e.g. /var/www/mahara)
3. run "make phpunit"
Expected outcome: Something like "........SSS Time: 9.42 seconds, Memory: 29.75Mb"
Actual outcome: Big ugly error stack, and "........EEE"
Mahara:
$config->version = 2015030419;
$config->series = '15.04';
$config->release = '15.04.4';
DB: mysql 5.5
(mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3)
When running unit tests on a vanilla Mahara 15.04.4 with a mysql database, 3 tests fail:
Configuration read from /var/www/
........EEE
Time: 39.5 seconds, Memory: 36.00Mb
There were 3 errors:
1) WebServiceGroup
SQLException: Failed to get a recordset: mysqli error: [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 '"tst_config" WHERE "field" = 'webservice_
Command was: SELECT * FROM "tst_config" WHERE "field" = ? and values was (webservice_
/var/www/
/var/www/
/var/www/
/var/www/
/var/www/
/var/www/
2) WebServiceInsti
SQLException: Failed to get a recordset: mysqli error: [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 '"tst_config" WHERE "field" = 'webservice_
Command was: SELECT * FROM "tst_config" WHERE "field" = ? and values was (webservice_
/var/www/
/var/www/
/var/www/
/var/www/
/var/www/
/var/www/
3) WebServiceUserT
SQLException: Failed to get a recordset: mysqli error: [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 '"tst_config" WHERE "field" = 'webservice_
Command was: SELECT * FROM "tst_config" WHERE "field" = ? and values was (webservice_
/var/www/
/var/www/
/var/www/
/var/www/
/var/www/
/var/www/
FAILURES!
Tests: 11, Assertions: 21, Errors: 3.
make: *** [phpunit] Error 2
-------
On the same vanilla Mahara 15.04.4, the unit tests pass using postgres:
PHPUnit 4.3.4 by Sebastian Bergmann.
Configuration read from /var/www/
........SSS
Time: 38.13 seconds, Memory: 35.25Mb
OK, but incomplete, skipped, or risky tests!
Tests: 11, Assertions: 21, Skipped: 3.
no longer affects: | mahara/16.04 |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
Do we still use unit tests?