SQLite

Check-in [c7f2ed9f]
Login
Overview
Comment:Fix testcase misc7-16 so that it works with the new UNIQUE constraint error message format.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:c7f2ed9f44be3b66a542ee42c0db63bab8ffd2db
User & Date: drh 2013-11-16 12:56:46
Context
2013-11-16
13:55
Simplification and performance improvement to the logic that factors constant expressions ouf of inner loops. check-in: ee9353fd user: drh tags: trunk
12:56
Fix testcase misc7-16 so that it works with the new UNIQUE constraint error message format. check-in: c7f2ed9f user: drh tags: trunk
2013-11-15
18:58
Fix comments on the OP_Divide and OP_Remainder operators, especially the "Synopsis:" comment, so that they agree with the actual implementation. check-in: cc17f1f0 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/misc7.test.

351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
    BEGIN;
      PRAGMA cache_size = 10;
      INSERT INTO t3 VALUES( randstr(100, 100), randstr(100, 100) );
      UPDATE t3 SET a = b;
    COMMIT;
  }} msg]

  if {!$rc || ($rc && [string first "columns" $msg]==0)} {
    set msg
  } else {
    error $msg
  }
}

sqlite3 db test.db







|







351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
    BEGIN;
      PRAGMA cache_size = 10;
      INSERT INTO t3 VALUES( randstr(100, 100), randstr(100, 100) );
      UPDATE t3 SET a = b;
    COMMIT;
  }} msg]

  if {!$rc || ($rc && [string first "UNIQUE" $msg]==0)} {
    set msg
  } else {
    error $msg
  }
}

sqlite3 db test.db