fix: cast numbers in DataTypes.STRING to strings (#17564)

WikiRik · web-flow · commit fce5ad34fb70 · 2024-10-25T11:29:07.000+02:00
diff --git a/src/dialects/abstract/query-generator.js b/src/dialects/abstract/query-generator.js
@@ -1104,6 +1104,12 @@ class QueryGenerator {
         return this.handleSequelizeMethod(value);
       }
       if (field && field.type) {
+        if (field.type instanceof DataTypes.STRING
+            && ['mysql', 'mariadb'].includes(this.dialect)
+            && ['number', 'boolean'].includes(typeof value)) {
+          value = String(Number(value));
+        }
+              
         this.validate(value, field, options);
 
         if (field.type.stringify) {
