/ Check-in [9470e279]
Login

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

Overview
Comment:Add tests to ensure triggers cannot be created on virtual tables. (CVS 3273)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:9470e27962d2fe9c0d1921d9aab7d8f0047ac1fd
User & Date: danielk1977 2006-06-19 06:32:23
Context
2006-06-19
12:02
Avoid returning MISUSE when sqlite is called recursively by an xBestIndex callback. (CVS 3274) check-in: 4339e1bf user: danielk1977 tags: trunk
06:32
Add tests to ensure triggers cannot be created on virtual tables. (CVS 3273) check-in: 9470e279 user: danielk1977 tags: trunk
05:33
Respect default collation sequences assigned to virtual table columns. (CVS 3272) check-in: d9b205ac user: danielk1977 tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/vtab5.test.

6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
..
95
96
97
98
99
100
101
102
























103
104
#    May you do good and not evil.
#    May you find forgiveness for yourself and forgive others.
#    May you share freely, never taking more than you give.
#
#***********************************************************************
# This file implements regression tests for SQLite library.
#
# $Id: vtab5.test,v 1.3 2006/06/19 05:33:45 danielk1977 Exp $

set testdir [file dirname $argv0]
source $testdir/tester.tcl

ifcapable !vtab {
  finish_test
  return
................................................................................
  }
} {abc1 ABc2 Abc3 aBc4}
do_test vtab5.2.3 {
  execsql {
    SELECT str||'' FROM echo_strings ORDER BY 1;
  }
} {ABc2 Abc3 aBc4 abc1}

























finish_test








|







 








>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>


6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
..
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
#    May you do good and not evil.
#    May you find forgiveness for yourself and forgive others.
#    May you share freely, never taking more than you give.
#
#***********************************************************************
# This file implements regression tests for SQLite library.
#
# $Id: vtab5.test,v 1.4 2006/06/19 06:32:23 danielk1977 Exp $

set testdir [file dirname $argv0]
source $testdir/tester.tcl

ifcapable !vtab {
  finish_test
  return
................................................................................
  }
} {abc1 ABc2 Abc3 aBc4}
do_test vtab5.2.3 {
  execsql {
    SELECT str||'' FROM echo_strings ORDER BY 1;
  }
} {ABc2 Abc3 aBc4 abc1}

# Test that it is impossible to create a triggger on a virtual table.
#
do_test vtab5.3.1 {
  catchsql {
    CREATE TRIGGER trig INSTEAD OF INSERT ON echo_strings BEGIN
      SELECT 1, 2, 3;
    END;
  }
} {1 {cannot create triggers on virtual tables}}
do_test vtab5.3.2 {
  catchsql {
    CREATE TRIGGER trig AFTER INSERT ON echo_strings BEGIN
      SELECT 1, 2, 3;
    END;
  }
} {1 {cannot create triggers on virtual tables}}
do_test vtab5.3.2 {
  catchsql {
    CREATE TRIGGER trig BEFORE INSERT ON echo_strings BEGIN
      SELECT 1, 2, 3;
    END;
  }
} {1 {cannot create triggers on virtual tables}}

finish_test