SQLite

View Ticket
Login
Ticket Hash: 3c9eadd2a6ba0aa575c6ba6cbaac2e4799031175
Title: PRAGMA integrity_check fails due to CHECK constraint even without records
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-03-11 19:56:35
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-11-03 10:06:22:

Unexpectedly, the integrity_check fails in the following case:

CREATE TABLE t0(c0 CHECK(ABS(-9223372036854775808)));
PRAGMA integrity_check; -- unexpected: integer overflow

This is probably a minor issue that might not be worth fixing.


drh added on 2019-12-02 11:15:03:

This is difficult to fix and perhaps not worth fixing.

We will leave the ticket open for the time being as a record of the problem, but we do not anticipate fixing it right away.