/ Check-in [f29d194e]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add a test case for OP_SoftNull.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | insert-optimization
Files: files | file ages | folders
SHA1:f29d194e03d6bcc78bf883b77e591dbccada02f0
User & Date: drh 2014-02-17 15:40:19
Context
2014-02-17
22:40
Add logic to do test coverage measurements on the VDBE code. Closed-Leaf check-in: ce184c7b user: drh tags: insert-optimization
15:40
Add a test case for OP_SoftNull. check-in: f29d194e user: drh tags: insert-optimization
15:36
Merge the VDBE_PROFILE fixes from trunk. check-in: 2914e419 user: drh tags: insert-optimization
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/insert.test.

   398    398     } {1 2 3 4 5 6 7 8 9}
   399    399     do_test insert-10.2 {
   400    400       catchsql {
   401    401         INSERT INTO t10 VALUES(11,12,13), (14,15), (16,17,28);
   402    402       }
   403    403     } {1 {all VALUES must have the same number of terms}}
   404    404   }
          405  +
          406  +# Need for the OP_SoftNull opcode
          407  +#
          408  +do_execsql_test insert-11.1 {
          409  +  CREATE TABLE t11a AS SELECT '123456789' AS x;
          410  +  CREATE TABLE t11b (a INTEGER PRIMARY KEY, b, c);
          411  +  INSERT INTO t11b SELECT x, x, x FROM t11a;
          412  +  SELECT quote(a), quote(b), quote(c) FROM t11b;
          413  +} {123456789 '123456789' '123456789'}
          414  +
   405    415   
   406    416   integrity_check insert-99.0
   407    417   
   408    418   finish_test