AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Sqlite inner join same table twice12/20/2023 ![]() Thus assuming that there is something missing with cloning the Query. $result = $query->execute() // Line 122: FAILED $this->drupalPostForm("node/add/$this->referencingType", $edit, 'Save') $this->assertFalse($result, 'Referenced node does not exist yet.') $result = $query->execute() // Line 111: SUCCESS >condition('type', $this->referencedType) var/$base_query = \Drupal::entityQuery('node') var/www/html/web/core/lib/Drupal/Core/Entity/Query/Sql/Query.php:83 var/www/html/web/core/lib/Drupal/Core/Entity/Query/Sql/Query.php:267 ![]() var/www/html/web/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php:357 var/www/html/web/core/lib/Drupal/Core/Database/Connection.php:659 var/www/html/web/core/lib/Drupal/Core/Database/Connection.php:695 ![]() WHERE (node_field_data.type = :db_condition_placeholder_0) AND (node_field_data.title LIKE :db_condition_placeholder_1 ESCAPE '\\') Array Testing Drupal\Tests\field\Functional\EntityReference\EntityReferenceAutoCreateTestÄ¡) Drupal\Tests\field\Functional\EntityReference\EntityReferenceAutoCreateTest::testAutoCreateÄrupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE: Column not found: 1054 Unknown column 'node_field_data.type' in 'where clause': SELECT base_table.vid AS vid, base_table.nid AS nid I checked the autotest result, here is an example of the failed Test: WHERE (media_field_data.changed > :db_condition_placeholder_0) AND (media_field_data.bundle = :db_condition_placeholder_1) INNER JOIN media_field_data ON media_field_data.mid = base_table.mid ![]() Here is an example of the query build with original code: SELECT base_table.vid AS vid, base_table.mid AS mid, min(media_field_data_3.changed) AS expression This issue has a direct impact on the performance of Query execution, Support from Acquia helps fund testing for Drupal Comments ![]()
0 Comments
Read More
Leave a Reply. |