function DatabaseSelectCloneTest::testSelectConditionSubQueryCloning

Test that subqueries as value within conditions are cloned properly.

File

core/modules/simpletest/tests/database_test.test, line 299

Database tests.

Class

DatabaseSelectCloneTest

Test cloning Select queries.

Code

function testSelectConditionSubQueryCloning() {
  $subquery = db_select('test', 't');
  $subquery->addField('t', 'id', 'id');
  $subquery->condition('age', 28, '<');

  $query = db_select('test', 't');
  $query->addField('t', 'name', 'name');
  $query->condition('id', $subquery, 'IN');

  $clone = clone $query;

  // Cloned query should have a different unique identifier.
  $this->assertNotEqual($query->uniqueIdentifier(), $clone->uniqueIdentifier());

  // Cloned query should not be altered by the following modification
  // happening on original query.
  $subquery->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->assertEqual(3, $clone_result, 'The cloned query returns the expected number of rows');
  $this->assertEqual(2, $query_result, 'The query returns the expected number of rows');
}