Merge pull request #19992 from MauricioFauth/e2e-tests-fix

MauricioFauth · web-flow · commit 8148b4bc7230 · 2025-12-16T16:57:07.000-03:00
Fix failing end to end tests
diff --git a/tests/end-to-end/Database/StructureTest.php b/tests/end-to-end/Database/StructureTest.php
@@ -52,7 +52,7 @@ public function testTruncateTable(): void
         $this->waitForElement('id', 'functionConfirmOkButton')->click();
 
         $success = $this->waitForElement('cssSelector', '.alert-success');
-        self::assertStringContainsString('MySQL returned an empty result', $success->getText());
+        self::assertStringContainsString('Table test_table has been emptied.', $success->getText());
 
         $this->dbQuery(
             'SELECT CONCAT("Count: ", COUNT(*)) as c FROM `' . $this->databaseName . '`.`test_table`',
diff --git a/tests/end-to-end/Table/CreateTest.php b/tests/end-to-end/Table/CreateTest.php
@@ -60,7 +60,6 @@ public function testCreateTable(): void
         $columnDropdownDetails = [
             'field_0_6' => 'UNSIGNED',
             'field_1_2' => 'VARCHAR',
-            'field_1_5' => 'utf8mb4_general_ci',
             'field_1_4' => 'As defined:',
         ];
 
@@ -71,6 +70,13 @@ public function testCreateTable(): void
             )->click();
         }
 
+        // click to load select options
+        $this->byId('field_1_5')->click();
+        $this->waitForElement(
+            'xpath',
+            '//select[@id=\'field_1_5\']//option[contains(text(), \'utf8mb4_general_ci\')]',
+        )->click();
+
         $this->byName('field_default_value[1]')->sendKeys('def');
 
         $this->scrollToBottom();
diff --git a/tests/end-to-end/Table/OperationsTest.php b/tests/end-to-end/Table/OperationsTest.php
@@ -172,7 +172,7 @@ public function testTruncateTable(): void
         $this->waitAjax();
 
         $success = $this->waitForElement('cssSelector', '.alert-success');
-        self::assertStringContainsString('MySQL returned an empty result set', $success->getText());
+        self::assertStringContainsString('Table test_table has been emptied.', $success->getText());
 
         $this->dbQuery(
             'SELECT CONCAT("Count: ", COUNT(*)) as c FROM `' . $this->databaseName . '`.test_table',
@@ -195,7 +195,7 @@ public function testDropTable(): void
         $this->waitAjax();
 
         $success = $this->waitForElement('cssSelector', '.alert-success');
-        self::assertStringContainsString('MySQL returned an empty result set', $success->getText());
+        self::assertStringContainsString('Table test_table has been dropped.', $success->getText());
 
         $this->dbQuery(
             'USE `' . $this->databaseName . '`;'
