Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/expr.test
|
2025-04-10
| ||
| 10:18 | [4ada8eb822] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 48172) | |
|
2023-03-23
| ||
| 19:22 | [30d038a92a] part of check-in [95c7af79cf] Fix test cases so that they work when SQLITE_ENABLE_NAN_INF is defined. (check-in: [95c7af79cf] user: drh branch: nan-inf, size: 48379) | |
|
2022-05-12
| ||
| 11:45 | [5c06696478] part of check-in [db27611e17] Add IS NOT DISTINCT FROM and IS DISTINCT FROM binary operators which are equivalent to IS and IS NOT, respectively, for compatability with PostgreSQL and hence standard SQL. (check-in: [db27611e17] user: drh branch: trunk, size: 48176) | |
|
2022-01-16
| ||
| 19:11 | [e1afcdb103] part of check-in [4883776669] Fix test cases so that they all still work even with -DSQLITE_DQS=0. (check-in: [4883776669] user: drh branch: trunk, size: 46780) | |
|
2020-01-01
| ||
| 16:43 | [26cd01e848] part of check-in [07e504d517] Fix the sqlite3ExprImpliesNonNullRow() routine so that it correctly handles a numeric comparison of two AND subexpressions. (check-in: [07e504d517] user: drh branch: trunk, size: 46733) | |
|
2018-02-26
| ||
| 17:03 | [7cb55e80ae] part of check-in [c26f236da6] More tests pursuant to ticket [36fae083b450e3af857a459e20]. (check-in: [c26f236da6] user: mistachkin branch: trunk, size: 46182) | |
| 15:27 | [4d34609c82] part of check-in [a983fa8570] Always interpret non-zero floating-point values as true even if their integer part is zero. Fix for ticket [36fae083b450e3af857a459e20]. (check-in: [a983fa8570] user: drh branch: trunk, size: 45288) | |
|
2016-09-20
| ||
| 22:04 | [66a2c9ac34] part of check-in [db3ebd7c52] Improved implementation of 64-bit signed integer multiply that correctly detects overflow (and promotes to floating-point) in some corner cases. Fix for ticket [1ec41379c9c1e400] (check-in: [db3ebd7c52] user: drh branch: trunk, size: 44713) | |
|
2015-04-17
| ||
| 19:41 | [79c3e7502d] part of check-in [b67bb16c72] In the expression-tree comparison routine, do not compiler Expr.iColumn and Expr.iTable for TK_STRING expressions. (check-in: [b67bb16c72] user: drh branch: trunk, size: 43476) | |
|
2014-10-02
| ||
| 21:52 | [c4b9bf0cc6] part of check-in [ffe7573636] Avoid a NULL pointer deference when processing the IS operator if the right-hand side is an illegal "#ID" style variable. Fix for ticket [8c32a33a53092c85a15b] (check-in: [ffe7573636] user: drh branch: trunk, size: 43368) | |
|
2011-05-05
| ||
| 19:44 | [67c9fd6f8f] part of check-in [1586244b6d] Changes to various test scripts so that they pass on windows. (check-in: [1586244b6d] user: dan branch: win32-test-fixes, size: 43287) | |
|
2011-03-05
| ||
| 20:59 | [19e8ac4031] part of check-in [abf2139412] Fix all known instances of signed-integer overflow. Within SQL expressions, integer overflow now forces coercion to floating point. The shift operators work with any integer right-hand operand with negative values reversing the direction of the shift. (check-in: [abf2139412] user: drh branch: trunk, size: 42671) | |
|
2010-09-30
| ||
| 16:51 | [620a636cf7] part of check-in [43fef1cab6] Changes to remove sqlite3FitsIn64Bits(). (check-in: [43fef1cab6] user: shaneh branch: experimental, size: 37473) | |
|
2009-09-23
| ||
| 13:39 | [9f521ae22f] part of check-in [101ed58cf4] Add test cases for the IS and IS NOT operator. (check-in: [101ed58cf4] user: drh branch: trunk, size: 37473) | |
|
2009-02-04
| ||
| 03:59 | [80f3cf99f7] part of check-in [5cef400023] Changes to completely remove all floating point ops if SQLITE_OMIT_FLOATING_POINT defined. Note that w/o fp, date/time, round, nan, etc. are all gone or limited in functionality. Updated some of the test scripts to support missing fp and 64-bit functionality. Ticket #3029. (CVS 6250) (check-in: [5cef400023] user: shane branch: trunk, size: 36316) | |
|
2008-12-30
| ||
| 17:55 | [bc1e6997c2] part of check-in [b090d5736d] Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" commands from test scripts. (CVS 6086) (check-in: [b090d5736d] user: drh branch: trunk, size: 35455) | |
|
2008-08-22
| ||
| 16:29 | [135ed46c04] part of check-in [cc36b4e016] Enhanced test coverage. (CVS 5598) (check-in: [cc36b4e016] user: drh branch: trunk, size: 35467) | |
|
2008-07-30
| ||
| 13:27 | [a47d304a90] part of check-in [da0e4bff30] Implicit string->numeric conversion should go to an integer value when possible. Ticket #3257. (CVS 5502) (check-in: [da0e4bff30] user: drh branch: trunk, size: 34816) | |
|
2008-07-15
| ||
| 00:27 | [a34267926f] part of check-in [7cf91e08c0] Increased test coverage. (CVS 5414) (check-in: [7cf91e08c0] user: drh branch: trunk, size: 34024) | |
|
2008-01-22
| ||
| 01:48 | [5c606f1204] part of check-in [2a0bc1e186] Changes to lemon to generate additional comments in the output file and to remove unreachable code. Additional test cases for improved test coverage. (CVS 4736) (check-in: [2a0bc1e186] user: drh branch: trunk, size: 33950) | |
|
2008-01-19
| ||
| 20:11 | [6e666e5f47] part of check-in [af129b6d15] Miscellaneous code simplifications and cleanup and test coverage enhancements. (CVS 4730) (check-in: [af129b6d15] user: drh branch: trunk, size: 33873) | |
|
2008-01-16
| ||
| 18:20 | [31082f3f68] part of check-in [3a289b6d28] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (check-in: [3a289b6d28] user: danielk1977 branch: trunk, size: 33661) | |
|
2007-09-01
| ||
| 18:24 | [dc50ec4e69] part of check-in [02b751fb9d] Fix a bug in jrnlTruncate(). And other coverage improvements. (CVS 4367) (check-in: [02b751fb9d] user: danielk1977 branch: trunk, size: 33670) | |
| 10:01 | [ed41c753c4] part of check-in [7571345d20] Allow sqlite3GetInt32 to recognize 10-digit decimal numbers as 32-bit. (CVS 4362) (check-in: [7571345d20] user: danielk1977 branch: trunk, size: 33561) | |
|
2007-06-26
| ||
| 11:13 | [b8d63779b0] part of check-in [c6dfd9e434] Fix for #2444: Avoid SIGFPE on 64-bit platforms when evaluating expressions like ((1<<63)/-1). (CVS 4130) (check-in: [c6dfd9e434] user: danielk1977 branch: trunk, size: 33466) | |
|
2007-06-25
| ||
| 17:28 | [a4dc0855b8] part of check-in [5b3a490649] Rework the string to integer conversion logic to address tickets #2344 and #2454. (CVS 4123) (check-in: [5b3a490649] user: drh branch: trunk, size: 33352) | |
|
2007-05-10
| ||
| 17:23 | [93931366f6] part of check-in [ffe615a711] Add some UTF-8 test infrastructure. Treat NaN as NULL. The printf routines print infinity as "Inf" not as "NaN". Ticket #2345. (CVS 3972) (check-in: [ffe615a711] user: drh branch: trunk, size: 32596) | |
|
2007-05-08
| ||
| 13:57 | [a0b2bb93da] part of check-in [2f186e916c] Avoid evaluating (INT_MIN/-1) with 32 bit signed numbers. It can cause SIGFPE. (CVS 3945) (check-in: [2f186e916c] user: danielk1977 branch: trunk, size: 32529) | |
|
2007-04-06
| ||
| 02:32 | [ab21e2fc36] part of check-in [a776d93cca] Test coverage improvements. Over 90% of branches are now executed in both directions. (CVS 3820) (check-in: [a776d93cca] user: drh branch: trunk, size: 32342) | |
|
2006-09-01
| ||
| 15:49 | [c78843f730] part of check-in [bedbac54db] Remove use of the "clock" command in the test suite so that the tests will run in Tcl8.5. Ticket #1445. (CVS 3380) (check-in: [bedbac54db] user: drh branch: trunk, size: 32265) | |
|
2006-03-03
| ||
| 19:12 | [7b4b349abd] part of check-in [cdca3383c5] Ignore leading spaces on text to numeric conversions. Ticket #1662. Fixes to test cases broken by the recent changes to round(). (CVS 3118) (check-in: [cdca3383c5] user: drh branch: trunk, size: 32393) | |
|
2006-01-21
| ||
| 12:08 | [4e65cade93] part of check-in [29281dea81] Fix more problems with malloc() and IO failures. (CVS 2985) (check-in: [29281dea81] user: danielk1977 branch: trunk, size: 32399) | |
|
2006-01-07
| ||
| 14:02 | [a513aceb5d] part of check-in [6593199a4d] Fix some memory leaks caused by obscure syntax errors in SQL. (CVS 2882) (check-in: [6593199a4d] user: danielk1977 branch: trunk, size: 32141) | |
|
2005-11-14
| ||
| 22:29 | [06381174d8] part of check-in [ce06c123d0] Create separate affinities for INTEGER and REAL. (CVS 2766) (check-in: [ce06c123d0] user: drh branch: trunk, size: 31789) | |
|
2005-11-01
| ||
| 15:48 | [e44b37b926] part of check-in [e0d6f61c7d] Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) (check-in: [e0d6f61c7d] user: drh branch: trunk, size: 31783) | |
|
2005-10-29
| ||
| 15:48 | [9698d7bbe4] part of check-in [0d3357b5f6] Fix the shift operators so that they work with 64-bit quantities. (CVS 2752) (check-in: [0d3357b5f6] user: drh branch: trunk, size: 31864) | |
|
2005-08-19
| ||
| 03:03 | [71b8cba7fe] part of check-in [4281a838f2] Additional tests for better coverage. (CVS 2602) (check-in: [4281a838f2] user: drh branch: trunk, size: 31746) | |
|
2005-07-08
| ||
| 13:53 | [648f733f9d] part of check-in [b72bff81f9] Add the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539) (check-in: [b72bff81f9] user: drh branch: trunk, size: 31465) | |
|
2005-01-21
| ||
| 11:55 | [54d9d1cc05] part of check-in [9c4d0e13e8] Improve test coverage for minimum feature builds. (CVS 2254) (check-in: [9c4d0e13e8] user: danielk1977 branch: trunk, size: 28062) | |
| 03:12 | [b2ce68f4b3] 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: 27750) | |
|
2005-01-11
| ||
| 17:46 | [7baf931302] part of check-in [5767850cca] Test coverage improvements on tokenize.c. (CVS 2196) (check-in: [5767850cca] user: drh branch: trunk, size: 27676) | |
|
2004-11-17
| ||
| 16:41 | [bf826516ea] part of check-in [49268c2b7a] Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) (check-in: [49268c2b7a] user: danielk1977 branch: trunk, size: 27618) | |
|
2004-11-15
| ||
| 01:40 | [8a96b21644] part of check-in [bb2d9ff881] Add test cases for escape characters in the GLOB operator. (CVS 2101) (check-in: [bb2d9ff881] user: drh branch: trunk, size: 25660) | |
|
2004-11-10
| ||
| 12:34 | [20ddaf66c7] part of check-in [540ce7de1b] Fix expr.test so that it works when the date-time functions are compiled out of the library. (CVS 2086) (check-in: [540ce7de1b] user: danielk1977 branch: trunk, size: 25495) | |
|
2004-11-09
| ||
| 12:44 | [a1855a3b47] part of check-in [0d27c8ff48] Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) (check-in: [0d27c8ff48] user: danielk1977 branch: trunk, size: 25454) | |
|
2004-08-20
| ||
| 18:34 | [91358521f8] 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: 24752) | |
|
2004-06-19
| ||
| 00:16 | [b4e945265c] part of check-in [d705d051be] Change the name of the TCL command from "sqlite" to "sqlite3" so that both SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) (check-in: [d705d051be] user: drh branch: trunk, size: 24725) | |
|
2004-06-17
| ||
| 05:36 | [2262ade5e4] part of check-in [b9493c5fac] Use the faster LIKE function from sqlite v2. Add special user functions to test builds to test the auxdata APIs. (CVS 1610) (check-in: [b9493c5fac] user: danielk1977 branch: trunk, size: 24732) | |
|
2004-06-02
| ||
| 00:41 | [521588701d] part of check-in [b53640ed22] Remove the sqlite3_libencoding() api and the ISO8859 encoding option. (CVS 1523) (check-in: [b53640ed22] user: drh branch: trunk, size: 24667) | |
|
2004-05-13
| ||
| 11:34 | [8b62f3fcac] part of check-in [dbe8385ecf] Various minor fixes and updates to make more test cases pass. (CVS 1370) (check-in: [dbe8385ecf] user: danielk1977 branch: trunk, size: 26528) | |
|
2004-03-03
| ||
| 01:51 | [ad985242e1] part of check-in [3cac4b7b52] A vdbe stack element might have a string value even after a call to Integerify(). Ticket #641. (CVS 1283) (check-in: [3cac4b7b52] user: drh branch: trunk, size: 26448) | |
|
2003-09-30
| ||
| 01:54 | [c4cc292d60] part of check-in [95b27ebd13] All LIKE and GLOB operators to use function notation. "A LIKE B" can be expressed as "LIKE(B,A)". (CVS 1108) (check-in: [95b27ebd13] user: drh branch: trunk, size: 26360) | |
|
2003-04-16
| ||
| 02:17 | [48bc640062] part of check-in [4326b52a39] Simplify the number processing code. Fix for ticket #281. (CVS 910) (check-in: [4326b52a39] user: drh branch: trunk, size: 26039) | |
|
2003-01-14
| ||
| 00:44 | [290e2617b8] part of check-in [7ea46e7064] Make the GLOB work write with upper-case characters. Ticket #226. (CVS 831) (check-in: [7ea46e7064] user: drh branch: trunk, size: 25949) | |
|
2002-08-15
| ||
| 01:26 | [dea1cd6268] part of check-in [66a0f6a8e2] Fixes and test improvements resulting from code coverage testing. (CVS 716) (check-in: [66a0f6a8e2] user: drh branch: trunk, size: 24020) | |
|
2002-08-13
| ||
| 23:02 | [565feb81bd] part of check-in [310ac4fbaf] Make the distinction between text and numeric data. (CVS 710) (check-in: [310ac4fbaf] user: drh branch: trunk, size: 22468) | |
|
2002-06-29
| ||
| 02:20 | [5fadd0bc87] part of check-in [91c0db66c8] Add a few more tests and fix a few bugs that the tests uncovered. (CVS 652) (check-in: [91c0db66c8] user: drh branch: trunk, size: 21950) | |
|
2002-05-31
| ||
| 15:51 | [c61a92f7d7] 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: 21952) | |
|
2002-05-30
| ||
| 12:27 | [6a863adedb] part of check-in [7a24336d50] Once it is opened, leave the checkpoint journal file open for the duration of a transaction, rather than closing it and reopening it for each statement. (Ticket #53) (CVS 599) (check-in: [7a24336d50] user: drh branch: trunk, size: 21957) | |
| 02:35 | [ff6fceb995] part of check-in [4debc8db92] Bug fix: bad code was generated for when the first operand of a CASE was NULL. (CVS 598) (check-in: [4debc8db92] user: drh branch: trunk, size: 21863) | |
|
2002-05-27
| ||
| 01:04 | [518ee35ec8] part of check-in [0e268d0c0f] Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) (check-in: [0e268d0c0f] user: drh branch: trunk, size: 21765) | |
|
2002-05-26
| ||
| 20:54 | [bfb773721e] 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: 16672) | |
|
2002-03-24
| ||
| 13:13 | [846795016b] part of check-in [836b59d057] Added support for CASE expressions - patches from Dan Kennedy. (CVS 437) (check-in: [836b59d057] user: drh branch: trunk, size: 16689) | |
|
2002-01-15
| ||
| 18:39 | [c8a495050d] part of check-in [f8a026a3ca] Added implementations for sqliteOsEnterMutex() and sqliteOsLeaveMutex(). (CVS 348) (check-in: [f8a026a3ca] user: drh branch: trunk, size: 16066) | |
|
2001-11-24
| ||
| 00:31 | [d350ef5b21] part of check-in [fc2aae0457] Fix comparison functions so that they are consistent with the order of elements in indices. Fix the handling of large integers. (CVS 317) (check-in: [fc2aae0457] user: drh branch: trunk, size: 15972) | |
|
2001-10-13
| ||
| 02:59 | [b4171c84b7] part of check-in [75e90cf09b] 2.0.3 (CVS 287) (check-in: [75e90cf09b] user: drh branch: trunk, size: 14985) | |
|
2001-09-16
| ||
| 00:13 | [b3475005ea] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 14764) | |
|
2001-04-28
| ||
| 16:52 | [80bf8f0e9a] part of check-in [73a1ed6126] :-) (CVS 214) (check-in: [73a1ed6126] user: drh branch: trunk, size: 15307) | |
|
2001-04-06
| ||
| 16:13 | [e55eb50774] part of check-in [735d8b5c13] Check for miscompiled Tcl (CVS 204) (check-in: [735d8b5c13] user: drh branch: trunk, size: 14961) | |
|
2001-04-05
| ||
| 15:57 | [1e4822af02] part of check-in [8390f6521a] i18n changes (CVS 201) (check-in: [8390f6521a] user: drh branch: trunk, size: 14961) | |
|
2001-04-04
| ||
| 21:10 | [278d752407] part of check-in [f0674697c9] Added support for UTF-8 (CVS 199) (check-in: [f0674697c9] user: drh branch: trunk, size: 13346) | |
| 11:48 | [83b29f29f5] part of check-in [35a8feed0d] Added transaction support (CVS 196) (check-in: [35a8feed0d] user: drh branch: trunk, size: 11363) | |
|
2000-09-14
| ||
| 01:21 | [48273bf48a] part of check-in [ea0e32828f] better handling of exponential notation (CVS 145) (check-in: [ea0e32828f] user: drh branch: trunk, size: 11190) | |
|
2000-06-16
| ||
| 20:51 | [09b55ccf81] part of check-in [1d4fe5599e] :-) (CVS 100) (check-in: [1d4fe5599e] user: drh branch: trunk, size: 11172) | |
|
2000-06-08
| ||
| 16:26 | [2209a2b06e] part of check-in [33355b2d8d] :-) (CVS 82) (check-in: [33355b2d8d] user: drh branch: trunk, size: 10930) | |
|
2000-06-07
| ||
| 15:23 | [7d017f1aa6] part of check-in [a92eb77170] :-) (CVS 71) (check-in: [a92eb77170] user: drh branch: trunk, size: 10085) | |
|
2000-06-06
| ||
| 13:54 | [52be559214] part of check-in [54d198189b] added IN and BETWEEN operators (CVS 57) (check-in: [54d198189b] user: drh branch: trunk, size: 9855) | |
|
2000-06-03
| ||
| 19:19 | [db6984d2a6] part of check-in [729d6586b8] :-) (CVS 47) (check-in: [729d6586b8] user: drh branch: trunk, size: 9617) | |
|
2000-05-31
| ||
| 18:33 | [f3fc925935] part of check-in [0b7d9eb8ad] :-) (CVS 26) (check-in: [0b7d9eb8ad] user: drh branch: trunk, size: 5777) | |
| 17:59 | [1f514623a5] part of check-in [4cd98ebaea] :-) (CVS 24) (check-in: [4cd98ebaea] user: drh branch: trunk, size: 3888) | |
|
2000-05-30
| ||
| 03:28 | Added: [11e00880d2] part of check-in [191a7f484e] :-) (CVS 13) (check-in: [191a7f484e] user: drh branch: trunk, size: 2564) | |