Add NOT NULL column without default value initially as NULL

1 files changed, 5 insertions, 4 deletions

diff --git a/evolution/alter-column/model.hxx b/evolution/alter-column/model.hxx
index c244eb0..0b31e1c 100644
--- a/evolution/alter-column/model.hxx
+++ b/evolution/alter-column/model.hxx
@@ -30,9 +30,6 @@ namespace MODEL_NAMESPACE(MODEL_VERSION)
     odb::nullable<std::string> str;
 
     unsigned long num;
-
-    #pragma db null
-    unsigned long dummy; // Test multiple ALTER COLUMN clauses.
 #else
     // Use nullable to be able to access during migration.
     //
@@ -41,7 +38,11 @@ namespace MODEL_NAMESPACE(MODEL_VERSION)
 
     odb::nullable<unsigned long> num;
 
-    unsigned long dummy;
+    // Test adding NOT NULL column. It should be added NULL in pre
+    // and then converted to NOT NULL in post.
+    //
+    #pragma db not_null
+    odb::nullable<unsigned long> num1;
 #endif
   };
 }