10427303249
92%

Ran 16 Aug 2024 11:07PM UTC

Jobs 1

Files 76

Run time 1min

Badge

Embed ▾

Committed 16 Aug 2024 11:00PM UTC coverage: 93.254%. Remained the same

Build # 10427303249

Build Type

push

github

Committed by

evanelias

Commit Message

tests: work-around for MariaDB Aug 2024 release FK bug

Some of this month's MariaDB server releases contain a bug where ALTER
TABLE ... ADD CONSTRAINT ... FOREIGN KEY does not properly validate that the
existing table data satisfies the new FK constraint, at least with default
server settings.

After investigating further, we've narrowed down the cause to be
https://jira.mariadb.org/browse/MDEV-33087, and I have reported the bug as
https://jira.mariadb.org/browse/MDEV-34756. This bug affects the following
MariaDB server versions: 10.11.9, 11.1.6, 11.2.5, 11.4.3, 11.5.2. Fixes are
likely to be present in next quarter's releases of 10.11.10, 11.2.6, and
11.4.4. (Since 11.1 and 11.5 are now EOL after this month, there will be no
further releases or fixes for those series.)

This bug caused failures in Skeema's integration test suite in test method
TestForeignKeys. To work-around the server bug, in this commit we now disable
global variable innodb_alter_copy_bulk.

Between this fix and the fix in previous commit 49aed41, integration tests now
pass for MariaDB August 2024 releases (aside from 10.5.2, as 10.5 isn't fully
supported by Skeema yet, but will be soon). This commit also then reverts the
recent CI change from 68c961d which pinned integration tests to a MariaDB
server release from the previous quarter.

Coverage Stats

9980 of 10702 relevant lines covered (93.25%)

1.11 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	10427303249.1	16 Aug 2024 11:07PM UTC	0	93.25	GitHub Action Run

Source Files on build 10427303249

Detailed source file information is not available for this build.

skeema / skeema / 10427303249
92%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 10427303249

skeema / skeema / 10427303249 92%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 10427303249

skeema / skeema / 10427303249
92%

README BADGES
x