|
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 |