aboutsummaryrefslogtreecommitdiff
path: root/test
Commit message (Collapse)AuthorAge
...
| * A few simple test cases for the omit-unused-subquery-column optimization.drh2023-02-16
| | | | | | FossilOrigin-Name: cf8f57c53425d89619ece10edc197d7d28946d3b23fcb4f526330196c76d9cc1
| * Do not perform the omit-unused-subquery-columns optimizations on adrh2023-02-16
| | | | | | | | | | subquery that is DISTINCT, as that can lead to incorrect results. FossilOrigin-Name: cc148503db8ef180bce984328da7e84959afadd6a9613c2d03bc1eafeb95dfad
| * Do not compute result columns of subqueries that are never used. Make thosedrh2023-02-15
| | | | | | | | | | | | columns NULL instead. This optimization potentially resolves the enhancement request described by [/tktview/baa5bb76c35a124c|ticket baa5bb76c35a124c]. FossilOrigin-Name: 5dec3cc0225296a043d17f73126d477d90a604f82b3180628176d8f950adbce8
* | Remove the push-down optimization restriction that was added bydrh2023-02-22
| | | | | | | | | | | | | | | | check-in [1ad41840c5e0fa70] because it is no longer needed after the enhancements to compound query processing in check-in [27655c9353620aa5] This resolves the performance regression reported by [forum:/forumpost/bcc4375032|forum post bcc4375032]. FossilOrigin-Name: aa6bd6dff751223e302575c60f335707e4bb820bff716cab3706b564e18ed7ed
* | Fix stale requirement marks and fix a typo in the documentation fordrh2023-02-18
| | | | | | | | | | sqlite3_preupdate_hook(). FossilOrigin-Name: 655991f5d9afdd3281049eb430921046e0ba90eef215020c2fb149adc0d3c4c5
* | Fix a harmless typo in the test case added by [29fc06465efb948f].drh2023-02-17
| | | | | | FossilOrigin-Name: e0a0bf56f11f32f58705098e76c276deaf90cfa87e110032bdaad10ce9674f61
* | Do not allow the COUNTOFVIEW optimization to run if the count() containsdrh2023-02-17
|/ | | | | a FILTER clause. dbsqlfuzz 4f8e0de6e272bbbb3e1b41cb5aea31e0b47297e3 FossilOrigin-Name: 29fc06465efb948f98d2733bb25ffa1e0662a0189304006b3d0be9fec7dd28c5
* Update testrunner.tcl to run zipvfs test scripts on unix.dan2023-02-14
| | | FossilOrigin-Name: e6c8e19ab0d6e7526d4596b75a45bb6becaf3c029690f7e75c016eac803c9990
* Ignore extra parentheses around a subquery on the RHS of an IN operator,drh2023-02-13
| | | | | because that is what PostgreSQL does. FossilOrigin-Name: ecdeef43b27412b0b0b09e09a62ad3a03836a3fc80f2070268090e7ca8f02712
* Do not allow WHERE clause terms to match constant string index terms, whichdrh2023-02-13
| | | | | | can happen if DQS_DDL is enabled. Follow-up to [44200596aa943963]. dbsqlfuzz 54c9db85ed4af7055f5fd0d50877875c82b11d46. FossilOrigin-Name: 2d2b91cc0f6fed8cb6f738dc7019047ce0f1e86b5eb8efa997095d08a32cbcb6
* Allow vector-IN expressions like "(a, b) IN ( (?,?), (?,?) )" to use an index.dan2023-02-13
| | | FossilOrigin-Name: 1815b15ddb8785a25b7617aab19e13c2410b9377389c16a85176025b3d9400e8
* Do a better job of detecting when a WHERE clause term might be useful todrh2023-02-10
| | | | | | an expression index. Fix for performance regression reported by [forum:/forumpost/e65800d8cb|forum thread e65800d8cb]. FossilOrigin-Name: 44200596aa943963bc6ca98b5d4fd5b9235d1109d8dfc1a75eeae353b4239142
* New test cases added to fuzzdata8.db.drh2023-02-09
| | | FossilOrigin-Name: be67bafccd79ba835ed7e287e09852ce83805da0797b164d0c8e44be05d9d28a
* Back out the 'txn' enhancement to date/time functions. The duration of adrh2023-02-08
| | | | | | "transaction" is confused and needs to be straightened out prior to moving forward with this change. FossilOrigin-Name: 4a145f07322d768a07619bed27e0390d50f3a01d07787b9296234a5ceb6f1218
* Test cases to show that CURRENT_TIMESTAMP and similar hold the same valuedrh2023-02-08
| | | | | across a transaction. FossilOrigin-Name: 7b2fa20e31b8a0314b9ccb97bb556898d552505dbc5943f248df3f86c0f4e008
* Simplify the code and add test cases.drh2023-02-07
| | | FossilOrigin-Name: d3bed4caff561e71c396cc869c5b4d9bf216ba203485e738c12ec62741f1aba5
* Remove the long obsolete "client/server" mode tests.drh2023-02-06
| | | FossilOrigin-Name: 08e3114caec0633fc54f8febb7f4732b46a1f47508bbca0a6a2bff02591254d5
* Update test scripts speed1.test and speed1p.test so they may be run by ↵dan2023-02-06
| | | | | testrunner.tcl. FossilOrigin-Name: e761d4b9c8dcacccc927d23f20fdf779a0ae5304281b5bd6aa998bade56f0a37
* Shorten the status line for testrunner.tcl so that it fits on an 80-characterdrh2023-02-06
| | | | | terminal. FossilOrigin-Name: b760a7307c453d95cf3b302c9867c84a9c899956c16c2ce1ea6cce8f025db425
* Fix a formatting problem in scanstatus2.test introduced by [81c118d9].dan2023-02-06
| | | FossilOrigin-Name: 928ab40edbf11c02b3f03e660051d9587243002b9220adc77f972c3758c12b19
* Add the --fuzztest option to testrunner.tcl. Also, have it print whitespace ↵dan2023-02-06
| | | | | over the top of the old report line before writing the new. FossilOrigin-Name: d83ce01fe1f21edcc93ad4c6308026156f235bab75e16e15389e27ad388fb274
* Fix problems with test scripts preventing them from running with ↵dan2023-02-06
| | | | | SQLITE_DEFAULT_MEMSTATUS=0 builds. Or builds without SQLITE_ENABLE_STAT4. FossilOrigin-Name: c0fbc89ed26b6eb361c1a05e2fb0d78d101fe2daf2947bbe5e0e58e0c2a779a2
* Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds.dan2023-02-06
| | | FossilOrigin-Name: 81c118d90b281b30f40b3eeefaeb2c8350aa40080b4fe7de8f21d263986c6acb
* Do not use a Bloom filter if any outer loop lacks STAT1 data, since withoutdrh2023-02-05
| | | | | | | STAT1 data, the query planner cannot make an accurate determination of whether or not a Bloom filter will be useful. This fixes the problem reported by [forum:/forumpost/56de336385|forum post 56de336385]. FossilOrigin-Name: e6ab96bd0b9efc51fd703bf7e92b079943ad9a3b92183d434adc11fb7d238afb
* In fuzzcheck, only show the description of each database if the -v optiondrh2023-02-05
| | | | | is specified. FossilOrigin-Name: 6a58179aaffa77a5542ab620ffce6f68135e399de957b1a97113fd2f1dc0c098
* Modify the status line output from testrunner so that each line overwritesdrh2023-02-05
| | | | | the previous rather than scrolling. FossilOrigin-Name: ad4d28cd68589a9259069c77c8d375ae49cfd0bcdf3b03d3e84418569e12ebfc
* Avoid running rbu tests under permutation "journaltest", which does not ↵dan2023-02-04
| | | | | support wal. Fix some other test script problems. FossilOrigin-Name: 92f018698a87ed32acc31d83f7246dbb7295867bd6a801b7984a16f97a5c7786
* Changes so that wapptest.tcl still works.dan2023-02-04
| | | FossilOrigin-Name: 7624de3a93e03e9e825b1a283ccde8ad3aa41f93dd5c7f63692620a5177cbda9
* Update testrunner.tcl usage message.dan2023-02-04
| | | FossilOrigin-Name: b7c246bc3f462098f6281ee2cd2e4e870b6d6481263d277f04956596a4764558
* Add testrunner.tcl "njob" and "status" commands.dan2023-02-04
| | | FossilOrigin-Name: 3869cd3d306ed68ec6e118aa10b4e835f2bab1294039888d88a30b3cfcf1d7be
* Fixes for testrunner.tcl on windows.dan2023-02-03
| | | FossilOrigin-Name: b98e19fc41cb7f89ae9e063b8af414bc01d14833a14de5d646069483ef0127b2
* Have testrunner.tcl run various builds as part of the 'release' command.dan2023-02-03
| | | FossilOrigin-Name: ba2fae30a81e2574f13a7351c9f843b8c2c7d2c93fcd71fb2de98f5b34f3e109
* Avoid using Tcl command [clock] in testrunner.tcl.dan2023-02-03
| | | FossilOrigin-Name: b2faf9289f6fbbcd4491e1b063da731b35aeed9ff1fc97f64798e99cac847b4a
* Do not run test script pendingrace.test as part of the inmemory_journal ↵dan2023-02-02
| | | | | permutation. FossilOrigin-Name: 69d934a1bfad86f3f60dab146db539645f5735f1bdb07dfe3a3d88828a03390b
* Add configuration data for osx and windows to testrunner_data.tcldan2023-02-02
| | | FossilOrigin-Name: e45d34656a110f85671d8b5d33f0d6d807fd64dfef5777fefba22ac6836f0e86
* Update testrunner.tcl to use a separate process for each test script. And to ↵dan2023-02-01
| | | | | run some extra tests too. FossilOrigin-Name: d090948a69a9c4b86693bd3caedba3d7e5883e4b2ad1f2d4bf7ae14c105ddea7
* Just because a CTE is used more than once, does not mean it should bedrh2023-02-01
| | | | | | | tagged with M10d_Yes and thereby prohibited from participating in the query flattening optimization. See [forum:/forumpost/1d571c02963355ed|forum thread 1d571c02963]. FossilOrigin-Name: 66f29c403d28630bfaea9124bd63ee4a047b1fe4a7e27dc5d10d67d1601b15e0
* Fix a race condition during hot-journal rollback that could theoretically ↵dan2023-01-31
| | | | | cause spurious corruption errors. FossilOrigin-Name: 20ea53ddf590a9dd19501fabd2bfdb9c10b5eb265cd2995bdb335769c936c763
* Additional tweaks to the enhancement at [609fbb94b8f01d67] to further reducedrh2023-01-30
| | | | | | | the cost estimate for constructing an automatic index on an ephemeral table, in order to resolve the performance problem described by [forum:/forumpost/1d571c0296|forum post 1d571c0296]. FossilOrigin-Name: bf1aae7a8c7f2c74681aa29baa35259d10ce6a1737d2607def6bf27fed592131
* Fix a problem causing "PRAGMA quick_check" to return spurious corruption ↵dan2023-01-28
| | | | | errors for a WITHOUT ROWID for which all columns are either virtual or part of the primary key, and for which the order of the columns in the primary key definition is different from the order in the table. FossilOrigin-Name: a7530f897127f35a212db6557edbcbbb286cc0e094754c1c1b74ce8dbf724470
* Update sqllimits1.test to account for the fact that if an odd value is ↵dan2023-01-28
| | | | | specified as the length in bytes of a utf-16 string, it is truncated to the largest smaller even number. FossilOrigin-Name: 74508470c4caff04638e750cd84073f3137b8a9f72c6fe390a279da7b1c13398
* Have some RBU tests run as part of veryquick.test/testrunner.tcl.dan2023-01-26
| | | FossilOrigin-Name: f51406e3bf92f2b46f13d08fb7c7fe7683feba68b5a8fa18f6f6b8845662deac
* Fix a problem with fts3 auxiliary functions and one or more NEAR expressions ↵dan2023-01-25
| | | | | ORed together. FossilOrigin-Name: de4690a10ad4631e7452ccbb05b177a821d9dda387a854d216a6c54c7a189ead
* Fix another problem with fts3/4 auxiliary functions and NEAR expressions ↵dan2023-01-25
| | | | | that consist entirely of deferred tokens. FossilOrigin-Name: a8c91c132f6157b7e3649f57a799984b1d7f8a18fd434515c875617d4195db29
* Add scalar SQL function unhex().dan2023-01-24
|\ | | | | FossilOrigin-Name: 890e9629a7480138c9c1d3acc2d1e7b3c05e0d156e5c5fba428bc1aeb790fbfb
| * Update unhex() to allow a second argument, specifying a set of characters ↵dan2023-01-24
| | | | | | | | | | that are permitted to appear between pairs of hexadecimal digits. FossilOrigin-Name: 66c8562690b19f17972589611810e1dccad3a48777acb05208289c1f77076f71
| * Add experimental user function unhex().dan2023-01-23
| | | | | | FossilOrigin-Name: dbe424b5db33ce2c7562dfb44daf2969cf3074234cc891eb9b8d0d907faf6a78
* | Fix a problem with using fts3 auxiliary functions with expressions like "E ↵dan2023-01-24
|/ | | | | AND ...", where E is a NEAR expression that consists entirely of deferred tokens. FossilOrigin-Name: 39bfae4c4698a13e07c4a0725f2790955e03b601fe64e17a000c691def1bdcb8
* Extend the carray extension to allow the use of BLOB values to be bounddrh2023-01-20
| | | | | as an array of "struct iovec" objects. FossilOrigin-Name: e117a03ca6560e958884f277db827c51ae337a970c17143a0a5f9b150f52f87a
* Ensure that the database encoding cannot be changed while there are ↵dan2023-01-20
| | | | | statements running. And that the connection is left in a valid state after an obscure OOM within sqlite3_deserialize(). FossilOrigin-Name: a02da71f3a80dd8e817e89cdaa775c95e38c90d2471f8fec516bed086539e2c0
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-21 19:16:46 +0000