Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add a test case for the problem fixed by the previous commit. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
e899b058a703158012c054974bd9a909 |
| User & Date: | dan 2013-03-09 14:49:07.597 |
Context
|
2013-03-11
| ||
| 11:57 | Fixes for compiling with SQLITE_OMIT_AUTOVACUUM and/or SQLITE_OMIT_TRIGGER defined. (check-in: 1da15adba8 user: dan tags: trunk) | |
| 11:49 | Fixes for compiling with SQLITE_OMIT_AUTOVACUUM and/or SQLITE_OMIT_TRIGGER defined. (Closed-Leaf check-in: 938b91e855 user: dan tags: omit-fixes) | |
| 01:23 | Add experimental tointeger() and todouble() SQL functions. (check-in: 465fd853d3 user: mistachkin tags: toTypeFuncs) | |
|
2013-03-09
| ||
| 14:49 | Add a test case for the problem fixed by the previous commit. (check-in: e899b058a7 user: dan tags: trunk) | |
| 14:40 | Fix a problem with resolving "db.view.column" references that appear in UPDATE or DELETE statements executed against views. (check-in: ddee56c9b2 user: dan tags: trunk) | |
Changes
Changes to test/triggerA.test.
| ︙ | ︙ | |||
186 187 188 189 190 191 192 193 194 195 196 197 198 199 |
db eval {
DELETE FROM result4;
CREATE TRIGGER r5u INSTEAD OF UPDATE ON v5 BEGIN
INSERT INTO result4(a,b,c,d) VALUES(old.x, old.b, new.x, new.b);
END;
UPDATE v5 SET b = b+9900000 WHERE x BETWEEN 3 AND 5;
SELECT * FROM result4 ORDER BY a;
}
} {3 305 3 9900305 4 404 4 9900404 5 504 5 9900504}
# Only run the reamining tests if memory debugging is turned on.
#
ifcapable !memdebug {
puts "Skipping triggerA malloc tests: not compiled with -DSQLITE_MEMDEBUG..."
| > > > > > > > | 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 |
db eval {
DELETE FROM result4;
CREATE TRIGGER r5u INSTEAD OF UPDATE ON v5 BEGIN
INSERT INTO result4(a,b,c,d) VALUES(old.x, old.b, new.x, new.b);
END;
UPDATE v5 SET b = b+9900000 WHERE x BETWEEN 3 AND 5;
SELECT * FROM result4 ORDER BY a;
}
} {3 305 3 9900305 4 404 4 9900404 5 504 5 9900504}
do_test triggerA-2.11 {
db eval {
DELETE FROM result4;
UPDATE v5 SET b = main.v5.b+9900000 WHERE main.v5.x BETWEEN 3 AND 5;
SELECT * FROM result4 ORDER BY a;
}
} {3 305 3 9900305 4 404 4 9900404 5 504 5 9900504}
# Only run the reamining tests if memory debugging is turned on.
#
ifcapable !memdebug {
puts "Skipping triggerA malloc tests: not compiled with -DSQLITE_MEMDEBUG..."
|
| ︙ | ︙ |