Sqlite: Default column type to None

None has no type affinity. So it will not try to convert types to other
types like Numeric will do.

Change-Id: I5362a6d071459594619485b8b8a37b3f5ed12db6
Reviewed-by: Thomas Hartmann <[email protected]>

1 files changed, 12 insertions, 6 deletions

diff --git a/src/libs/sqlite/sqlstatementbuilder.cpp b/src/libs/sqlite/sqlstatementbuilder.cpp
index ecef170a346..7a6cc1a81a3 100644
--- a/src/libs/sqlite/sqlstatementbuilder.cpp
+++ b/src/libs/sqlite/sqlstatementbuilder.cpp
@@ -179,12 +179,18 @@ bool SqlStatementBuilder::isBuild() const
 Utils::SmallString SqlStatementBuilder::columnTypeToString(ColumnType columnType)
 {
     switch (columnType) {
-        case ColumnType::Numeric: return "NUMERIC";
-        case ColumnType::Integer: return "INTEGER";
-        case ColumnType::Real: return "REAL";
-        case ColumnType::Text: return "TEXT";
-        case ColumnType::Blob: return "BLOB";
-        case ColumnType::None: return {};
+    case ColumnType::Numeric:
+        return " NUMERIC";
+    case ColumnType::Integer:
+        return " INTEGER";
+    case ColumnType::Real:
+        return " REAL";
+    case ColumnType::Text:
+        return " TEXT";
+    case ColumnType::Blob:
+        return " BLOB";
+    case ColumnType::None:
+        return {};
     }
 
     Q_UNREACHABLE();