1 files changed, 10 insertions, 0 deletions
diff --git a/test/insert.test b/test/insert.test
index 83168122a..776bce114 100644
--- a/test/insert.test
+++ b/test/insert.test
@@ -403,6 +403,16 @@ ifcapable compound {
   } {1 {all VALUES must have the same number of terms}}
 }
 
+# Need for the OP_SoftNull opcode
+#
+do_execsql_test insert-11.1 {
+  CREATE TABLE t11a AS SELECT '123456789' AS x;
+  CREATE TABLE t11b (a INTEGER PRIMARY KEY, b, c);
+  INSERT INTO t11b SELECT x, x, x FROM t11a;
+  SELECT quote(a), quote(b), quote(c) FROM t11b;
+} {123456789 '123456789' '123456789'}
+
+
 integrity_check insert-99.0
 
 finish_test