Sqlite Integration tests fail on macOS php 7.4
Closed, ResolvedPublic
Actions

Description

Motivation

The 6 integration tests fail on SQLite db driver:
composer.phar phpunit:integration -- --exclude-group Broken,ParserFuzz,Stub --filter DatabaseSqliteTest
with output like:

1) DatabaseSqliteTest::testUpgrades
Default values does not match for column filearchive.fa_actor upgrading from 1.15 to 1.35.0-alpha
Failed asserting that '0' matches expected null.

/Users/peter/work/Wiki/gerrit/mediawiki/tests/phpunit/integration/includes/db/DatabaseSqliteTest.php:398
/Users/peter/work/Wiki/gerrit/mediawiki/tests/phpunit/MediaWikiIntegrationTestCase.php:416

2) DatabaseSqliteTest::testNativeInsertSupport with data set #0 ('3.7.11', 'a', array(1), 'INSERT  INTO a (a_1) VALUES ('1');')
Failed asserting that two strings are equal.
--- Expected
+++ Actual
@@ @@
-'INSERT  INTO a (a_1) VALUES ('1');'
+'INSERT  INTO a (a_1) VALUES (1);'

FAILURES!
Tests: 39, Assertions: 403, Failures: 5.
Script phpunit --colors=always --testsuite=core:integration,extensions:integration,skins:integration handling the phpunit:integration event returned with error code 1

Expected Result

All tests should pass.

Details

Related Gerrit Patches:

mediawiki/core : master

sqlite: Fix broken integration tests for SQLite db driver

Related Objects
Search...

Status	Assigned	Task
Resolved	Peter.ovchyn	T245995 Sqlite Integration tests fail on macOS php 7.4
Open	Peter.ovchyn	T246076 Wrong definition of MW_ENTRY_POINT when integration tests run.
Resolved	aaron	T246077 SQlite has wrong DB structure after upgrading to 1.35
Invalid	Peter.ovchyn	T246078 Add SQLite infra to Jenkins CI

Event Timeline

Peter.ovchyn created this task.Feb 24 2020, 1:48 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 24 2020, 1:48 PM

Peter.ovchyn updated the task description. (Show Details)Feb 24 2020, 1:48 PM

Peter.ovchyn updated the task description. (Show Details)

Aklapper added projects: SQLite, MediaWiki-General.Feb 24 2020, 2:43 PM

Peter.ovchyn moved this task from Backlog to Doing on the Core Platform Team Workboards (Contractor Workboard) board.Feb 24 2020, 5:08 PM

Change 574703 had a related patch set uploaded (by Peter.ovchyn; owner: Peter.ovchyn):
[mediawiki/core@master] sqlite: Fix broken integration tests for SQLite db driver

https://gerrit.wikimedia.org/r/574703

gerritbot added a project: Patch-For-Review.Feb 25 2020, 9:40 AM

Fixed 4 out of 5 tests related to data representation.

FAILURES!
Tests: 42, Assertions: 407, Failures: 1, Risky: 1.
Script phpunit --colors=always --testsuite=core:integration,extensions:integration,skins:integration handling the phpunit:integration event returned with error code 1

Peter.ovchyn moved this task from Doing to Waiting for Review on the Core Platform Team Workboards (Contractor Workboard) board.Feb 26 2020, 8:02 AM

daniel added subscribers: Anomie, Ladsgroup.Feb 26 2020, 10:31 AM

Anomie closed subtask T246078: Add SQLite infra to Jenkins CI as Invalid.Feb 26 2020, 4:55 PM

Anomie mentioned this in T246077: SQlite has wrong DB structure after upgrading to 1.35.Feb 26 2020, 4:57 PM

Change 574703 merged by jenkins-bot:
[mediawiki/core@master] sqlite: Fix broken integration tests for SQLite db driver

https://gerrit.wikimedia.org/r/574703