Variable $sql is null after preg_replace

[mjvermeltfoort]

When I create a update query with an IN statement for string that contain a double quote the $sql is null after the preg_replace at

magento-zend-db/library/Zend/Db/Statement.php

Line 210 in 475addb

$sql = preg_replace("/\"(\\\\\"|[^\"])*\"/Us", '', $sql);

Original sql:
original.txt

Sql after replace on

magento-zend-db/library/Zend/Db/Statement.php

Line 198 in 475addb

$sql = preg_replace("/$q([^$q{$escapeChar}]*|($qe)*)*$q/s", '', $sql);

after_replace.txt

Solution is to add an null check and return an empty string on line 211

[RetroProgrammist]

magento-zend-db/library/Zend/Db/Statement.php

Line 222 in 475addb

$sql = preg_replace("/$d($de|\\\\{2}|[^$d])*$d/Us", '', $sql);

Relevant, this line is receiving an error Deprecated Functionality: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/html/vendor/magento/zend-db/library/Zend/Db/Statement.php on line 222

[thecodecook14]

Pushed a fix of this issue here #3