3 files changed, 13 insertions, 7 deletions
diff --git a/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqlitecreatetable.cpp b/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqlitecreatetable.cpp
index 454c0e3..d21578e 100644
--- a/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqlitecreatetable.cpp
+++ b/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqlitecreatetable.cpp
@@ -640,8 +640,8 @@ SqliteCreateTable::Column::Column(const QString &name, SqliteColumnType *type, c
             this->constraints.last()->type != SqliteCreateTable::Column::Constraint::NAME_ONLY)
         {
             SqliteCreateTable::Column::Constraint* last = this->constraints.last();
-            last->deferrable = constr->deferrable;
-            last->initially = constr->initially;
+            last->foreignKey->deferrable = constr->deferrable;
+            last->foreignKey->initially = constr->initially;
             delete constr;
 
             // We don't want deleted constr to be added to list. We finish this now.
diff --git a/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqlitecreatetable.h b/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqlitecreatetable.h
index f3be244..877d0fa 100644
--- a/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqlitecreatetable.h
+++ b/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqlitecreatetable.h
@@ -21,6 +21,8 @@ class API_EXPORT SqliteCreateTable : public SqliteQuery
             public:
                 class API_EXPORT Constraint : public SqliteStatement
                 {
+                    friend class Column;
+
                     public:
                         enum Type
                         {
@@ -70,11 +72,14 @@ class API_EXPORT SqliteCreateTable : public SqliteQuery
                         QString id;
                         QString collationName = QString::null;
                         SqliteForeignKey* foreignKey = nullptr;
-                        SqliteDeferrable deferrable = SqliteDeferrable::null;
-                        SqliteInitially initially = SqliteInitially::null;
 
                     protected:
                         TokenList rebuildTokensFromContents();
+
+                    private:
+                        SqliteDeferrable deferrable = SqliteDeferrable::null; // only a temporary field for parse time, before merging with actual FK
+                        SqliteInitially initially = SqliteInitially::null; // only a temporary field for parse time, before merging with actual FK
+
                 };
 
                 typedef QSharedPointer<Constraint> ConstraintPtr;
diff --git a/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqliteexpr.cpp b/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqliteexpr.cpp
index 1429cef..12adf80 100644
--- a/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqliteexpr.cpp
+++ b/SQLiteStudio3/coreSQLiteStudio/parser/ast/sqliteexpr.cpp
@@ -65,11 +65,12 @@ QString SqliteExpr::likeOp(SqliteExpr::LikeOp value)
 
 SqliteExpr::NotNull SqliteExpr::notNullOp(const QString &value)
 {
-    if (value == "ISNULL")
+    QString upper = value.toUpper();
+    if (upper == "ISNULL")
         return SqliteExpr::NotNull::ISNULL;
-    else if (value == "NOTNULL")
+    else if (upper == "NOTNULL")
         return SqliteExpr::NotNull::NOTNULL;
-    else if (value == "NOT NULL")
+    else if (upper == "NOT NULL")
         return SqliteExpr::NotNull::NOT_NULL;
     else
         return SqliteExpr::NotNull::null;