Add NOT NULL column without default value initially as NULL

1 files changed, 15 insertions, 0 deletions

diff --git a/evolution/alter-column/driver.cxx b/evolution/alter-column/driver.cxx
index 28e6e7c..193289f 100644
--- a/evolution/alter-column/driver.cxx
+++ b/evolution/alter-column/driver.cxx
@@ -63,11 +63,13 @@ main (int argc, char* argv[])
 
           assert (!p->str);
           assert (p->num && *p->num == 123);
+          assert (!p->num1);
 
           // Migration.
           //
           p->str = "abc";
           p->num.reset ();
+          p->num1 = 123;
           db->update (*p);
 
           t.commit ();
@@ -93,12 +95,25 @@ main (int argc, char* argv[])
         try
         {
           object o2 (2);
+          o2.num1 = 234; // str is NULL
 
           transaction t (db->begin ());
           db->persist (o2);
           assert (false);
         }
         catch (const odb::exception& ) {}
+
+        try
+        {
+          object o3 (3);
+          o3.str = "bcd"; // num1 is NULL
+
+          transaction t (db->begin ());
+          db->persist (o3);
+          assert (false);
+        }
+        catch (const odb::exception& ) {}
+
         break;
       }
     default: