Updated Drupal to 8.6. This goes with the following updates because it's possible...

[yaffs-website] / web / core / tests / Drupal / KernelTests / Core / Database / SelectCloneTest.php

diff --git a/web/core/tests/Drupal/KernelTests/Core/Database/SelectCloneTest.php b/web/core/tests/Drupal/KernelTests/Core/Database/SelectCloneTest.php
index 30a4f1b9410852cfc23dead0b0e01a6ba805295c..3b14283b3451691b110b18bb25922b40e23f2faf 100644 (file)
--- a/web/core/tests/Drupal/KernelTests/Core/Database/SelectCloneTest.php
+++ b/web/core/tests/Drupal/KernelTests/Core/Database/SelectCloneTest.php
@@ -22,6 +22,10 @@ class SelectCloneTest extends DatabaseTestBase {
     $query->condition('id', $subquery, 'IN');
 
     $clone = clone $query;
+
+    // Cloned query should have a different unique identifier.
+    $this->assertNotEquals($query->uniqueIdentifier(), $clone->uniqueIdentifier());
+
     // Cloned query should not be altered by the following modification
     // happening on original query.
     $subquery->condition('age', 25, '>');
@@ -34,4 +38,31 @@ class SelectCloneTest extends DatabaseTestBase {
     $this->assertEqual(2, $query_result, 'The query returns the expected number of rows');
   }
 
+  /**
+   * Tests that nested SELECT queries are cloned properly.
+   */
+  public function testNestedQueryCloning() {
+    $sub_query = $this->connection->select('test', 't');
+    $sub_query->addField('t', 'id', 'id');
+    $sub_query->condition('age', 28, '<');
+
+    $query = $this->connection->select($sub_query, 't');
+
+    $clone = clone $query;
+
+    // Cloned query should have a different unique identifier.
+    $this->assertNotEquals($query->uniqueIdentifier(), $clone->uniqueIdentifier());
+
+    // Cloned query should not be altered by the following modification
+    // happening on original query.
+    $sub_query->condition('age', 25, '>');
+
+    $clone_result = $clone->countQuery()->execute()->fetchField();
+    $query_result = $query->countQuery()->execute()->fetchField();
+
+    // Make sure the cloned query has not been modified.
+    $this->assertEquals(3, $clone_result, 'The cloned query returns the expected number of rows');
+    $this->assertEquals(2, $query_result, 'The query returns the expected number of rows');
+  }
+
 }