aboutsummaryrefslogtreecommitdiff
path: root/test/expr.test
Commit message (Collapse)AuthorAge
* Add IS NOT DISTINCT FROM and IS DISTINCT FROM binary operators which aredrh2022-05-12
| | | | | | equivalent to IS and IS NOT, respectively, for compatability with PostgreSQL and hence standard SQL. FossilOrigin-Name: db27611e172102483eaede3981d473e3d5bf93d98bc68f480398b1573876349d
* Fix test cases so that they all still work even with -DSQLITE_DQS=0.drh2022-01-16
| | | FossilOrigin-Name: 4883776669ee2f2310ea82b0d6df4d008eebaa7cb252102539cf21a635402ebb
* Fix the sqlite3ExprImpliesNonNullRow() routine so that it correctlydrh2020-01-01
| | | | | handles a numeric comparison of two AND subexpressions. FossilOrigin-Name: 07e504d5174a1a8b1aa05ec5b44ac81ab3ea706c5a098caa88deb3d489cec8fb
* More tests pursuant to ticket [36fae083b450e3af857a459e20].mistachkin2018-02-26
| | | FossilOrigin-Name: c26f236da61aef7c7a8fe38f1c7f33eea894c8fae38de6a085d4cce933a70502
* Always interpret non-zero floating-point values as true even if theirdrh2018-02-26
| | | | | integer part is zero. Fix for ticket [36fae083b450e3af857a459e20]. FossilOrigin-Name: a983fa857048c748112c2f805f13aadeae43b43b3d27fa55433a3699b51c9a0e
* Improved implementation of 64-bit signed integer multiply that correctlydrh2016-09-20
| | | | | | detects overflow (and promotes to floating-point) in some corner cases. Fix for ticket [1ec41379c9c1e400] FossilOrigin-Name: db3ebd7c52cfc5fcc7be00f52e9d7c84719f7b93
* In the expression-tree comparison routine, do not compiler Expr.iColumndrh2015-04-17
| | | | | and Expr.iTable for TK_STRING expressions. FossilOrigin-Name: b67bb16c72c3e015ea82665ada9b5d3289ef6fb2
* Avoid a NULL pointer deference when processing the IS operator if thedrh2014-10-02
| | | | | | right-hand side is an illegal "#ID" style variable. Fix for ticket [8c32a33a53092c85a15b] FossilOrigin-Name: ffe7573636c8057614b02f0a85559e1857fd04e4
* Changes to various test scripts so that they pass on windows.dan2011-05-05
| | | FossilOrigin-Name: 1586244b6d86d5a98af8c6f7a8324672e02df9c3
* Fix all known instances of signed-integer overflow. Within SQL expressions,drh2011-03-05
| | | | | | | 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. FossilOrigin-Name: abf21394124a0af46f072793718964cee2ce55d0
* Changes to remove sqlite3FitsIn64Bits().shaneh2010-09-30
| | | FossilOrigin-Name: 43fef1cab6315f837782ea601d5a2aeb9843ab3c
* Add test cases for the IS and IS NOT operator.drh2009-09-23
| | | FossilOrigin-Name: 101ed58cf4a1dfe53031b98cfc7ed01e86b4c7b6
* Changes to completely remove all floating point ops if ↵shane2009-02-04
| | | | | 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) FossilOrigin-Name: 5cef400023205b55152b91441acc78f9cd8d58a9
* Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint"drh2008-12-30
| | | | | commands from test scripts. (CVS 6086) FossilOrigin-Name: b090d5736d7eaec17a39d3133e1587b1d2a42acb
* Enhanced test coverage. (CVS 5598)drh2008-08-22
| | | FossilOrigin-Name: cc36b4e016a1f519ca81d591de3a551ee8aa6813
* Implicit string->numeric conversion should go to an integer value whendrh2008-07-30
| | | | | possible. Ticket #3257. (CVS 5502) FossilOrigin-Name: da0e4bff30a77f72ae283406b547401c2ebb42c5
* Increased test coverage. (CVS 5414)drh2008-07-15
| | | FossilOrigin-Name: 7cf91e08c08ce515c24c738c7d079f5b81eebee6
* Changes to lemon to generate additional comments in the output file anddrh2008-01-22
| | | | | | to remove unreachable code. Additional test cases for improved test coverage. (CVS 4736) FossilOrigin-Name: 2a0bc1e186532a0bfe36ca18fda74a5e7a199227
* Miscellaneous code simplifications and cleanup and test coveragedrh2008-01-19
| | | | | enhancements. (CVS 4730) FossilOrigin-Name: af129b6d158cc90ce9752dd6383c1de47f7b3e43
* Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715)danielk19772008-01-16
| | | FossilOrigin-Name: 3a289b6d28bcf399845586b15f100d7c3a78b550
* Fix a bug in jrnlTruncate(). And other coverage improvements. (CVS 4367)danielk19772007-09-01
| | | FossilOrigin-Name: 02b751fb9dbc683b1b77a2ed3cdeb4190f7339e0
* Allow sqlite3GetInt32 to recognize 10-digit decimal numbers as 32-bit. (CVS ↵danielk19772007-09-01
| | | | | 4362) FossilOrigin-Name: 7571345d2078fb52029f9b9924d833ec36d443e6
* Fix for #2444: Avoid SIGFPE on 64-bit platforms when evaluating expressions ↵danielk19772007-06-26
| | | | | like ((1<<63)/-1). (CVS 4130) FossilOrigin-Name: c6dfd9e43449b0b3528281d9e2e4971c6ba86ab5
* Rework the string to integer conversion logic to address ticketsdrh2007-06-25
| | | | | #2344 and #2454. (CVS 4123) FossilOrigin-Name: 5b3a490649ab88c168e3e5bf2efbc7f61b1b954d
* Add some UTF-8 test infrastructure. Treat NaN as NULL. The printf routinesdrh2007-05-10
| | | | | print infinity as "Inf" not as "NaN". Ticket #2345. (CVS 3972) FossilOrigin-Name: ffe615a71107a38b6f60c7baf4284a5b0aecdc22
* Avoid evaluating (INT_MIN/-1) with 32 bit signed numbers. It can cause ↵danielk19772007-05-08
| | | | | SIGFPE. (CVS 3945) FossilOrigin-Name: 2f186e916c982cde557e0bc1b925b10e6d58f8a1
* Test coverage improvements. Over 90% of branches are now executed indrh2007-04-06
| | | | | both directions. (CVS 3820) FossilOrigin-Name: a776d93ccae3bfa6e992cdd1387571dd21561f98
* Remove use of the "clock" command in the test suite so that the testsdrh2006-09-01
| | | | | will run in Tcl8.5. Ticket #1445. (CVS 3380) FossilOrigin-Name: bedbac54db173ceb74bd78acd021209f28aa30a8
* Ignore leading spaces on text to numeric conversions. Ticket #1662.drh2006-03-03
| | | | | Fixes to test cases broken by the recent changes to round(). (CVS 3118) FossilOrigin-Name: cdca3383c54b33aeafbbdbbb4ae7c90796cf66e5
* Fix more problems with malloc() and IO failures. (CVS 2985)danielk19772006-01-21
| | | FossilOrigin-Name: 29281dea81c909b70b2d914d7061a6df8f388195
* Fix some memory leaks caused by obscure syntax errors in SQL. (CVS 2882)danielk19772006-01-07
| | | FossilOrigin-Name: 6593199a4d0d0e1f9cc2f48d30327b1c03a8170e
* Create separate affinities for INTEGER and REAL. (CVS 2766)drh2005-11-14
| | | FossilOrigin-Name: ce06c123d0c5663dbaf263c2e0aaf5d9cdeb2ccd
* Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are nowdrh2005-11-01
| | | | | | of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) FossilOrigin-Name: e0d6f61c7de2c03b8fd17ef37cf1a0add36ee618
* Fix the shift operators so that they work with 64-bit quantities. (CVS 2752)drh2005-10-29
| | | FossilOrigin-Name: 0d3357b5f65887f7db03db2ae021f28f480f90e4
* Additional tests for better coverage. (CVS 2602)drh2005-08-19
| | | FossilOrigin-Name: 4281a838f2f531af24b008d2834e8318798472c5
* Add the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539)drh2005-07-08
| | | FossilOrigin-Name: b72bff81f9937378417a0af0610d8558279b67a7
* Improve test coverage for minimum feature builds. (CVS 2254)danielk19772005-01-21
| | | FossilOrigin-Name: 9c4d0e13e8c5f3fc4d7fd8f495898372293f7fad
* Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT ↵danielk19772005-01-21
| | | | | macros) is defined. (CVS 2251) FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a
* Test coverage improvements on tokenize.c. (CVS 2196)drh2005-01-11
| | | FossilOrigin-Name: 5767850ccadb3b53d14bca547e50f65de1d3092e
* Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107)danielk19772004-11-17
| | | FossilOrigin-Name: 49268c2b7a84c4c618214dac8bef0f541440fe6b
* Add test cases for escape characters in the GLOB operator. (CVS 2101)drh2004-11-15
| | | FossilOrigin-Name: bb2d9ff881e4c6fe0cf60a13609d39426346fa9d
* Fix expr.test so that it works when the date-time functions are compiled out ↵danielk19772004-11-10
| | | | | of the library. (CVS 2086) FossilOrigin-Name: 540ce7de1b3f1882c40d4e20d3986775e1dcf77a
* Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of ↵danielk19772004-11-09
| | | | | sqlite. (CVS 2082) FossilOrigin-Name: 0d27c8ff48f327ad82dd5b5b3b47b8d221f119b7
* Tcl interface transfers values directly between SQLite and Tcl_Objs, withoutdrh2004-08-20
| | | | | at translation to strings. (CVS 1898) FossilOrigin-Name: e97c331362545ce21117776c7b61d3488668f2bf
* Change the name of the TCL command from "sqlite" to "sqlite3" so that bothdrh2004-06-19
| | | | | SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) FossilOrigin-Name: d705d051bed2b92b6c3bbcc75fe5b056633b9c31
* Use the faster LIKE function from sqlite v2. Add special user functions todanielk19772004-06-17
| | | | | test builds to test the auxdata APIs. (CVS 1610) FossilOrigin-Name: b9493c5facea4d24a6cbc4f6fa2f75dc2399a11d
* Remove the sqlite3_libencoding() api and the ISO8859 encoding option. (CVS 1523)drh2004-06-02
| | | FossilOrigin-Name: b53640ed2232aaf173a71636073477d80407d11f
* Various minor fixes and updates to make more test cases pass. (CVS 1370)danielk19772004-05-13
| | | FossilOrigin-Name: dbe8385ecf1df8bf0b1baf5e811ec5a1de5c4c42
* A vdbe stack element might have a string value even after a call todrh2004-03-03
| | | | | Integerify(). Ticket #641. (CVS 1283) FossilOrigin-Name: 3cac4b7b526d6c5dbf394009b534707bcb65b0da
* All LIKE and GLOB operators to use function notation. "A LIKE B" can bedrh2003-09-30
| | | | | expressed as "LIKE(B,A)". (CVS 1108) FossilOrigin-Name: 95b27ebd1322a877112dee514dffddb0937e45fa
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-21 05:01:45 +0000