Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/null.test
2020-09-30
| ||
17:32 | [b7ff206a1c] part of check-in [7395e96b8c] Back out the incorrect optimization of check-in [e51ecadcbdef5ce6] as ticket [5c4e7aa793943803] reports a case where the optimization does not work. (check-in: [7395e96b8c] user: drh branch: trunk, size: 7294) | |
2015-04-11
| ||
11:44 | [0dcce4f042] part of check-in [e3b1f62551] Do not assume an index contains unique entries unless it is declared UNIQUE and NOT NULL is specified for all columns. Fix for [7b4fee9f6c]. (check-in: [e3b1f62551] user: dan branch: trunk, size: 7103) | |
2007-12-13
| ||
07:58 | [a8b09b8ed8] part of check-in [2f88b9b3e3] Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622) (check-in: [2f88b9b3e3] user: danielk1977 branch: trunk, size: 6649) | |
03:45 | [6adcb4efd4] part of check-in [56063ec84b] 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) (check-in: [56063ec84b] user: drh branch: trunk, size: 6529) | |
02:45 | [93e4803367] part of check-in [bbddf16ac9] 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) (check-in: [bbddf16ac9] user: drh branch: trunk, size: 5992) | |
2006-01-17
| ||
09:35 | [9503e1f63e] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 5635) | |
2006-01-12
| ||
22:17 | [db52272f96] part of check-in [a7f528ff34] 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) (check-in: [a7f528ff34] user: drh branch: trunk, size: 5574) | |
2005-09-08
| ||
10:37 | [012fe5455f] part of check-in [21adf4bd99] 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) (check-in: [21adf4bd99] user: drh branch: trunk, size: 5406) | |
2005-01-21
| ||
03:12 | [69c62daf16] part of check-in [bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab14] user: danielk1977 branch: trunk, size: 5410) | |
2004-11-22
| ||
13:35 | [5a945790ef] part of check-in [007be591b7] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591b7] user: danielk1977 branch: trunk, size: 5344) | |
2004-08-20
| ||
18:34 | [642428b6a5] part of check-in [e97c331362] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c331362] user: drh branch: trunk, size: 5299) | |
2004-07-18
| ||
21:14 | [675e6823d7] part of check-in [223521c04e] Min() and max() ignore NULL values. Ticket #800. (CVS 1803) (check-in: [223521c04e] user: drh branch: version_2, size: 5317) | |
2004-06-24
| ||
00:20 | [64730a1c32] part of check-in [0a26b91580] Apply (1679) to version 3. Ticket #777. (CVS 1680) (check-in: [0a26b91580] user: danielk1977 branch: trunk, size: 5296) | |
2004-06-23
| ||
21:16 | [b5c066aad5] part of check-in [78ced6e309] 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) (check-in: [78ced6e309] user: drh branch: version_2, size: 5318) | |
2003-09-27
| ||
00:41 | [c14d0f4739] part of check-in [5aea81488b] 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) (check-in: [5aea81488b] user: drh branch: trunk, size: 5295) | |
2002-06-01
| ||
21:41 | [5c2b57307e] part of check-in [df9cc852ad] 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) (check-in: [df9cc852ad] user: drh branch: trunk, size: 4243) | |
2002-05-31
| ||
15:51 | Added: [732b4ec96e] part of check-in [da61aa1d23] 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) (check-in: [da61aa1d23] user: drh branch: trunk, size: 4334) | |