← Back to branch summary

~ubuntu-branches/ubuntu/hardy/sqlite3/hardy

« back to all changes in this revision

Viewing changes to test/trigger1.test

  • Committer: Bazaar Package Importer
  • Author(s): Laszlo Boszormenyi (GCS)
  • Date: 2007-05-17 02:01:42 UTC
  • mfrom: (1.1.8 upstream) (3.1.1 etch)
  • Revision ID: james.westby@ubuntu.com-20070517020142-o79d5uduuhfbtknv
Tags: 3.3.17-1
http://bugs.debian.org/424235
* New upstream release.
* Use minor version as well in sqlite3.pc (closes: #424235).

Show diffs side-by-side

added added

removed removed

Lines of Context:
test/trigger1.test
55
55
execsql {
56
56
    CREATE TABLE t1(a);
57
57
}
 
58
do_test trigger1-1.1.3 {
 
59
  catchsql {
 
60
     CREATE TRIGGER trig UPDATE ON t1 FOR EACH STATEMENT BEGIN
 
61
        SELECT * FROM sqlite_master;
 
62
     END;
 
63
  }
 
64
} {1 {near "STATEMENT": syntax error}}
58
65
execsql {
59
66
        CREATE TRIGGER tr1 INSERT ON t1 BEGIN
60
67
          INSERT INTO t1 values(1);