Test tool and unit test improvements for 7.0

[desrosj]

• #63167 (6.9)
• #62280 (6.8)
• #61530 (6.7)
• #60705 (6.6)
• #59647 (6.5)
• #58955 (6.4)
• #57841 (6.3)
• #56793 (6.2)
• #55652 (6.1)
• #54725 (6.0)
• #53363 (5.9)
• #52625 (5.8)
• #51802 (5.7)
• #51344 (5.6)

This ticket is for various fixes and improvements in PHPUnit tests that don't have a more specific ticket, as well as general improvements to the GitHub Actions workflows that run automated testing.

This test verifies that post meta cache persists (is not invalidated) when a post is updated, which documents the actual WordPress cache behavior.

Trac ticket:
https://core.trac.wordpress.org/ticket/64225
https://core.trac.wordpress.org/ticket/63167

Update unsupported image format tests to use TGA instead of AVIF

Trac ticket:
https://core.trac.wordpress.org/ticket/64225
https://core.trac.wordpress.org/ticket/63167

Updated REST API test methods using the unsupported image format to test unsupported logic checks

Adding PHPUnit tests for get_post_states function

Trac ticket:
https://core.trac.wordpress.org/ticket/64225
https://core.trac.wordpress.org/ticket/63167

MySQL 9.5 is the most recent innovation release. This should be tested against appropriately.

Trac ticket: Core-64225

[desrosj]

In 61245:

Build/Test Tools: Add MySQL 9.5 to test strategies.

MySQL 9.5 is the most recent innovation release. This updates the GitHub Actions workflows testing against innovation release versions to use this new version.

See #64225.

Merged in r61245.

@paulbonneau There's a merge conflict. Could you resolve?

@paulbonneau There's a merge conflict. Could you resolve?

Hi @westonruter, the merge conflict has been resolved