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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
e899b058a703158012c054974bd9a909 |
| User & Date: | dan 2013-03-09 14:49:07 |
Context
|
2013-03-11
| ||
| 11:57 | Fixes for compiling with SQLITE_OMIT_AUTOVACUUM and/or SQLITE_OMIT_TRIGGER defined. check-in: 1da15adb user: dan tags: trunk | |
| 11:49 | Fixes for compiling with SQLITE_OMIT_AUTOVACUUM and/or SQLITE_OMIT_TRIGGER defined. Closed-Leaf check-in: 938b91e8 user: dan tags: omit-fixes | |
| 01:23 | Add experimental tointeger() and todouble() SQL functions. check-in: 465fd853 user: mistachkin tags: toTypeFuncs | |
|
2013-03-09
| ||
| 14:49 | Add a test case for the problem fixed by the previous commit. check-in: e899b058 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: ddee56c9 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..."
|