Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix some mappings from e_fkey.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 171c67138527750ec4af403f05389fae |
| User & Date: | dan 2009-10-12 16:02:10 |
Context
|
2009-10-12
| ||
| 18:57 | Add more test cases to e_fkey.test. check-in: 5633cb2b user: dan tags: trunk | |
| 16:02 | Fix some mappings from e_fkey.test. check-in: 171c6713 user: dan tags: trunk | |
| 15:25 | Update e_fkey.test to match the latest version of foreignkeys.html. check-in: a2ca9f1a user: dan tags: trunk | |
Changes
Changes to test/e_fkey.test.
381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 ... 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 ... 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 ... 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 .... 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 |
}
} {}
do_test e_fkey-48.2 {
catchsql { INSERT INTO track VALUES(14, 'Mr. Bojangles', NULL) }
} {1 {track.trackartist may not be NULL}}
#-------------------------------------------------------------------------
# /* EV: R-01991-24099 */
#
# Test an example from foreignkeys.html.
#
drop_all_tables
do_test e_fkey-43.1 {
execsql {
CREATE TABLE artist(
................................................................................
INSERT INTO artist VALUES(3, 'Sammy Davis Jr.');
UPDATE track SET trackartist = 3 WHERE trackname = 'Mr. Bojangles';
INSERT INTO track VALUES(15, 'Boogie Woogie', 3);
}
} {}
#-------------------------------------------------------------------------
# /* EV: R-22377-02546 */
#
# Test the second example from the first section of foreignkeys.html.
#
do_test e_fkey-44.1 {
catchsql {
DELETE FROM artist WHERE artistname = 'Frank Sinatra';
}
................................................................................
###########################################################################
###########################################################################
### SECTION 4.1: Composite Foreign Key Constraints
###########################################################################
#-------------------------------------------------------------------------
# /* EV: R-56396-15644 */
#
# Test the example schema in the "Composite Foreign Key Constraints"
# section.
#
do_test e_fkey-36.1 {
execsql {
CREATE TABLE album(
................................................................................
test_efkey_29 31 "UPDATE c5 SET a = 10" 1
test_efkey_29 31 "UPDATE c6 SET a = 10" 1
test_efkey_29 31 "UPDATE c7 SET a = 10" 0
test_efkey_29 32 "COMMIT" 1
test_efkey_29 33 "ROLLBACK" 0
#-------------------------------------------------------------------------
# /* EV: R-27340-26081 */
#
# Test an example from foreignkeys.html dealing with a deferred foreign
# key constraint.
#
do_test e_fkey-28.1 {
drop_all_tables
execsql {
................................................................................
execsql { SELECT * FROM artist }
} {0 {Unknown Artist}}
do_test e_fkey-14.5 {
execsql { SELECT * FROM track }
} {14 {Mr. Bojangles} 0}
#-------------------------------------------------------------------------
# /* EV: R-35762-30306 */
#
# Check that the order of steps in an UPDATE or DELETE on a parent
# table is as follows:
#
# 1. Execute applicable BEFORE trigger programs,
# 2. Check local (non foreign key) constraints,
# 3. Update or delete the row in the parent table,
|
| | | | | |
381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 ... 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 ... 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 ... 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 .... 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 |
}
} {}
do_test e_fkey-48.2 {
catchsql { INSERT INTO track VALUES(14, 'Mr. Bojangles', NULL) }
} {1 {track.trackartist may not be NULL}}
#-------------------------------------------------------------------------
# /* EV: R-17902-59250 */
#
# Test an example from foreignkeys.html.
#
drop_all_tables
do_test e_fkey-43.1 {
execsql {
CREATE TABLE artist(
................................................................................
INSERT INTO artist VALUES(3, 'Sammy Davis Jr.');
UPDATE track SET trackartist = 3 WHERE trackname = 'Mr. Bojangles';
INSERT INTO track VALUES(15, 'Boogie Woogie', 3);
}
} {}
#-------------------------------------------------------------------------
# /* EV: R-15034-64331 */
#
# Test the second example from the first section of foreignkeys.html.
#
do_test e_fkey-44.1 {
catchsql {
DELETE FROM artist WHERE artistname = 'Frank Sinatra';
}
................................................................................
###########################################################################
###########################################################################
### SECTION 4.1: Composite Foreign Key Constraints
###########################################################################
#-------------------------------------------------------------------------
# /* EV: R-24676-09859 */
#
# Test the example schema in the "Composite Foreign Key Constraints"
# section.
#
do_test e_fkey-36.1 {
execsql {
CREATE TABLE album(
................................................................................
test_efkey_29 31 "UPDATE c5 SET a = 10" 1
test_efkey_29 31 "UPDATE c6 SET a = 10" 1
test_efkey_29 31 "UPDATE c7 SET a = 10" 0
test_efkey_29 32 "COMMIT" 1
test_efkey_29 33 "ROLLBACK" 0
#-------------------------------------------------------------------------
# /* EV: R-35043-01546 */
#
# Test an example from foreignkeys.html dealing with a deferred foreign
# key constraint.
#
do_test e_fkey-28.1 {
drop_all_tables
execsql {
................................................................................
execsql { SELECT * FROM artist }
} {0 {Unknown Artist}}
do_test e_fkey-14.5 {
execsql { SELECT * FROM track }
} {14 {Mr. Bojangles} 0}
#-------------------------------------------------------------------------
# /* EV: R-09564-22170 */
#
# Check that the order of steps in an UPDATE or DELETE on a parent
# table is as follows:
#
# 1. Execute applicable BEFORE trigger programs,
# 2. Check local (non foreign key) constraints,
# 3. Update or delete the row in the parent table,
|