SQL/MySQL: retrieve default column value for QSqlDatabase::record()

Retrieve the default value (if set) of a column during
QSqlDatabase::record() but not for QSqlQuery::record() as it's done for
the other drivers which support retrieving the default column value.

Fixes: QTBUG-122723
Change-Id: I92e052bfa6d88e019c0151fbcbc1483a65770c55
Reviewed-by: Axel Spoerl <axel.spoerl@qt.io>

1 files changed, 9 insertions, 2 deletions

diff --git a/tests/auto/sql/kernel/qsqldriver/tst_qsqldriver.cpp b/tests/auto/sql/kernel/qsqldriver/tst_qsqldriver.cpp
index 2947fb7040..fb8d804843 100644
--- a/tests/auto/sql/kernel/qsqldriver/tst_qsqldriver.cpp
+++ b/tests/auto/sql/kernel/qsqldriver/tst_qsqldriver.cpp
@@ -35,6 +35,7 @@ static bool driverSupportsDefaultValues(QSqlDriver::DbmsType dbType)
     case QSqlDriver::SQLite:
     case QSqlDriver::PostgreSQL:
     case QSqlDriver::Oracle:
+    case QSqlDriver::MySqlServer:
         return true;
     default:
         break;
@@ -132,8 +133,14 @@ void tst_QSqlDriver::record()
     for (int i = 0; i < fields.size(); ++i)
         QCOMPARE(rec.fieldName(i), fields[i]);
 
-    if (driverSupportsDefaultValues(dbType))
-        QCOMPARE(rec.field(QStringLiteral("name")).defaultValue().toString(), QStringLiteral("defaultVal"));
+    if (driverSupportsDefaultValues(dbType)) {
+        auto defVal = rec.field(QStringLiteral("name")).defaultValue().toString();
+        if (dbType == QSqlDriver::MySqlServer && defVal.startsWith('\'') && defVal.endsWith('\'')) {
+            qDebug() << "MariaDB 10.6 default string value is escaped:" << defVal;
+            defVal = defVal.mid(1, defVal.size() - 2);
+        }
+        QCOMPARE(defVal, QStringLiteral("defaultVal"));
+    }
 
     if (dbType == QSqlDriver::Oracle || dbType == QSqlDriver::DB2)
         tablename = tablename.toUpper();