/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/null.test

2015-04-11
11:44
Do not assume an index contains unique entries unless it is declared UNIQUE and NOT NULL is specified for all columns. Fix for [7b4fee9f6c]. file: [0dcce4f0] check-in: [e3b1f625] user: dan branch: trunk, size: 7103
2007-12-13
07:58
Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622) file: [a8b09b8e] check-in: [2f88b9b3] user: danielk1977 branch: trunk, size: 6649
03:45
ORDER BY in a compound SELECT will first match against the left-most SELECT. If there is no match there, it begins working its way to the right. (CVS 4621) file: [6adcb4ef] check-in: [56063ec8] user: drh branch: trunk, size: 6529
02:45
Towards getting ORDER BY to match against the correctin columns. This version only looks at the left-most column in a compound SELECT. That is the correct thing to do, but not what SQLite has historically done. (CVS 4620) file: [93e48033] check-in: [bbddf16a] user: drh branch: trunk, size: 5992
2006-01-17
09:35
Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [9503e1f6] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 5635
2006-01-12
22:17
Add support for the TOTAL() aggregate function - works like SUM() except that it returns 0 instead of NULL when presented with an empty list. (CVS 2930) file: [db52272f] check-in: [a7f528ff] user: drh branch: trunk, size: 5574
2005-09-08
10:37
The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) file: [012fe545] check-in: [21adf4bd] user: drh branch: trunk, size: 5406
2005-01-21
03:12
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [69c62daf] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 5410
2004-11-22
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [5a945790] check-in: [007be591] user: danielk1977 branch: trunk, size: 5344
2004-08-20
18:34
Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [642428b6] check-in: [e97c3313] user: drh branch: trunk, size: 5299
2004-07-18
21:14
Min() and max() ignore NULL values. Ticket #800. (CVS 1803) file: [675e6823] check-in: [223521c0] user: drh branch: version_2, size: 5317
2004-06-24
00:20
Apply (1679) to version 3. Ticket #777. (CVS 1680) file: [64730a1c] check-in: [0a26b915] user: danielk1977 branch: trunk, size: 5296
2004-06-23
21:16
The MIN() aggregate function returns NULL if any element in the result was NULL. This makes MIN() consistent with ORDER BY which sorts NULL first. Ticket #777. (CVS 1679) file: [b5c066aa] check-in: [78ced6e3] user: drh branch: version_2, size: 5318
2003-09-27
00:41
Do all WHERE clauses tests, even if an index is used for lookup so that we know the test cannot be FALSE. The test might end up being NULL in which case it would need to be treated as false. Ticket #461. (CVS 1103) file: [c14d0f47] check-in: [5aea8148] user: drh branch: trunk, size: 5295
2002-06-01
21:41
Multiplying NULL by zero gives NULL, not zero. I misread the test data and coded it wrong. This check-in fixes the problem. (CVS 601) file: [5c2b5730] check-in: [df9cc852] user: drh branch: trunk, size: 4243
2002-05-31
15:51
Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION. Multiplying a NULL by zero yields zero. In a CASE expression, a NULL comparison is considered false, not NULL. With these changes, NULLs in SQLite now work the same as in PostgreSQL and in Oracle. (CVS 600) file: [732b4ec9] check-in: [da61aa1d] user: drh branch: trunk, size: 4334 Added