SQLite

All files named ”test/unique.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/unique.test

2013-11-05
13:33
[93f8b2ef5e] part of check-in [54b2219297] Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 6210)
01:59
[196505faa9] part of check-in [294ed33756] Add the conflict2.test script. Fix issues discovered by this script. (check-in: [294ed33756] user: drh branch: omit-rowid, size: 6157)
2013-02-09
15:37
[cadb172bbd] part of check-in [3f67437536] Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes. (check-in: [3f67437536] user: drh branch: constraint-error-codes, size: 6149)
2009-05-02
15:46
[083c7fff74] part of check-in [8f3cac7682] Simplifications to the uniqueness constraint failure error message generation code. (CVS 6595) (check-in: [8f3cac7682] user: drh branch: trunk, size: 5762)
2005-06-24
03:53
[0253c4227a] part of check-in [06a71b162b] NULL values in a row of a unique index cause the row to be distinct. Ticket #1301. More testing and optimization needs to be done on this before closing the ticket. (CVS 2526) (check-in: [06a71b162b] user: drh branch: trunk, size: 5738)
2003-08-05
13:13
[0e38d4cc7a] part of check-in [086aa1c992] Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) (check-in: [086aa1c992] user: drh branch: trunk, size: 5191)
2003-06-15
23:42
[426580d01a] part of check-in [c9734c2707] Enhance the "PRAGMA integrity_check" command to verify that all indices are correctly constructed. New calls to integrity_check are made in the test suite. These changes are intended to prevent any future problems such as seen in ticket #334. (CVS 1024) (check-in: [c9734c2707] user: drh branch: trunk, size: 4200)
2003-01-29
18:46
[22a46df72a] part of check-in [ccc82f1ab4] Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) (check-in: [ccc82f1ab4] user: drh branch: trunk, size: 4092)
2002-05-26
20:54
[572aa79132] part of check-in [9051173742] NULL values are distinct. A comparison involving a NULL is always false. Operations on a NULL value yield a NULL result. This change makes SQLite operate more like the SQL spec, but it may break existing applications that assumed the old behavior. All the old tests pass but we still need to add new tests to better verify the new behavior. Fix for ticket #44. (CVS 589) (check-in: [9051173742] user: drh branch: trunk, size: 4035)
2001-12-21
14:30
[07776624b8] part of check-in [236a54d289] Added support for the INTEGER PRIMARY KEY column type. (CVS 333) (check-in: [236a54d289] user: drh branch: trunk, size: 3408)
2001-09-27
23:57
[ef1f67607a] part of check-in [3ae9529339] Added more tests of unique indices. (CVS 270) (check-in: [3ae9529339] user: drh branch: trunk, size: 3231)
15:11
Added: [23056f0705] part of check-in [116fdad068] Fixed the support of UNIQUE and PRIMARY KEY. (CVS 268) (check-in: [116fdad068] user: drh branch: trunk, size: 940)