Zend\Db\Sql\Update building update statement

[biophymie]

Creating a update-statement returns a incorrect sql statement. If one of the updated column values has a empty value the iteration over the columns breaks, because the Zend/Stdlib/PriorityList stopps if a element is empty.

Method prepareStatement():

 foreach ($this->set as $column => $value) {
            if ($value instanceof Expression) {
                $exprData = $this->processExpression($value, $platform, $driver);
                $setSql[] = $platform->quoteIdentifier($column) . ' = ' . $exprData->getSql();
                $parameterContainer->merge($exprData->getParameterContainer());
            } else {
                $setSql[] = $platform->quoteIdentifier($column) . ' = ' . $driver->formatParameterName($column);
                $parameterContainer->offsetSet($column, $value);
            }
        }

Workaround:

 foreach ($this->set->toArray() as $column => $value) {
            if ($value instanceof Expression) {
                $exprData = $this->processExpression($value, $platform, $driver);
                $setSql[] = $platform->quoteIdentifier($column) . ' = ' . $exprData->getSql();
                $parameterContainer->merge($exprData->getParameterContainer());
            } else {
                $setSql[] = $platform->quoteIdentifier($column) . ' = ' . $driver->formatParameterName($column);
                $parameterContainer->offsetSet($column, $value);
            }
        }

[samsonasik]

it seems duplicate with #6768 like #6820 did, should be fixed by PR #6773