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: | 9470e27962d2fe9c0d1921d9aab7d8f0 |
| 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
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 |