Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add a test case to show that 29ab7be99f is fixed. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
135d656a20a2a450955ed9ec57d9637c |
| User & Date: | dan 2009-09-09 11:43:44.000 |
Context
|
2009-09-09
| ||
| 12:41 | Increase the size of bitvec objects to 1024 bytes on 64-bit systems. (check-in: f1272b90f6 user: drh tags: trunk) | |
| 11:43 | Add a test case to show that 29ab7be99f is fixed. (check-in: 135d656a20 user: dan tags: trunk) | |
| 11:37 | Add a complicated assert() to check that statement transactions are opened when required. (check-in: 28aa1f4ea8 user: dan tags: trunk) | |
Changes
Changes to test/notnull.test.
| ︙ | ︙ | |||
497 498 499 500 501 502 503 504 505 |
catchsql {
DELETE FROM t1;
INSERT INTO t1 VALUES(1,2,3,4,5);
UPDATE t1 SET e=null, a=b, b=a;
SELECT * FROM t1 ORDER BY a;
}
} {1 {t1.e may not be NULL}}
finish_test
| > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 |
catchsql {
DELETE FROM t1;
INSERT INTO t1 VALUES(1,2,3,4,5);
UPDATE t1 SET e=null, a=b, b=a;
SELECT * FROM t1 ORDER BY a;
}
} {1 {t1.e may not be NULL}}
# Test that bug 29ab7be99f is fixed.
#
do_test notnull-5.1 {
execsql {
DROP TABLE IF EXISTS t1;
CREATE TABLE t1(a, b NOT NULL);
CREATE TABLE t2(c, d);
INSERT INTO t2 VALUES(3, 4);
INSERT INTO t2 VALUES(5, NULL);
}
} {}
do_test notnull-5.2 {
catchsql {
INSERT INTO t1 VALUES(1, 2);
INSERT INTO t1 SELECT * FROM t2;
}
} {1 {t1.b may not be NULL}}
do_test notnull-5.3 {
execsql { SELECT * FROM t1 }
} {1 2}
do_test notnull-5.4 {
catchsql {
DELETE FROM t1;
BEGIN;
INSERT INTO t1 VALUES(1, 2);
INSERT INTO t1 SELECT * FROM t2;
COMMIT;
}
} {1 {t1.b may not be NULL}}
do_test notnull-5.5 {
execsql { SELECT * FROM t1 }
} {1 2}
finish_test
|