/ Check-in [65384ae0]
Login

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

Overview
Comment:Additional UPDATE test cases for WITHOUT ROWID.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | omit-rowid
Files: files | file ages | folders
SHA1: 65384ae0f027d05cf9208faed56575870d63c486
User & Date: drh 2013-11-01 18:14:36
Context
2013-11-01
20:30
Fix sqlite3_analyzer so that it works with WITHOUT ROWID tables. Fix index generation for secondary indices that include fields from the PRIMARY KEY. check-in: f9769d70 user: drh tags: omit-rowid
18:14
Additional UPDATE test cases for WITHOUT ROWID. check-in: 65384ae0 user: drh tags: omit-rowid
17:59
Fix an invalid cast operation in the WITHOUT ROWID parsing logic. check-in: 845153be user: drh tags: omit-rowid
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/without_rowid1.test.

    67     67   
    68     68   # UPDATE statements.
    69     69   #
    70     70   do_execsql_test without_rowid1-1.31 {
    71     71     UPDATE t1 SET d=3.1415926 WHERE a='journal';
    72     72     SELECT *, '|' FROM t1 ORDER BY c, a;
    73     73   } {arctic sleep ammonia helena | journal sherman ammonia 3.1415926 | dynamic phone flipper harvard | journal sherman gamma 3.1415926 |}
           74  +do_execsql_test without_rowid1-1.32 {
           75  +  SELECT *, '|' FROM t1 ORDER BY b, d;
           76  +} {dynamic phone flipper harvard | journal sherman ammonia 3.1415926 | journal sherman gamma 3.1415926 | arctic sleep ammonia helena |}
           77  +
           78  +do_execsql_test without_rowid1-1.35 {
           79  +  UPDATE t1 SET a=1250 WHERE b='phone';
           80  +  SELECT *, '|' FROM t1 ORDER BY c, a;
           81  +} {arctic sleep ammonia helena | journal sherman ammonia 3.1415926 | 1250 phone flipper harvard | journal sherman gamma 3.1415926 |}
           82  +integrity_check without_rowid1-1.36
           83  +
           84  +do_execsql_test without_rowid1-1.37 {
           85  +  SELECT *, '|' FROM t1 ORDER BY b, d;
           86  +} {1250 phone flipper harvard | journal sherman ammonia 3.1415926 | journal sherman gamma 3.1415926 | arctic sleep ammonia helena |}
           87  +
           88  +do_execsql_test without_rowid1-1.40 {
           89  +  VACUUM;
           90  +  SELECT *, '|' FROM t1 ORDER BY b, d;
           91  +} {1250 phone flipper harvard | journal sherman ammonia 3.1415926 | journal sherman gamma 3.1415926 | arctic sleep ammonia helena |}
           92  +integrity_check without_rowid1-1.41
           93  +
    74     94   
    75     95   finish_test