SQLite

All files named ”test/e_expr.test”
Login

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

History for test/e_expr.test

2024-11-26
20:56
[4faef47507] part of check-in [a251ee645e] Provide a two-argument version of the iif() function, plus an alternative spelling that only requires a single "i". (check-in: [a251ee645e] user: drh branch: two-argument-iif, size: 73600)
2023-10-20
20:19
[b950818a48] part of check-in [b91c19bf26] Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: [b91c19bf26] user: drh branch: string_agg, size: 73258)
2023-02-18
20:31
[27e905ed17] part of check-in [655991f5d9] Fix stale requirement marks and fix a typo in the documentation for sqlite3_preupdate_hook(). (check-in: [655991f5d9] user: drh branch: trunk, size: 73260)
2022-01-21
19:26
[bc6aa5906b] part of check-in [19247e919f] Update evidence marks for the latest changes to the documentation. (check-in: [19247e919f] user: drh branch: trunk, size: 73179)
2021-09-14
18:57
[e164550b9f] part of check-in [08cab8921e] Update requirements marks to reflect recent documentation changes. (check-in: [08cab8921e] user: drh branch: trunk, size: 73309)
2020-11-25
18:44
[6ba7a51ece] part of check-in [bb174a074b] Update a requirement mark in the e_expr.test script. (check-in: [bb174a074b] user: drh branch: trunk, size: 73299)
2020-05-15
15:03
[62000e6675] part of check-in [7285ae2ce8] Adjust some requirement marks. No changes to code. (check-in: [7285ae2ce8] user: drh branch: trunk, size: 73240)
2020-05-13
18:03
[0d4e5bb50e] part of check-in [fce173cd21] Implement the IIF(x,y,z) SQL function that is short-hand for "CASE WHEN x THEN y ELSE z END". For compatibility with SQL Server. (check-in: [fce173cd21] user: drh branch: trunk, size: 73234)
2019-11-16
18:30
[a3fac98d05] part of check-in [c25289075a] Modify three test cases so that they work even with unusual versions of the library printf(). (check-in: [c25289075a] user: drh branch: apple-osx, size: 73018)
2019-11-15
21:16
[328d2d7c84] part of check-in [8f4a3750b7] Modify three test cases so that they work even with unusual versions of the library printf(). (check-in: [8f4a3750b7] user: drh branch: trunk, size: 72884)
2019-11-02
17:59
[3513cb7041] part of check-in [9c795c4d2b] Fix a problem in VIEW creation that was introduced by the generated columns feature. (check-in: [9c795c4d2b] user: drh branch: trunk, size: 72682)
2019-06-12
22:46
[e6048fe390] part of check-in [ebb81dad1f] Adjust requirements marks and add new requirements tests. (check-in: [ebb81dad1f] user: drh branch: trunk, size: 72816)
2019-06-10
18:33
[628c1c5990] part of check-in [c0c90961b4] 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]. (check-in: [c0c90961b4] user: drh branch: trunk, size: 71524)
2019-06-07
22:26
[8cd7d85270] part of check-in [67a68af557] 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]. (check-in: [67a68af557] user: drh branch: trunk, size: 71521)
2019-05-08
19:32
[698c8c6e9b] part of check-in [ef0015fde4] Simplification to the logic underlying PRAGMA case_sensitive_like. (check-in: [ef0015fde4] user: drh branch: trunk, size: 71543)
2017-09-20
10:47
[ca8896601a] part of check-in [7f2bd4ff45] Improved resolution of large integer values in "CAST(x AS NUMERIC)". (check-in: [7f2bd4ff45] user: drh branch: trunk, size: 71136)
2017-07-14
13:24
[146deba180] part of check-in [8f6dd5e290] Minor updates to requirements marks and documention. No changes to code. (check-in: [8f6dd5e290] user: drh branch: trunk, size: 69851)
2016-11-22
20:29
[d0dd488e05] part of check-in [bee2859b95] Add a new requirement mark for CAST expressions. (check-in: [bee2859b95] user: drh branch: trunk, size: 69793)
19:15
[3520cd3a18] part of check-in [f5ac98efb5] Update requirement marks to reflect changes in wording in the documentation. No changes to code. (check-in: [f5ac98efb5] user: drh branch: trunk, size: 69528)
2016-08-22
14:30
[1ffa8866d3] part of check-in [07e69f43a2] 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. (check-in: [07e69f43a2] user: drh branch: rowvalue, size: 69469)
2016-07-26
18:06
[3f9e639b5d] part of check-in [061b800603] 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. (check-in: [061b800603] user: dan branch: rowvalue, size: 69362)
2015-09-11
20:54
[03a84a6fa9] part of check-in [86781093bd] Update evidence marks due to wording changes in requirements text. No changes to code. (check-in: [86781093bd] user: drh branch: trunk, size: 69392)
2014-08-11
17:37
[8f5fdd7261] part of check-in [b5652439d5] Add a few more requirements tests. (check-in: [b5652439d5] user: drh branch: trunk, size: 69396)
2014-08-08
18:26
[5f4528f3de] part of check-in [7556bd9aa5] Update requirements marks. No changes to code. (check-in: [7556bd9aa5] user: drh branch: trunk, size: 69017)
2013-11-27
19:17
[5c71d183fb] part of check-in [ec2d47a1db] Update documentation of sqlite3_column() for clarity. Update evidence marks on test cases. (check-in: [ec2d47a1db] user: drh branch: trunk, size: 69021)
2013-11-26
22:46
[a9f7c084ea] part of check-in [838654e563] Add requirements test cases for determining when an expression is true and when it is false. (check-in: [838654e563] user: drh branch: trunk, size: 68830)
21:18
[5cc73445cc] part of check-in [d84aa44e39] Changing the CAST behavior of REAL values actually changed a documented requirement. So we also have to change the requirement evidence text to match. (check-in: [d84aa44e39] user: drh branch: trunk, size: 67660)
15:45
[0808bc72c7] part of check-in [6f53fc7106] 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. (check-in: [6f53fc7106] user: drh branch: trunk, size: 67512)
2013-11-19
00:31
[7d7feeadb5] part of check-in [072412d5e3] Fix an requirement mark in a test script so that it matches the typo-corrected requirement. No changes to code. (check-in: [072412d5e3] user: drh branch: trunk, size: 67514)
2013-08-02
23:40
[d5cdda0e4f] part of check-in [213020769f] Updates to requirements marks. No code changes. (check-in: [213020769f] user: drh branch: trunk, size: 67506)
2013-06-27
19:12
[2a599f40f3] part of check-in [fd4ece18c9] Fix an error in e_expr.test. (check-in: [fd4ece18c9] user: dan branch: trunk, size: 67602)
2012-09-12
18:45
[5bc5c9a9ec] part of check-in [8398f77c5a] Add an implementation of the REGEXP operator and function. Only defined if compiled with SQLITE_ENABLE_REGEXP. (check-in: [8398f77c5a] user: drh branch: regexp, size: 67615)
2012-02-13
10:00
[5489424d3d] part of check-in [76bb649ee2] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649ee2] user: dan branch: trunk, size: 67602)
2011-12-30
16:07
[4e4399006b] part of check-in [1bb23a3b52] Fix up requirements marks for syntax diagrams to reflect the new and improved GIF renderings. (check-in: [1bb23a3b52] user: drh branch: trunk, size: 67555)
2011-08-02
00:57
[d93ccded24] part of check-in [9007586fda] 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. (check-in: [9007586fda] user: mistachkin branch: winopen-retry-logic, size: 67555)
2011-06-20
23:51
[71b55f90c9] part of check-in [e60eefc76f] More typo fixes in evidence marks. No code changes. (check-in: [e60eefc76f] user: drh branch: trunk, size: 67576)
2011-04-05
02:21
[9e8b979080] part of check-in [57e0919b08] Added ifcapable utf16 to a few test cases; (check-in: [57e0919b08] user: shaneh branch: trunk, size: 67578)
2010-11-01
05:42
[4e004d1f51] part of check-in [465c819fdb] Changes to test scripts so that they work with SQLITE_ENABLE_ICU. (check-in: [465c819fdb] user: dan branch: trunk, size: 67446)
2010-10-04
11:01
[0fdf503f95] part of check-in [37ff94cec8] Fix broken evidence marks in e_expr.test. (check-in: [37ff94cec8] user: dan branch: trunk, size: 67124)
2010-09-03
10:58
[164e87c1d7] part of check-in [189cba0072] Add a few more subquery tests to e_expr.test. (check-in: [189cba0072] user: dan branch: trunk, size: 67160)
2010-09-02
19:01
[1aef3ba4a1] part of check-in [a55842cfb5] 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. (check-in: [a55842cfb5] user: dan branch: trunk, size: 65678)
11:53
[1d4437a740] part of check-in [9f9a95cc80] Add tests for the EXISTS operator to e_expr.test. (check-in: [9f9a95cc80] user: dan branch: trunk, size: 64109)
2010-08-27
11:19
[401066cd26] part of check-in [9616df8c47] Further tests for CAST in e_expr.test. (check-in: [9616df8c47] user: dan branch: trunk, size: 61116)
2010-08-26
19:05
[cdf7e80d43] part of check-in [ba6119d1e9] Add tests for CAST expressions to e_expr.test. More to come. (check-in: [ba6119d1e9] user: dan branch: trunk, size: 54705)
2010-08-24
13:11
[1c531745c9] part of check-in [5c1c694ee1] Add tests to e_expr.test. (check-in: [5c1c694ee1] user: dan branch: trunk, size: 49842)
2010-08-21
15:51
[8a35ce2718] part of check-in [44de3cab9c] Add some tests to e_expr.test and pagerfault.test. No code changes. (check-in: [44de3cab9c] user: dan branch: trunk, size: 41203)
2010-08-17
16:06
[27827ef763] part of check-in [ced6a3480f] Add tests for the BETWEEN operator to e_expr.test. (check-in: [ced6a3480f] user: dan branch: trunk, size: 32008)
2010-08-16
18:26
[cf59df3421] part of check-in [d4a26bb629] Add test cases designed to exercise all syntax diagram paths in lang_expr.html (check-in: [d4a26bb629] user: dan branch: trunk, size: 28864)
2010-08-14
18:32
[ba4cccc041] part of check-in [db9539f2ce] Add test case to e_expr.test. (check-in: [db9539f2ce] user: dan branch: trunk, size: 23527)
12:25
[946c72cd08] part of check-in [d8bbab78fa] Add test cases to e_expr.test. (check-in: [d8bbab78fa] user: dan branch: trunk, size: 23064)
2010-08-13
18:41
[f9ff41e541] part of check-in [3fd1059e25] Add tests to test file e_expr.test. (check-in: [3fd1059e25] user: dan branch: trunk, size: 16718)
2010-07-19
05:27
[141e53fea5] part of check-in [3d59c54a39] Enable previously failing tests in e_expr.test that pass following [3e5975aa3b]. (check-in: [3d59c54a39] user: dan branch: trunk, size: 11238)
2010-07-17
18:44
Added: [68532b32ca] part of check-in [cbcf8abbb2] Add new test file e_expr.test. (check-in: [cbcf8abbb2] user: dan branch: trunk, size: 11409)