/ File History
Login

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

History of test/expr.test

2018-02-26
17:03
More tests pursuant to ticket [36fae083b450e3af857a459e20]. file: [7cb55e80] check-in: [c26f236d] user: mistachkin branch: trunk, size: 46182
15:27
Always interpret non-zero floating-point values as true even if their integer part is zero. Fix for ticket [36fae083b450e3af857a459e20]. file: [4d34609c] check-in: [a983fa85] user: drh branch: trunk, size: 45288
2016-09-20
22:04
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] file: [66a2c9ac] check-in: [db3ebd7c] user: drh branch: trunk, size: 44713
2015-04-17
19:41
In the expression-tree comparison routine, do not compiler Expr.iColumn and Expr.iTable for TK_STRING expressions. file: [79c3e750] check-in: [b67bb16c] user: drh branch: trunk, size: 43476
2014-10-02
21:52
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] file: [c4b9bf0c] check-in: [ffe75736] user: drh branch: trunk, size: 43368
2011-05-05
19:44
Changes to various test scripts so that they pass on windows. file: [67c9fd6f] check-in: [1586244b] user: dan branch: win32-test-fixes, size: 43287
2011-03-05
20:59
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. file: [19e8ac40] check-in: [abf21394] user: drh branch: trunk, size: 42671
2010-09-30
16:51
Changes to remove sqlite3FitsIn64Bits(). file: [620a636c] check-in: [43fef1ca] user: shaneh branch: experimental, size: 37473
2009-09-23
13:39
Add test cases for the IS and IS NOT operator. file: [9f521ae2] check-in: [101ed58c] user: drh branch: trunk, size: 37473
2009-02-04
03:59
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) file: [80f3cf99] check-in: [5cef4000] user: shane branch: trunk, size: 36316
2008-12-30
17:55
Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" commands from test scripts. (CVS 6086) file: [bc1e6997] check-in: [b090d573] user: drh branch: trunk, size: 35455
2008-08-22
16:29
Enhanced test coverage. (CVS 5598) file: [135ed46c] check-in: [cc36b4e0] user: drh branch: trunk, size: 35467
2008-07-30
13:27
Implicit string->numeric conversion should go to an integer value when possible. Ticket #3257. (CVS 5502) file: [a47d304a] check-in: [da0e4bff] user: drh branch: trunk, size: 34816
2008-07-15
00:27
Increased test coverage. (CVS 5414) file: [a3426792] check-in: [7cf91e08] user: drh branch: trunk, size: 34024
2008-01-22
01:48
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) file: [5c606f12] check-in: [2a0bc1e1] user: drh branch: trunk, size: 33950
2008-01-19
20:11
Miscellaneous code simplifications and cleanup and test coverage enhancements. (CVS 4730) file: [6e666e5f] check-in: [af129b6d] user: drh branch: trunk, size: 33873
2008-01-16
18:20
Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) file: [31082f3f] check-in: [3a289b6d] user: danielk1977 branch: trunk, size: 33661
2007-09-01
18:24
Fix a bug in jrnlTruncate(). And other coverage improvements. (CVS 4367) file: [dc50ec4e] check-in: [02b751fb] user: danielk1977 branch: trunk, size: 33670
10:01
Allow sqlite3GetInt32 to recognize 10-digit decimal numbers as 32-bit. (CVS 4362) file: [ed41c753] check-in: [7571345d] user: danielk1977 branch: trunk, size: 33561
2007-06-26
11:13
Fix for #2444: Avoid SIGFPE on 64-bit platforms when evaluating expressions like ((1<<63)/-1). (CVS 4130) file: [b8d63779] check-in: [c6dfd9e4] user: danielk1977 branch: trunk, size: 33466
2007-06-25
17:28
Rework the string to integer conversion logic to address tickets #2344 and #2454. (CVS 4123) file: [a4dc0855] check-in: [5b3a4906] user: drh branch: trunk, size: 33352
2007-05-10
17:23
Add some UTF-8 test infrastructure. Treat NaN as NULL. The printf routines print infinity as "Inf" not as "NaN". Ticket #2345. (CVS 3972) file: [93931366] check-in: [ffe615a7] user: drh branch: trunk, size: 32596
2007-05-08
13:57
Avoid evaluating (INT_MIN/-1) with 32 bit signed numbers. It can cause SIGFPE. (CVS 3945) file: [a0b2bb93] check-in: [2f186e91] user: danielk1977 branch: trunk, size: 32529
2007-04-06
02:32
Test coverage improvements. Over 90% of branches are now executed in both directions. (CVS 3820) file: [ab21e2fc] check-in: [a776d93c] user: drh branch: trunk, size: 32342
2006-09-01
15:49
Remove use of the "clock" command in the test suite so that the tests will run in Tcl8.5. Ticket #1445. (CVS 3380) file: [c78843f7] check-in: [bedbac54] user: drh branch: trunk, size: 32265
2006-03-03
19:12
Ignore leading spaces on text to numeric conversions. Ticket #1662. Fixes to test cases broken by the recent changes to round(). (CVS 3118) file: [7b4b349a] check-in: [cdca3383] user: drh branch: trunk, size: 32393
2006-01-21
12:08
Fix more problems with malloc() and IO failures. (CVS 2985) file: [4e65cade] check-in: [29281dea] user: danielk1977 branch: trunk, size: 32399
2006-01-07
14:02
Fix some memory leaks caused by obscure syntax errors in SQL. (CVS 2882) file: [a513aceb] check-in: [6593199a] user: danielk1977 branch: trunk, size: 32141
2005-11-14
22:29
Create separate affinities for INTEGER and REAL. (CVS 2766) file: [06381174] check-in: [ce06c123] user: drh branch: trunk, size: 31789
2005-11-01
15:48
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) file: [e44b37b9] check-in: [e0d6f61c] user: drh branch: trunk, size: 31783
2005-10-29
15:48
Fix the shift operators so that they work with 64-bit quantities. (CVS 2752) file: [9698d7bb] check-in: [0d3357b5] user: drh branch: trunk, size: 31864
2005-08-19
03:03
Additional tests for better coverage. (CVS 2602) file: [71b8cba7] check-in: [4281a838] user: drh branch: trunk, size: 31746
2005-07-08
13:53
Add the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539) file: [648f733f] check-in: [b72bff81] user: drh branch: trunk, size: 31465
2005-01-21
11:55
Improve test coverage for minimum feature builds. (CVS 2254) file: [54d9d1cc] check-in: [9c4d0e13] user: danielk1977 branch: trunk, size: 28062
03:12
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [b2ce68f4] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 27750
2005-01-11
17:46
Test coverage improvements on tokenize.c. (CVS 2196) file: [7baf9313] check-in: [5767850c] user: drh branch: trunk, size: 27676
2004-11-17
16:41
Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) file: [bf826516] check-in: [49268c2b] user: danielk1977 branch: trunk, size: 27618
2004-11-15
01:40
Add test cases for escape characters in the GLOB operator. (CVS 2101) file: [8a96b216] check-in: [bb2d9ff8] user: drh branch: trunk, size: 25660
2004-11-10
12:34
Fix expr.test so that it works when the date-time functions are compiled out of the library. (CVS 2086) file: [20ddaf66] check-in: [540ce7de] user: danielk1977 branch: trunk, size: 25495
2004-11-09
12:44
Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) file: [a1855a3b] check-in: [0d27c8ff] user: danielk1977 branch: trunk, size: 25454
2004-08-20
18:34
Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [91358521] check-in: [e97c3313] user: drh branch: trunk, size: 24752
2004-06-19
00:16
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) file: [b4e94526] check-in: [d705d051] user: drh branch: trunk, size: 24725
2004-06-17
05:36
Use the faster LIKE function from sqlite v2. Add special user functions to test builds to test the auxdata APIs. (CVS 1610) file: [2262ade5] check-in: [b9493c5f] user: danielk1977 branch: trunk, size: 24732
2004-06-02
00:41
Remove the sqlite3_libencoding() api and the ISO8859 encoding option. (CVS 1523) file: [52158870] check-in: [b53640ed] user: drh branch: trunk, size: 24667
2004-05-13
11:34
Various minor fixes and updates to make more test cases pass. (CVS 1370) file: [8b62f3fc] check-in: [dbe8385e] user: danielk1977 branch: trunk, size: 26528
2004-03-03
01:51
A vdbe stack element might have a string value even after a call to Integerify(). Ticket #641. (CVS 1283) file: [ad985242] check-in: [3cac4b7b] user: drh branch: trunk, size: 26448
2003-09-30
01:54
All LIKE and GLOB operators to use function notation. "A LIKE B" can be expressed as "LIKE(B,A)". (CVS 1108) file: [c4cc292d] check-in: [95b27ebd] user: drh branch: trunk, size: 26360
2003-04-16
02:17
Simplify the number processing code. Fix for ticket #281. (CVS 910) file: [48bc6400] check-in: [4326b52a] user: drh branch: trunk, size: 26039
2003-01-14
00:44
Make the GLOB work write with upper-case characters. Ticket #226. (CVS 831) file: [290e2617] check-in: [7ea46e70] user: drh branch: trunk, size: 25949
2002-08-15
01:26
Fixes and test improvements resulting from code coverage testing. (CVS 716) file: [dea1cd62] check-in: [66a0f6a8] user: drh branch: trunk, size: 24020
2002-08-13
23:02
Make the distinction between text and numeric data. (CVS 710) file: [565feb81] check-in: [310ac4fb] user: drh branch: trunk, size: 22468
2002-06-29
02:20
Add a few more tests and fix a few bugs that the tests uncovered. (CVS 652) file: [5fadd0bc] check-in: [91c0db66] user: drh branch: trunk, size: 21950
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: [c61a92f7] check-in: [da61aa1d] user: drh branch: trunk, size: 21952
2002-05-30
12:27
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) file: [6a863ade] check-in: [7a24336d] user: drh branch: trunk, size: 21957
02:35
Bug fix: bad code was generated for when the first operand of a CASE was NULL. (CVS 598) file: [ff6fceb9] check-in: [4debc8db] user: drh branch: trunk, size: 21863
2002-05-27
01:04
Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) file: [518ee35e] check-in: [0e268d0c] user: drh branch: trunk, size: 21765
2002-05-26
20:54
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) file: [bfb77372] check-in: [90511737] user: drh branch: trunk, size: 16672
2002-03-24
13:13
Added support for CASE expressions - patches from Dan Kennedy. (CVS 437) file: [84679501] check-in: [836b59d0] user: drh branch: trunk, size: 16689
2002-01-15
18:39
Added implementations for sqliteOsEnterMutex() and sqliteOsLeaveMutex(). (CVS 348) file: [c8a49505] check-in: [f8a026a3] user: drh branch: trunk, size: 16066
2001-11-24
00:31
Fix comparison functions so that they are consistent with the order of elements in indices. Fix the handling of large integers. (CVS 317) file: [d350ef5b] check-in: [fc2aae04] user: drh branch: trunk, size: 15972
2001-10-13
02:59
2.0.3 (CVS 287) file: [b4171c84] check-in: [75e90cf0] user: drh branch: trunk, size: 14985
2001-09-16
00:13
Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [b3475005] check-in: [4e926efe] user: drh branch: trunk, size: 14764
2001-04-28
16:52
:-) (CVS 214) file: [80bf8f0e] check-in: [73a1ed61] user: drh branch: trunk, size: 15307
2001-04-06
16:13
Check for miscompiled Tcl (CVS 204) file: [e55eb507] check-in: [735d8b5c] user: drh branch: trunk, size: 14961
2001-04-05
15:57
i18n changes (CVS 201) file: [1e4822af] check-in: [8390f652] user: drh branch: trunk, size: 14961
2001-04-04
21:10
Added support for UTF-8 (CVS 199) file: [278d7524] check-in: [f0674697] user: drh branch: trunk, size: 13346
11:48
Added transaction support (CVS 196) file: [83b29f29] check-in: [35a8feed] user: drh branch: trunk, size: 11363
2000-09-14
01:21
better handling of exponential notation (CVS 145) file: [48273bf4] check-in: [ea0e3282] user: drh branch: trunk, size: 11190
2000-06-16
20:51
:-) (CVS 100) file: [09b55ccf] check-in: [1d4fe559] user: drh branch: trunk, size: 11172
2000-06-08
16:26
:-) (CVS 82) file: [2209a2b0] check-in: [33355b2d] user: drh branch: trunk, size: 10930
2000-06-07
15:23
:-) (CVS 71) file: [7d017f1a] check-in: [a92eb771] user: drh branch: trunk, size: 10085
2000-06-06
13:54
added IN and BETWEEN operators (CVS 57) file: [52be5592] check-in: [54d19818] user: drh branch: trunk, size: 9855
2000-06-03
19:19
:-) (CVS 47) file: [db6984d2] check-in: [729d6586] user: drh branch: trunk, size: 9617
2000-05-31
18:33
:-) (CVS 26) file: [f3fc9259] check-in: [0b7d9eb8] user: drh branch: trunk, size: 5777
17:59
:-) (CVS 24) file: [1f514623] check-in: [4cd98eba] user: drh branch: trunk, size: 3888
2000-05-30
03:28
:-) (CVS 13) file: [11e00880] check-in: [191a7f48] user: drh branch: trunk, size: 2564 Added