Merge pull request #17686 from kamil-tekiela/Allow-fields-to-be-set-to-null

Allow fields to be set to NULL

1 files changed, 24 insertions, 0 deletions

diff --git a/test/classes/InsertEditTest.php b/test/classes/InsertEditTest.php
index 13ee204b74..590fa810d3 100644
--- a/test/classes/InsertEditTest.php
+++ b/test/classes/InsertEditTest.php
@@ -2143,6 +2143,30 @@ class InsertEditTest extends AbstractTestCase
             ],
             $result
         );
+
+        // Test to see if a field can be set to NULL
+        $result = $this->insertEdit->getQueryValuesForInsertAndUpdateInMultipleEdit(
+            $multi_edit_columns_name,
+            ['on'],
+            '',
+            [''],
+            [],
+            false,
+            [],
+            [],
+            'NULL',
+            [],
+            '0',
+            []
+        );
+
+        $this->assertEquals(
+            [
+                ['`fld` = NULL'],
+                [],
+            ],
+            $result
+        );
     }
 
     /**