phpmyadmin · BackEndTea · Aug 15, 2023
diff --git a/src/Components/SetOperation.php b/src/Components/SetOperation.php
@@ -111,19 +111,27 @@ public static function parse(Parser $parser, TokensList $list, array $options =
                    $commaLastSeenAt = $token;
                }
            } elseif ($state === 1) {
-                $tmp = Expression::parse(
-                    $parser,
-                    $list,
-                    ['breakOnAlias' => true]
-                );
-                if ($tmp === null) {
-                    $parser->error('Missing expression.', $token);
-                    break;
+                if ($token->flags & Token::FLAG_SYMBOL_PARAMETER) {
+                    $expr->column = trim($expr->column);
+                    $expr->value = $token->value;
+                    $ret[] = $expr;
+                } else {
+                    $tmp = Expression::parse(
+                        $parser,
+                        $list,
+                        ['breakOnAlias' => true]
+                    );
+
+                    if ($tmp === null) {
+                        $parser->error('Missing expression.', $token);
+                        break;
+                    }
+
+                    $expr->column = trim($expr->column);
+                    $expr->value = $tmp->expr;
+                    $ret[] = $expr;
                }

-                $expr->column = trim($expr->column);
-                $expr->value = $tmp->expr;
-                $ret[] = $expr;
                $expr = new static();
                $state = 0;
                $commaLastSeenAt = null;

diff --git a/tests/Parser/UpdateStatementTest.php b/tests/Parser/UpdateStatementTest.php
@@ -28,6 +28,7 @@ public static function updateProvider(): array
            ['parser/parseUpdate5'],
            ['parser/parseUpdate6'],
            ['parser/parseUpdate7'],
+            ['parser/parseUpdate8'],
            ['parser/parseUpdateErr'],
        ];
    }

diff --git a/tests/TestCase.php b/tests/TestCase.php
@@ -93,7 +93,7 @@ public function getErrorsAsArray($obj): array
     */
    public function getData(string $name): array
    {
-        $serializedData = file_get_contents('tests/data/' . $name . '.out');
+        $serializedData = file_get_contents(__DIR__ . '/data/' . $name . '.out');
        $this->assertIsString($serializedData);

        $serializer = new CustomJsonSerializer();

diff --git a/tests/data/parser/parseUpdate8.in b/tests/data/parser/parseUpdate8.in
@@ -0,0 +1,11 @@
+UPDATE
+    users
+SET
+    username = ?,
+    id=155;
+
+UPDATE
+    users
+SET
+    username = :user_name,
+    id=155;
-Original file line number
+Diff line change
@@ -93,7 +93,7 @@ public function getErrorsAsArray($obj): array
          */
         public function getData(string $name): array
         {
-            $serializedData = file_get_contents('tests/data/' . $name . '.out');
+            $serializedData = file_get_contents(__DIR__ . '/data/' . $name . '.out');
                   williamdes marked this conversation as resolved.
              

          
            Show resolved
            Hide resolved
        

                
  
            
  

  
    
  
    
      

              Uh oh!

              
There was an error while loading. Please reload this page.
             $this->assertIsString($serializedData);
             $serializer = new CustomJsonSerializer();
-          Expand Down