Modify CONCAT() arguments, because + operator requires them to be of type varchar (#1488505)

With SQL Server 2012 we can use just CONCAT(), but we need to support older versions

1 files changed, 5 insertions, 0 deletions

diff --git a/program/include/rcube_mdb2.php b/program/include/rcube_mdb2.php
index a255d9e6e..721963b4c 100644
--- a/program/include/rcube_mdb2.php
+++ b/program/include/rcube_mdb2.php
@@ -691,6 +691,11 @@ class rcube_mdb2
             case 'mssql':
             case 'sqlsrv':
                 $delim = ' + ';
+                // Modify arguments, because + operator requires them to be of type varchar (#1488505)
+                // with SQL Server 2012 we can use just CONCAT(), but we need to support older versions
+                foreach ($args as $idx => $arg) {
+                    $args[$idx] = "CAST($arg AS varchar)";
+                }
                 break;
             default:
                 $delim = ' || ';