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 | |