Add ordered option to ArrayMerge (#1048)

Tigrov · web-flow · commit 729832645cd9 · 2025-08-26T18:54:12.000+07:00
diff --git a/CHANGELOG.md b/CHANGELOG.md
@@ -136,7 +136,7 @@
 - Enh #1031: Optimize SQL generation for `Not` condition (@vjik)
 - Chg #1037: Change result type of `QueryBuilderInterface::getExpressionBuilder()` and
   `DQLQueryBuilderInterface::getExpressionBuilder()` methods to `ExpressionBuilderInterface` (@vjik)
-- New #1029: Add functions as expressions (@Tigrov)
+- New #1029, #1048: Add functions as expressions (@Tigrov)
 - Enh #1042: Refactor `AbstractDMLQueryBuilder` class to `upsert()` method (@Tigrov)
 - New #1040, #1043: Add `DateTimeValue` class (@vjik, @Tigrov)
 
diff --git a/src/Expression/Function/ArrayMerge.php b/src/Expression/Function/ArrayMerge.php
@@ -23,8 +23,17 @@
  */
 final class ArrayMerge extends MultiOperandFunction
 {
+    private bool $ordered = false;
     private string|ColumnInterface $type = '';
 
+    /**
+     * Returns whether the result array should be ordered.
+     */
+    public function getOrdered(): bool
+    {
+        return $this->ordered;
+    }
+
     /**
      * Returns the type of the operands. Empty string if not set.
      */
@@ -33,6 +42,15 @@ public function getType(): string|ColumnInterface
         return $this->type;
     }
 
+    /**
+     * Sets whether the result array should be ordered.
+     */
+    public function ordered(bool $ordered = true): self
+    {
+        $this->ordered = $ordered;
+        return $this;
+    }
+
     /**
      * Sets the type of the operands.
      */
diff --git a/tests/Db/Expression/Function/ArrayMergeTest.php b/tests/Db/Expression/Function/ArrayMergeTest.php
@@ -25,4 +25,15 @@ public function testType(): void
         $this->assertSame($expression, $expression->type($intColumn));
         $this->assertSame($intColumn, $expression->getType());
     }
+
+    public function testOrdered(): void
+    {
+        $expression = new ArrayMerge();
+
+        $this->assertFalse($expression->getOrdered());
+        $this->assertSame($expression, $expression->ordered());
+        $this->assertTrue($expression->getOrdered());
+        $this->assertSame($expression, $expression->ordered(false));
+        $this->assertFalse($expression->getOrdered());
+    }
 }
