/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/e_expr.test

2019-06-12
22:46
Adjust requirements marks and add new requirements tests. file: [e6048fe3] check-in: [ebb81dad] user: drh branch: trunk, size: 72816
2019-06-10
18:33
Make sure a CAST to "NUMERIC" results in an integer if the value can be losslessly expressed as an integer, as the documentation requires. Ticket [dd6bffbfb6e61db9]. file: [628c1c59] check-in: [c0c90961] user: drh branch: trunk, size: 71524
2019-06-07
22:26
When casting string values into numeric and the string has a prefix that looks like a number but total string is not a well-formed number, then take extra care that the result is either integer or real depending on what the prefix looks like. Fix for tickets [e8bedb2a184001] and [4c2d7639f076aa]. file: [8cd7d852] check-in: [67a68af5] user: drh branch: trunk, size: 71521
2019-05-08
19:32
Simplification to the logic underlying PRAGMA case_sensitive_like. file: [698c8c6e] check-in: [ef0015fd] user: drh branch: trunk, size: 71543
2017-09-20
10:47
Improved resolution of large integer values in "CAST(x AS NUMERIC)". file: [ca889660] check-in: [7f2bd4ff] user: drh branch: trunk, size: 71136
2017-07-14
13:24
Minor updates to requirements marks and documention. No changes to code. file: [146deba1] check-in: [8f6dd5e2] user: drh branch: trunk, size: 69851
2016-11-22
20:29
Add a new requirement mark for CAST expressions. file: [d0dd488e] check-in: [bee2859b] user: drh branch: trunk, size: 69793
19:15
Update requirement marks to reflect changes in wording in the documentation. No changes to code. file: [3520cd3a] check-in: [f5ac98ef] user: drh branch: trunk, size: 69528
2016-08-22
14:30
Fix the vector BETWEEN operator so that it only evaluates the left-most vector expression once. Add support for vector comparisons in the CASE operator. file: [1ffa8866] check-in: [07e69f43] user: drh branch: rowvalue, size: 69469
2016-07-26
18:06
Fix where.c handling of "IN (SELECT ...)" expressions when the SELECT returns more than one result column. Also error handling for other row value constructor cases. file: [3f9e639b] check-in: [061b8006] user: dan branch: rowvalue, size: 69362
2015-09-11
20:54
Update evidence marks due to wording changes in requirements text. No changes to code. file: [03a84a6f] check-in: [86781093] user: drh branch: trunk, size: 69392
2014-08-11
17:37
Add a few more requirements tests. file: [8f5fdd72] check-in: [b5652439] user: drh branch: trunk, size: 69396
2014-08-08
18:26
Update requirements marks. No changes to code. file: [5f4528f3] check-in: [7556bd9a] user: drh branch: trunk, size: 69017
2013-11-27
19:17
Update documentation of sqlite3_column() for clarity. Update evidence marks on test cases. file: [5c71d183] check-in: [ec2d47a1] user: drh branch: trunk, size: 69021
2013-11-26
22:46
Add requirements test cases for determining when an expression is true and when it is false. file: [a9f7c084] check-in: [838654e5] user: drh branch: trunk, size: 68830
21:18
Changing the CAST behavior of REAL values actually changed a documented requirement. So we also have to change the requirement evidence text to match. file: [5cc73445] check-in: [d84aa44e] user: drh branch: trunk, size: 67660
15:45
Change the REAL-to-INTEGER casting behavior so that if the REAL value is greater than 9223372036854775807.0 then it is cast to the latest possible integer, 9223372036854775807. This is sensible and the way most platforms work in hardware. The former behavior was that oversize REALs would be cast to the smallest possible integer, -9223372036854775808, which is the way Intel hardware works. file: [0808bc72] check-in: [6f53fc71] user: drh branch: trunk, size: 67512
2013-11-19
00:31
Fix an requirement mark in a test script so that it matches the typo-corrected requirement. No changes to code. file: [7d7feead] check-in: [072412d5] user: drh branch: trunk, size: 67514
2013-08-02
23:40
Updates to requirements marks. No code changes. file: [d5cdda0e] check-in: [21302076] user: drh branch: trunk, size: 67506
2013-06-27
19:12
Fix an error in e_expr.test. file: [2a599f40] check-in: [fd4ece18] user: dan branch: trunk, size: 67602
2012-09-12
18:45
Add an implementation of the REGEXP operator and function. Only defined if compiled with SQLITE_ENABLE_REGEXP. file: [5bc5c9a9] check-in: [8398f77c] user: drh branch: regexp, size: 67615
2012-02-13
10:00
Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. file: [5489424d] check-in: [76bb649e] user: dan branch: trunk, size: 67602
2011-12-30
16:07
Fix up requirements marks for syntax diagrams to reflect the new and improved GIF renderings. file: [4e439900] check-in: [1bb23a3b] user: drh branch: trunk, size: 67555
2011-08-02
00:57
Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. file: [d93ccded] check-in: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 67555
2011-06-20
23:51
More typo fixes in evidence marks. No code changes. file: [71b55f90] check-in: [e60eefc7] user: drh branch: trunk, size: 67576
2011-04-05
02:21
Added ifcapable utf16 to a few test cases; file: [9e8b9790] check-in: [57e0919b] user: shaneh branch: trunk, size: 67578
2010-11-01
05:42
Changes to test scripts so that they work with SQLITE_ENABLE_ICU. file: [4e004d1f] check-in: [465c819f] user: dan branch: trunk, size: 67446
2010-10-04
11:01
Fix broken evidence marks in e_expr.test. file: [0fdf503f] check-in: [37ff94ce] user: dan branch: trunk, size: 67124
2010-09-03
10:58
Add a few more subquery tests to e_expr.test. file: [164e87c1] check-in: [189cba00] user: dan branch: trunk, size: 67160
2010-09-02
19:01
Move the test for an (illegal) scalar sub-query that returns more than one column to earlier in SELECT processing in order to avoid an assert() that can happen later on. file: [1aef3ba4] check-in: [a55842cf] user: dan branch: trunk, size: 65678
11:53
Add tests for the EXISTS operator to e_expr.test. file: [1d4437a7] check-in: [9f9a95cc] user: dan branch: trunk, size: 64109
2010-08-27
11:19
Further tests for CAST in e_expr.test. file: [401066cd] check-in: [9616df8c] user: dan branch: trunk, size: 61116
2010-08-26
19:05
Add tests for CAST expressions to e_expr.test. More to come. file: [cdf7e80d] check-in: [ba6119d1] user: dan branch: trunk, size: 54705
2010-08-24
13:11
Add tests to e_expr.test. file: [1c531745] check-in: [5c1c694e] user: dan branch: trunk, size: 49842
2010-08-21
15:51
Add some tests to e_expr.test and pagerfault.test. No code changes. file: [8a35ce27] check-in: [44de3cab] user: dan branch: trunk, size: 41203
2010-08-17
16:06
Add tests for the BETWEEN operator to e_expr.test. file: [27827ef7] check-in: [ced6a348] user: dan branch: trunk, size: 32008
2010-08-16
18:26
Add test cases designed to exercise all syntax diagram paths in lang_expr.html file: [cf59df34] check-in: [d4a26bb6] user: dan branch: trunk, size: 28864
2010-08-14
18:32
Add test case to e_expr.test. file: [ba4cccc0] check-in: [db9539f2] user: dan branch: trunk, size: 23527
12:25
Add test cases to e_expr.test. file: [946c72cd] check-in: [d8bbab78] user: dan branch: trunk, size: 23064
2010-08-13
18:41
Add tests to test file e_expr.test. file: [f9ff41e5] check-in: [3fd1059e] user: dan branch: trunk, size: 16718
2010-07-19
05:27
Enable previously failing tests in e_expr.test that pass following [3e5975aa3b]. file: [141e53fe] check-in: [3d59c54a] user: dan branch: trunk, size: 11238
2010-07-17
18:44
Add new test file e_expr.test. file: [68532b32] check-in: [cbcf8abb] user: dan branch: trunk, size: 11409 Added