aboutsummaryrefslogtreecommitdiff
path: root/test/e_expr.test
Commit message (Collapse)AuthorAge
* Provide a two-argument version of the iif() function, plus an alternativedrh2024-11-26
| | | | | spelling that only requires a single "i". FossilOrigin-Name: a251ee645e11e24b67473d8a5bd3f8b72fde1ac9d5fda074f5da2297deb2faa8
* Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibilitydrh2023-10-20
| | | | | with SQLServer and PG. FossilOrigin-Name: b91c19bf2680f60d7826ab5d9e7902e2dc2a55d847bbea565a6489d47f2cc8f1
* Fix stale requirement marks and fix a typo in the documentation fordrh2023-02-18
| | | | | sqlite3_preupdate_hook(). FossilOrigin-Name: 655991f5d9afdd3281049eb430921046e0ba90eef215020c2fb149adc0d3c4c5
* Update evidence marks for the latest changes to the documentation.drh2022-01-21
| | | FossilOrigin-Name: 19247e919fab9748cae561cb12c4c3c106064390a37e32e724d9a9066cfaff8e
* Update requirements marks to reflect recent documentation changes.drh2021-09-14
| | | FossilOrigin-Name: 08cab8921e670a0d1758b505fe8c7455f6194cec69d1b7b77de91688be1028a6
* Update a requirement mark in the e_expr.test script.drh2020-11-25
| | | FossilOrigin-Name: bb174a074b5833181900d396edda955254ea1768750a0ab3b6d714530b1fe13f
* Adjust some requirement marks. No changes to code.drh2020-05-15
| | | FossilOrigin-Name: 7285ae2ce8fb1439e1acea2ec321abbc76aab0a2e84b58683fddb0a7bf74fb1b
* Implement the IIF(x,y,z) SQL function that is short-hand fordrh2020-05-13
| | | | | "CASE WHEN x THEN y ELSE z END". For compatibility with SQL Server. FossilOrigin-Name: fce173cd211b15867369b6a54fad48168352fc83981a722ce98e57299b88608a
* Modify three test cases so that they work even with unusual versions of thedrh2019-11-15
| | | | | library printf(). FossilOrigin-Name: 8f4a3750b7d272daf96831655ffee80d457875ee121fc4537008046b9a00d0e7
* Fix a problem in VIEW creation that was introduced by the generated columnsdrh2019-11-02
| | | | | feature. FossilOrigin-Name: 9c795c4d2b042d2932774bd1274fa0167ca2dc9838e127e0cf31eb9273a32f2c
* Adjust requirements marks and add new requirements tests.drh2019-06-12
| | | FossilOrigin-Name: ebb81dad1f43dac4636cd44d4055d1d4b198c675f73e23c5a2d8d992ae27fe1f
* Make sure a CAST to "NUMERIC" results in an integer if the value can bedrh2019-06-10
| | | | | | losslessly expressed as an integer, as the documentation requires. Ticket [dd6bffbfb6e61db9]. FossilOrigin-Name: c0c90961b4fa1c1185772d04fe1915bc1a1af27ed8ddb8db1c524bf90d68ccbf
* When casting string values into numeric and the string has a prefix that looksdrh2019-06-07
| | | | | | | 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]. FossilOrigin-Name: 67a68af5578f08d2be2e48cf4fd12a6cf35a09c47d259deda81950f7ee1f02f7
* Simplification to the logic underlying PRAGMA case_sensitive_like.drh2019-05-08
| | | FossilOrigin-Name: ef0015fde4c87e992ffd3d7dea8586951bdd65ff98d30d436b126b85b1cc9c74
* Improved resolution of large integer values in "CAST(x AS NUMERIC)".drh2017-09-20
| | | FossilOrigin-Name: 7f2bd4ff45fba29528c18cac6da983bd9b164303525d3965056f5b40f85dc83f
* Minor updates to requirements marks and documention. No changes to code.drh2017-07-14
| | | FossilOrigin-Name: 8f6dd5e2907d6df230fcbceadd226496bcc35a33c117da58215f7d333c1cc7b8
* Add a new requirement mark for CAST expressions.drh2016-11-22
| | | FossilOrigin-Name: bee2859b953c935c413de2917588159d03c672d9
* Update requirement marks to reflect changes in wording in the documentation.drh2016-11-22
| | | | | No changes to code. FossilOrigin-Name: f5ac98efb5d5f7751c5c560bed9c7885e60ac4bc
* Fix the vector BETWEEN operator so that it only evaluates the left-mostdrh2016-08-22
| | | | | | vector expression once. Add support for vector comparisons in the CASE operator. FossilOrigin-Name: 07e69f43a294d35b5145a2b0242ee42d50adab14
* Fix where.c handling of "IN (SELECT ...)" expressions when the SELECT ↵dan2016-07-26
| | | | | returns more than one result column. Also error handling for other row value constructor cases. FossilOrigin-Name: 061b8006034f06a0311b4304c8b14d2c8b0153df
* Update evidence marks due to wording changes in requirements text. Nodrh2015-09-11
| | | | | changes to code. FossilOrigin-Name: 86781093bdb4c4fdedd228cb1c8961db48a483bb
* Add a few more requirements tests.drh2014-08-11
| | | FossilOrigin-Name: b5652439d5d770f0edeb80c8f55fa7cc515482e3
* Update requirements marks. No changes to code.drh2014-08-08
| | | FossilOrigin-Name: 7556bd9aa5db1b9cd92d0e48effcda9fe96f3128
* Update documentation of sqlite3_column() for clarity. Update evidence marksdrh2013-11-27
| | | | | on test cases. FossilOrigin-Name: ec2d47a1db2349d5c9b4fe465506e0e347f77921
* Add requirements test cases for determining when an expression is true anddrh2013-11-26
| | | | | when it is false. FossilOrigin-Name: 838654e56304a5788ac384ca506c1938f48af488
* Changing the CAST behavior of REAL values actually changed a documenteddrh2013-11-26
| | | | | | requirement. So we also have to change the requirement evidence text to match. FossilOrigin-Name: d84aa44e3919e25f9520c5120a35ec21e837a9ea
* Change the REAL-to-INTEGER casting behavior so that if the REAL valuedrh2013-11-26
| | | | | | | | | 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. FossilOrigin-Name: 6f53fc7106658d44edf63068f9a8522fa5a7688b
* Fix an requirement mark in a test script so that it matches thedrh2013-11-19
| | | | | typo-corrected requirement. No changes to code. FossilOrigin-Name: 072412d5e3f92c9c6548f5c86d396d3f024df3f7
* Updates to requirements marks. No code changes.drh2013-08-02
| | | FossilOrigin-Name: 213020769f310aec1591d97756b53891d0b64005
* Fix an error in e_expr.test.dan2013-06-27
| | | FossilOrigin-Name: fd4ece18c9be7019e60da3cb0a200c5b1903fed4
* Changes to various test scripts so that veryquick.test runs with ↵dan2012-02-13
| | | | | OMIT_COMPOUND_SELECT defined. FossilOrigin-Name: 76bb649ee2633226324130f5898622c348f93769
* Fix up requirements marks for syntax diagrams to reflect the new and improveddrh2011-12-30
| | | | | GIF renderings. FossilOrigin-Name: 1bb23a3b5297e07e08c26362f71aef0c5b978875
* Add retry logic for AV defense to winOpen. Also, refactor test suite to ↵mistachkin2011-08-02
| | | | | allow the key Tcl file operations (e.g. copy and delete) to be retried. FossilOrigin-Name: 9007586fdabed8dbcc78581ea9821cfd1f9a4c8c
* More typo fixes in evidence marks. No code changes.drh2011-06-20
| | | FossilOrigin-Name: e60eefc76fa5066720d76858f6cfca56365330ee
* Added ifcapable utf16 to a few test cases;shaneh2011-04-05
| | | FossilOrigin-Name: 57e0919b08e3b839b7c71011707a19ae2511a625
* Changes to test scripts so that they work with SQLITE_ENABLE_ICU.dan2010-11-01
| | | FossilOrigin-Name: 465c819fdb601961eddb7304642c823d78111992
* Fix broken evidence marks in e_expr.test.dan2010-10-04
| | | FossilOrigin-Name: 37ff94cec8a50d42c18f2253541bbcb0a6dfd0c3
* Add a few more subquery tests to e_expr.test.dan2010-09-03
| | | FossilOrigin-Name: 189cba0072dd0b90e064f889457921aeaeefda01
* Move the test for an (illegal) scalar sub-query that returns more than one ↵dan2010-09-02
| | | | | column to earlier in SELECT processing in order to avoid an assert() that can happen later on. FossilOrigin-Name: a55842cfb56b659c88832dce9ce7bafb50258211
* Add tests for the EXISTS operator to e_expr.test.dan2010-09-02
| | | FossilOrigin-Name: 9f9a95cc80961b2733d34bd66cfccfbffb358ed6
* Further tests for CAST in e_expr.test.dan2010-08-27
| | | FossilOrigin-Name: 9616df8c47ababc2d148f0ab6286efa84bd990fb
* Add tests for CAST expressions to e_expr.test. More to come.dan2010-08-26
| | | FossilOrigin-Name: ba6119d1e9300de9ce7448cfa0acd579e8e69e41
* Add tests to e_expr.test.dan2010-08-24
| | | FossilOrigin-Name: 5c1c694ee1b3b71e20089412f6cba1847dc7f958
* Add some tests to e_expr.test and pagerfault.test. No code changes.dan2010-08-21
| | | FossilOrigin-Name: 44de3cab9c89eb28485c0dc36d791b1c61d56b34
* Add tests for the BETWEEN operator to e_expr.test.dan2010-08-17
| | | FossilOrigin-Name: ced6a3480fe4a8e2b93160a8419bdc3ab30935e8
* Add test cases designed to exercise all syntax diagram paths in lang_expr.htmldan2010-08-16
| | | FossilOrigin-Name: d4a26bb629bc739a4bca16b5a876199aa9ecda43
* Add test case to e_expr.test.dan2010-08-14
| | | FossilOrigin-Name: db9539f2ceabd3c5a3eb5d4701f80f4e7da9344d
* Add test cases to e_expr.test.dan2010-08-14
| | | FossilOrigin-Name: d8bbab78fa56b076dfafb36daa7d6ef0b07f9a44
* Add tests to test file e_expr.test.dan2010-08-13
| | | FossilOrigin-Name: 3fd1059e25a8d0cccbb30fc55b03d172bd9eb9b7
* Enable previously failing tests in e_expr.test that pass following [3e5975aa3b].dan2010-07-19
| | | FossilOrigin-Name: 3d59c54a39c4c3149bf01063a91c3db35ec84b31
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-19 10:34:49 +0000