Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add markings on test evidence for R-30323-21917. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
e51af74c3aeb82604841cc83a490351d |
| User & Date: | drh 2009-10-22 00:20:18.000 |
Context
|
2009-10-22
| ||
| 17:30 | Updated shell to output blobs in X'1234' form when in "insert" mode. Ticket [72adc99de9]. (check-in: a2ad9e6363 user: shane tags: trunk) | |
| 00:20 | Add markings on test evidence for R-30323-21917. (check-in: e51af74c3a user: drh tags: trunk) | |
| 00:14 | Mention the sqlite3_column_count() function on the same documentation page with all of the other sqlite3_column... interfaces. (check-in: 5354ace55f user: drh tags: trunk) | |
Changes
Changes to test/e_fkey.test.
| ︙ | ︙ | |||
1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 |
# DEFERRABLE INITIALLY IMMEDIATE
# DEFERRABLE
#
# /* EV: R-35290-16460 */
#
# Foreign keys are IMMEDIATE by default (if there is no DEFERRABLE or NOT
# DEFERRABLE clause).
#
drop_all_tables
do_test e_fkey-29.1 {
execsql {
CREATE TABLE parent(x, y, z, PRIMARY KEY(x,y,z));
CREATE TABLE c1(a, b, c,
FOREIGN KEY(a, b, c) REFERENCES parent NOT DEFERRABLE INITIALLY DEFERRED
| > > | 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 |
# DEFERRABLE INITIALLY IMMEDIATE
# DEFERRABLE
#
# /* EV: R-35290-16460 */
#
# Foreign keys are IMMEDIATE by default (if there is no DEFERRABLE or NOT
# DEFERRABLE clause).
#
# /* EV: R-30323-21917 */ FKs are either IMMEDIATE or DEFERRED.
#
drop_all_tables
do_test e_fkey-29.1 {
execsql {
CREATE TABLE parent(x, y, z, PRIMARY KEY(x,y,z));
CREATE TABLE c1(a, b, c,
FOREIGN KEY(a, b, c) REFERENCES parent NOT DEFERRABLE INITIALLY DEFERRED
|
| ︙ | ︙ |