PHPunit Test failed to complete; Error: PHPUnit 7.5.20 by Sebastian Bergmann and contributors.

Testing Drupal\KernelTests\Core\Database\SelectTest ................FF................ 34 / 34 (100%)

Time: 3.05 minutes, Memory: 8.00 MB

There were 2 failures:

1) Drupal\KernelTests\Core\Database\SelectTest::testUnionOrder
First query returned correct name.
Failed asserting that two strings are equal.
--- Expected
+++ Actual
@@ @@
-'Ringo'
+'George'

/var/www/drupal88/web/core/tests/Drupal/TestTools/PhpUnitCompatibility/PhpUnit7/TestCompatibilityTrait.php:53
/var/www/drupal88/web/core/tests/Drupal/KernelTests/AssertLegacyTrait.php:37
/var/www/drupal88/web/core/tests/Drupal/KernelTests/Core/Database/SelectTest.php:394

2) Drupal\KernelTests\Core\Database\SelectTest::testUnionOrderLimit
UNION with a limit returned rows from both queries.
Failed asserting that 3 matches expected 2.

/var/www/drupal88/web/core/tests/Drupal/TestTools/PhpUnitCompatibility/PhpUnit7/TestCompatibilityTrait.php:53
/var/www/drupal88/web/core/tests/Drupal/KernelTests/AssertLegacyTrait.php:37
/var/www/drupal88/web/core/tests/Drupal/KernelTests/Core/Database/SelectTest.php:420

FAILURES!
Tests: 34, Assertions: 84, Failures: 2.

Comments

sinn created an issue. See original summary.

sinn’s picture

sinn CreditAttribution: sinn as a volunteer commented
Version: » 8.x-1.0-alpha1

Order by is not supported in union by MemSQL - https://www.memsql.com/forum/t/order-by-and-group-by-on-result-of-union/....

Original query from the test:

SELECT t.name AS name FROM test t WHERE age IN (27, 28) UNION SELECT t.name AS name FROM test t WHERE age = 26 ORDER by name DESC;

Returns "Paul, Ringo, George".

Such query works:

SELECT r.name AS name FROM (SELECT t.name AS name FROM test t WHERE age IN (27, 28) UNION SELECT t.name AS name FROM test t WHERE age = 26) as r ORDER by name DESC;