/ Check-in [0bbceebb]
Login

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

Overview
Comment:Add extra test case for one of the problems fixed by the previous commit.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 0bbceebb126c94b5159079a341fa16e8424b7f2f6b9364561516964e871fb6e0
User & Date: dan 2019-06-15 15:27:37
Context
2019-06-15
15:32
Fix minor problems in the test code in test_demovfs.c. check-in: ca4ddfef user: dan tags: trunk
15:27
Add extra test case for one of the problems fixed by the previous commit. check-in: 0bbceebb user: dan tags: trunk
15:21
Ensure that sqlite3RenameExprUnmap() does an unmap of the result set alias names in subqueries when ALTER TABLE fails because of a syntax error in a trigger. check-in: d3b6f166 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/altertab3.test.

   210    210   reset_db
   211    211   do_execsql_test 9.1 {
   212    212     CREATE TABLE t1(a,b,c);
   213    213     CREATE TRIGGER AFTER INSERT ON t1 WHEN new.a NOT NULL BEGIN
   214    214       SELECT true WHERE (SELECT a, b FROM (t1)) IN ();
   215    215     END;
   216    216   }
   217         -
   218    217   do_execsql_test 9.2 {
   219    218     ALTER TABLE t1 RENAME TO t1x;
   220    219   }
          220  +
          221  +#-------------------------------------------------------------------------
          222  +reset_db
          223  +do_execsql_test 10.1 {
          224  +  CREATE TABLE t1(a, b, c);
          225  +  CREATE TABLE t2(a, b, c);
          226  +  CREATE VIEW v1 AS SELECT * FROM t1 WHERE (
          227  +    SELECT t1.a FROM t1, t2
          228  +  ) IN () OR t1.a=5;
          229  +}
          230  +
          231  +do_execsql_test 10.2 {
          232  +  ALTER TABLE t2 RENAME TO t3;
          233  +  SELECT sql FROM sqlite_master WHERE name='v1';
          234  +} {
          235  +  {CREATE VIEW v1 AS SELECT * FROM t1 WHERE (
          236  +    SELECT t1.a FROM t1, t2
          237  +  ) IN () OR t1.a=5}
          238  +}
   221    239   
   222    240   
   223    241   finish_test