I just setup pgsql & sqlite version of d7 and run simpletest inside

here a list of exceptions

pgsql

Default header was replaced.	
Other	bootstrap.test	165	
BootstrapPageCacheTestCase->testPageCache()

this fails because my bot behind reverse proxy

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "c2.cid": SELECT COUNT(*) AS count FROM {comment} c1 INNER JOIN {comment} c2 ON c2.nid = c1.nid WHERE (c2.cid = :db_condition_placeholder_6) AND (c1.cid < :db_condition_placeholder_7) ; Array ( [:db_condition_placeholder_6] => 4 [:db_condition_placeholder_7] => c2.cid )
comment.module	1409
comment_get_display_ordinal()

looks like db_condition_placeholder_7 should be removed 

Exception has proper SQLSTATE.
database_test.test	2466	
DatabaseInvalidDataTestCase->testInsertDuplicateData()

happens only on one bot

sqlite

The whole transaction is rolled back when a duplicate key insert occurs.
database_test.test	2458	
DatabaseInvalidDataTestCase->testInsertDuplicateData()

same as pgsql


Found 'in error_test_trigger_pdo_exception() (line 65 of /var/www/drupal/d7sq/modules/simpletest/tests/error_test.module)' in error page.	
error.test	101	
DrupalErrorHandlerUnitTest->testExceptionHandler()


SQLSTATE[HY000]: General error: 1 no such function: MD5: SELECT aid FROM {actions} WHERE MD5(aid) = :hash AND parameters <> ''; Array ( [:hash] => c4ca4238a0b923820dcc509a6f75849b )	PDOException	
database.inc	134	PDO->prepare()

sqlite does not have md5 function

SQLSTATE[HY000]: General error: 1 no such function: MD5: SELECT aid FROM {actions} WHERE MD5(aid) = :hash AND parameters <> ''; Array ( [:hash] => c81e728d9d4c2f636f067f89cc14862c )	PDOException	database.inc	134	PDO->prepare()

Same

Check that the cron run triggered both complex actions.	Other	trigger.test	175	TriggerCronTestCase->testActionsCron()

result of 2 previous

Let's fix them!

Comments

boombatower’s picture

Project: Test client setup » Project Issue File Review
Component: Documentation » Miscellaneous

Please link to any core issues.

andypost’s picture

boombatower’s picture

Status: Active » Closed (won't fix)

Out of date. Once we get back to testing non-mysql databases lets create new issues.