AryaWu/sqlite

1# 2009 October 132#3# The author disclaims copyright to this source code.  In place of4# 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# This file implements regression tests for SQLite library.12#13# This file implements tests to verify that ticket [5ee23731f15] has been14# fixed.  15#16 17set testdir [file dirname $argv0]18source $testdir/tester.tcl19 20do_test tkt-5ee237-1.1 {21  db close22  forcedelete test.db23  sqlite3 db test.db24  db eval {25    CREATE TABLE t1(x UNIQUE);26    INSERT INTO t1 VALUES(1);27    INSERT INTO t1 VALUES(2);28    INSERT INTO t1 SELECT x+2 FROM t1;29    INSERT INTO t1 SELECT x+4 FROM t1;30    INSERT INTO t1 SELECT x+8 FROM t1;31  }32  db close33  sqlite3 db test.db -readonly 134  set rc [catch {35    db eval {SELECT rowid, x FROM t1 ORDER BY x} {36      db eval {UPDATE t1 SET x=x+1 WHERE rowid=:rowid}37    }38  } msg]39  lappend rc $msg40} {1 {attempt to write a readonly database}}41 42finish_test43