Return to tkt3810.test CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test

sqlite3

    1: # 2009 August 1
    2: #
    3: # The author disclaims copyright to this source code.  In place of
    4: # a legal notice, here is a blessing:
    5: #
    6: #    May you do good and not evil.
    7: #    May you find forgiveness for yourself and forgive others.
    8: #    May you share freely, never taking more than you give.
    9: #
   10: #***********************************************************************
   11: #
   12: # Tests to make sure #3810 is fixed.
   13: #
   14: # $Id: tkt3810.test,v 1.1.1.1 2012/02/21 17:04:16 misho Exp $
   15: 
   16: set testdir [file dirname $argv0]
   17: source $testdir/tester.tcl
   18: ifcapable {!trigger} {
   19:   finish_test
   20:   return
   21: }
   22: 
   23: # Create a table using the first database connection.
   24: #
   25: do_test tkt3810-1.1 {
   26:   execsql {
   27:     CREATE TABLE t1(x);
   28:     INSERT INTO t1 VALUES(123);
   29:     SELECT * FROM t1;
   30:     CREATE TABLE t2(y);
   31:     CREATE TABLE t3(z);
   32:   }
   33: } 123
   34: 
   35: # Create a second connection to the same database.  Make sure the
   36: # schema of the database has been parsed by the second connection.
   37: #
   38: do_test tkt3810-2 {
   39:   sqlite3 db2 test.db
   40:   execsql {
   41:     SELECT * FROM t1;
   42:   } db2
   43: } 123
   44: 
   45: # DROP the table using the second connection.  The table no longer exists
   46: # but the first connection does not yet know this.  Then try to create a TEMP
   47: # trigger in the first connection that references the table that was dropped.
   48: #
   49: do_test tkt3810-3 {
   50:   execsql {DROP TABLE t1} db2
   51:   execsql {
   52:      CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
   53:        INSERT INTO t2 VALUES(new.rowid);
   54:      END;
   55:   }
   56:   catchsql {
   57:     SELECT * FROM t3;
   58:   }
   59: } {0 {}}
   60: 
   61: # Trigger still exists in the sqlite_temp_master table, but now it is
   62: # an orphan.
   63: #
   64: do_test tkt3810-4 {
   65:   execsql {SELECT name FROM sqlite_temp_master ORDER BY name}
   66: } {r1}
   67: 
   68: # Because it is an orphan, it cannot be dropped.
   69: #
   70: do_test tkt3810-5 {
   71:   catchsql {DROP TRIGGER r1}
   72: } {1 {no such trigger: r1}}
   73: 
   74: # Create a table t1 then drop the table in order to drop the orphaned
   75: # trigger.
   76: #
   77: do_test tkt3810-6 {
   78:   execsql {CREATE TABLE t1(x)} db2
   79:   execsql {DROP TABLE t1}
   80:   execsql {
   81:     SELECT name FROM sqlite_temp_master;
   82:   }
   83: } {}
   84: 
   85: db2 close
   86: 
   87: finish_test