Optimize which PHPUnit CI jobs run: 1) nightly: ALL version+DB combos, 2) 1.x/merged MRs: 11.3 all DBs, 11.2 only SQLite
>>> [!note] Migrated issue
<!-- Drupal.org comment -->
<!-- Migrated from issue #3587819. -->
Reported by: [wim leers](https://www.drupal.org/user/99777)
Related to !1020
>>>
<h3 id="overview">Overview</h3>
<p>Today:</p>
<ul>
<li>MR commit: already only SQLite, both on 11.2 + 11.3. Example: <a href="https://git.drupalcode.org/project/canvas/-/pipelines/809198">https://git.drupalcode.org/project/canvas/-/pipelines/809198</a>
</li><li><code>1.x</code> commit: all DBs, both on 11.2 + 11.3. Example: <a href="https://git.drupalcode.org/project/canvas/-/pipelines/809167">https://git.drupalcode.org/project/canvas/-/pipelines/809167</a>
</li></ul>
<p>Quoting <span class="drupalorg-gitlab-issue-link drupalorg-gitlab-link-wrapper"><a href="https://git.drupalcode.org/project/canvas/-/work_items/3585979" class="drupalorg-gitlab-link">https://git.drupalcode.org/project/canvas/-/work_items/3585979</a></span>:</p>
<blockquote><p>
After <span class="drupalorg-gitlab-issue-link drupalorg-gitlab-link-wrapper"><a href="https://git.drupalcode.org/project/canvas/-/work_items/3529128" class="drupalorg-gitlab-link">https://git.drupalcode.org/project/canvas/-/work_items/3529128</a></span> lands, I think we should consider making:</p>
<ol>
<li><code>PHPUnit (11.2)</code> run on all DBs</li>
<li><code>PHPUnit (11.3)</code> run only on SQLite</li>
</ol>
<p>Or vice versa.</p>
<p>Thoughts?</p>
<p>EDIT: to clarify, I mean for <em>merge commits</em> (aka push to <code>1.x</code>). <em>Currently</em> both 11.2 and 11.3 run all tests on all 4 DBs.
</p></blockquote>
<h3 id="proposed-resolution">Proposed resolution</h3>
<ul>
<li><strong>unchanged</strong> MR commit: already only SQLite, both on 11.2 + 11.3
</li><li><strong>changed</strong> <code>1.x</code> commit: all DBs on 11.3 only because that's what the majority of people use, only SQLite on 11.2
</li><li><strong>changed NEW</strong> nightly pipeline: all DBs, both on 11.2 + 11.3
</li></ul>
<h3 id="ui-changes">User interface changes</h3>
<p>None.</p>
issue