/ Check-in [e82f235e]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Fix repeated test numbers in the altertab2.test file.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: e82f235e7201a420149847cda630ac6f2fce5e3a4577b0ea4793f430d3dc1611
User & Date: drh 2019-06-11 01:56:42
Context
2019-06-11
02:43
The ALTER TABLE command should not attempt to rename objects that are contained within an expression tree that has been optimized out because it is the other branch of an "AND false" expression. Ticket [533010b8cacebe82] check-in: 04bd5cb7 user: drh tags: trunk
01:56
Fix repeated test numbers in the altertab2.test file. check-in: e82f235e user: drh tags: trunk
01:30
Remove a comment made obsolete by check-in [71643deb6bbad4b4]. No changes to code. check-in: 211c8002 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/altertab2.test.

   334    334   do_catchsql_test 8.2 {
   335    335     ALTER TABLE t1 RENAME a TO aaa;
   336    336   } {1 {error in trigger tr after rename: no such column: a}}
   337    337   do_execsql_test 8.3 {
   338    338     INSERT INTO t3 VALUES(4, 5, 6);
   339    339   }
   340    340   
   341         -do_execsql_test 8.1 {
          341  +do_execsql_test 8.4 {
   342    342     CREATE TABLE t4(a, b);
   343    343     CREATE VIEW v4 AS SELECT * FROM t4 WHERE (a=1 AND 0) OR b=2;
   344    344   }
   345         -do_execsql_test 8.2 {
          345  +do_execsql_test 8.5 {
   346    346     ALTER TABLE t4 RENAME a TO c;
   347    347     SELECT sql FROM sqlite_master WHERE name = 'v4'
   348    348   } {{CREATE VIEW v4 AS SELECT * FROM t4 WHERE (c=1 AND 0) OR b=2}}
   349    349   
   350    350   finish_test
   351         -
   352         -