Lines 49-55
Link Here
|
49 |
# column (3) does not correspond to row in the artist table. |
49 |
# column (3) does not correspond to row in the artist table. |
50 |
|
50 |
|
51 |
ok !insert_track(14, "Mr. Bojangles", 3); |
51 |
ok !insert_track(14, "Mr. Bojangles", 3); |
52 |
ok $@ =~ qr/foreign key constraint failed/; |
52 |
ok $@ =~ qr/foreign key constraint failed/i; |
53 |
|
53 |
|
54 |
# This succeeds because a NULL is inserted into trackartist. A |
54 |
# This succeeds because a NULL is inserted into trackartist. A |
55 |
# corresponding row in the artist table is not required in this case. |
55 |
# corresponding row in the artist table is not required in this case. |
Lines 62-68
Link Here
|
62 |
# artist table. |
62 |
# artist table. |
63 |
|
63 |
|
64 |
ok !update_track(3, "Mr. Bojangles"); |
64 |
ok !update_track(3, "Mr. Bojangles"); |
65 |
ok $@ =~ /foreign key constraint failed/; |
65 |
ok $@ =~ /foreign key constraint failed/i; |
66 |
|
66 |
|
67 |
# Insert the required row into the artist table. It is then possible |
67 |
# Insert the required row into the artist table. It is then possible |
68 |
# to update the inserted row to set trackartist to 3 (since a |
68 |
# to update the inserted row to set trackartist to 3 (since a |