aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
| * Remove an unused variable from sqlite3SubqueryColumnTypes().drh2022-12-13
| | | | | | FossilOrigin-Name: c6e3ff396947e6954e77195419b35de8b39bd540d3f4bff456bab25b512e1792
| * Use standard datatype names for the column datatypes in views and subqueries.drh2022-12-13
| | | | | | FossilOrigin-Name: baf2c2413346feb72ecb0bac800be9b945ebb4e01b42212132434d8ddef9cad0
| * Refactor the sqlite3SelectAddColumnTypeAndCollation() routine. Improveddrh2022-12-13
| | | | | | | | | | comments. Now called sqlite3SubqueryColumnTypes(). FossilOrigin-Name: 4dfb1b450b87e2c6207c83c102b785781d1dbdeadbeeab6a83f96d58bb96cfbf
| * Slightly faster implementation of sqlite3ExprAffinity().drh2022-12-13
| | | | | | FossilOrigin-Name: 01cf3278c9c00dddcac67aa4b22ca26a52c31932cba35daa634a56b4c264bdeb
* | Merge recent trunk changes into the coroutine-exp2 branch.drh2022-12-13
|\| | | | | FossilOrigin-Name: c43f433bcab29db0f1f8afd3948f5a4149e1f277c853c66f99c31f226d82bc0f
| * Further fix for ticket [57c47526c34f01e8]. If a subquery has a result setdrh2022-12-12
| |\ | | | | | | | | | | | | | | | | | | column of the form "CAST(expr AS NUMERIC)" do not give that column NUMERIC affinity. NUMERIC affinity always goes to an integer if able, but a CAST to numeric is a no-op if the input is a number. So the two are not equivalent. FossilOrigin-Name: f0325359d5795237b79f90f21b42d7d942c7e918137cb0231d404365d3041e81
| | * If a subquery has a result column of the form "CAST(... AS NUMERIC)" thendrh2022-12-12
| | | | | | | | | | | | | | | | | | | | | | | | give that column no affinity rather than NUMERIC affinity. This is because casting to numeric preserves real values that could be integers but numeric affinity does not. By using no affinity on the column, we make the behavior consistent if the subquery is implemented as a co-routine or is materialized. FossilOrigin-Name: ece07d091c2ef3367a914187e0b6512c1f2390b8c34844536ad50e88c7e8c2f2
| * | Add new logging code SQLITE_NOTICE_RBU and use it when logging for the ↵dan2022-12-12
| |/ | | | | | | | | spurious error that RBU injects into SQLite as part of applying an update. FossilOrigin-Name: cd881d35150be7f28cc1ca1eca0e950b5a039bef61190fcae4f944ef0e91f234
| * Ensure that the types and collation sequences of a view are taken from the ↵dan2022-12-10
| | | | | | | | | | leftmost component of compound SELECTs, even when column names are explicitly provided for the view. Possible fix for [679ed6a2]. FossilOrigin-Name: b0e49aa81a09c183b8baf8346b8a9b593c2b13073958617b6594500958d5bd46
| * Fix typo in the SQLITE_DBCONFIG_LOOKASIDE documentation.drh2022-12-09
| | | | | | FossilOrigin-Name: c6e7582aea4ebcc4563afb4367fded1e8a74f6ef522a569460023c340ca24b30
| * Support ".scanstats est" to enable including planner estimates in query ↵dan2022-12-08
| | | | | | | | | | profiles. FossilOrigin-Name: 0fe71287c953bd813a34ba383f5debd4d1fc8bf3c74e1e27adacec0d6e207ded
| * Describe the SQLITE_DBCONFIG_RESET_DATABASE flag's policy regarding virtual ↵stephan2022-12-08
| | | | | | | | | | tables, per /chat discussion. FossilOrigin-Name: 53dcb81b029e4422bdc0b5cf694183854b997195427d437b6154ed4dad7ad0ba
* | Remove the SQLITE_PREPARE_SAFEOPT flag. The name is obsolete and it is at thedrh2022-12-09
| | | | | | | | | | wrong level. Instead use the SF_UpdateFrom flags on the Select object. FossilOrigin-Name: 78723a9a7e72b42d28fc5645661da17f20cedcf864819b861800ad9340007be1
* | Do not allow OOM faults in EQP messages associated with automatic indexesdrh2022-12-09
| | | | | | | | | | on co-routines to go unreported. FossilOrigin-Name: d125d5afdf1b0a1c64fc64f180898099af07b8290ea9da49419df75d8b455f71
* | Improved comments on the new co-routine logic. Fix a C++-ism in the code.drh2022-12-08
| | | | | | | | | | Update test cases to accommodate the more aggressive use of co-routines. FossilOrigin-Name: 9243e850ae656d16adc8f0e5c4dcf3dcf476312cee192c39c38685fc437ccbbd
* | Do not use a co-routine on a subquery that is participating in a self-join.drh2022-12-08
| | | | | | FossilOrigin-Name: ea4306a03cd8dd706100dac3f11653068a25c50c5d06c34ad08534aec0a580bc
* | Merge the latest fixes and enhancements from trunk into thedrh2022-12-07
|\| | | | | | | | | coroutines-exp2 branch. FossilOrigin-Name: 1c5f41986f5af181bf389675361c9f176e9195e847319f07ebd5c87992ded38b
| * Reduce the overhead of SQLITE_ENABLE_STMT_SCANSTATUS some.dan2022-12-07
| | | | | | FossilOrigin-Name: 212927e97e7be7d237de08359dce0dfb9211ac406b32009a6e15afd79c006475
| * Fix harmless compiler warning in the dynamic continuation prompt of the CLI.drh2022-12-07
| | | | | | FossilOrigin-Name: 68947b0a1147365a29e335d5e4dc55fe5d9afe3562a0709b111067d6017c5a42
| * Omit CLI use of pragma_table_xinfo when it is not defined in the build.larrybr2022-12-07
| | | | | | FossilOrigin-Name: 976c23520fa64b39aa54047f2fd12445e65940206768ce51c0d690d0d0d570ab
| * Have sqlite3_stmt_scanstatus() report cycle, loop and row counts separately ↵dan2022-12-07
| | | | | | | | | | for creating an automatic index and using that automatic index. FossilOrigin-Name: 3bc9df82ea5b0fb085c56a326a65e19c9baf98d48d8fa6344c0d7004747594ba
| * Streamline and improve testing of the locking in the memdb VFS.drh2022-12-07
| | | | | | | | | | Follow-on to [15f0be8a640e7bfa]. FossilOrigin-Name: d71a08375aeb525c10037c373b8eeb7e29f7dfaf7c4bfc02f4d99616c5940405
| * Fix a (harmless) off-by-one error in code generation that comes up whendrh2022-12-07
| | | | | | | | | | | | | | doing a DISTINCT query against a virtual table with an OR term in the WHERE clause and where the ORDER BY clause has 64 or more references to the result set. [forum:/forumpost/dfe8084751|Forum post dfe8084751]. FossilOrigin-Name: 04af7ef77043702f93cbff23548610759786893bd3d4d6fc08181e1e249c6663
| *-. Merge from trunk prepratory to branch end.larrybr2022-12-06
| |\ \ | | | | | | | | FossilOrigin-Name: 1d01f8483af7b6a4e93a49fd8bbb6a2b9300e969b574efeb96d56081a33055c4
| | | * Avoid several -Wall warnings in textfixture build.larrybr2022-12-06
| | |/ | | | | | | FossilOrigin-Name: 03ae8680e430c6d2c39ca26fa2cb6eed46e3c3e52b53f7a8bf548560446c6d3d
| | * Have sqlite3_stmt_scanstatus_v2() return an NCYCLE value for all loops, not ↵dan2022-12-06
| | | | | | | | | | | | | | | just virtual tables ones. The value returned is the sum of the NCYCLE counts for the various opcodes that move or read data from the table or index cursor associated with the loop. FossilOrigin-Name: 9499b2f51e8174c6b8a67840c92ba23b7dd1dc8dc2b91fca0c5dc07b71662149
| | * Clear a few more -Wall warnings and simplify dynaprompt feature keep/omit ↵larrybr2022-12-06
| | | | | | | | | | | | | | | macros. FossilOrigin-Name: 540e895d877fab1ea138786e56923a202018f68c78199a89adfc296c75735b30
| * | For CLI .sha3sum, emit warning to stderr for any invalidly encoded text fields.larrybr2022-12-06
| | | | | | | | | FossilOrigin-Name: 8e833ecc81367658e81acd1d3a0242ab954a62d6f719af56f1d185656d0b73e6
| * | Cause CLI .sha3sum to warn of text fields that do not survive CAST(CAST(t as ↵larrybr2022-12-03
| | | | | | | | | | | | | | | BLOB) AS TEXT) due to invalid UTF encoding. FossilOrigin-Name: 123f2a0785790addf9c60a0fd09077dda9cb84d33a2594901a2b22bb555be491
* | | Simplified experimental changes to promote the use of co-routines. Lessdrh2022-12-06
| |/ |/| | | | | | | | | cruft than the coroutines-exp1 branch, but still does not work. Checked in as a work-in-progress. FossilOrigin-Name: e2318a30bf6ad2aeb4c4cb29661bc24ff78eb51bf07decc4b8da1ecac0015ef0
* | Fix compiler warnings in the new dynamic continuation prompt logic ofdrh2022-12-06
| | | | | | | | | | the CLI. FossilOrigin-Name: 0d80500d358fa1c9b5867c2c8250d278ba813bf2ad81bb0bc3f820a71489b374
* | In the unix backend, when implementing the defenses against small filedrh2022-12-06
| | | | | | | | | | | | | | | | descriptors, delete a file just created if it was opened with O_EXCL|O_CREAT so that it can be created again the next time through the loop. Fix for the problem described by [forum:/forumpost/699af709ab3a8ccf|forum post 699af709ab3a8ccf]. FossilOrigin-Name: c0cfe0582add87981826d124a0763482f51fae4b105b5a970dd56919f1d04d60
* | Support an SQLITE_SCANSTAT_NCYCLE statistic for "CO-ROUTINE" elements.dan2022-12-06
| | | | | | FossilOrigin-Name: d3f6a207fd1b3f53688fa1ff35eb71e1c5bcc4115c0c35bb187d22ccf7100b71
* | Add optional feature: A CLI continuation prompt which reflects open lexemes ↵larrybr2022-12-06
|\ \ | | | | | | | | | | | | and parens, similarly to PG shell. FossilOrigin-Name: f41f18b1c3c950565ee3c237aebb51cfc3241813c6425813a8217e07aa0153a6
| * | Add optional feature: A CLI continuation prompt which reflects open lexemes ↵larrybr2022-12-06
| | | | | | | | | | | | | | | and parens, similarly to PG shell. FossilOrigin-Name: dac2ddc287db7a68d0cd49b785060f62290868fbb1aa2ee09e54d3b1acfbf55f
* | | Update comments in sqlite.h.in to account for sqlite3_stmt_scanstatus_v2().dan2022-12-05
| | | | | | | | | FossilOrigin-Name: 009462f2344b1f468cf9440343a47fec68d783a2bfb4fa6168bb227ec910b918
* | | Merge latest trunk changes.dan2022-12-05
|\| | | | | | | | FossilOrigin-Name: 1a72777b1279f74f212fb2f675a4594a238e5d28f048879d7f5ad5287673c3c4
| * | Fix a problem in the memdb vfs xLock() function allowing clients to upgrade ↵dan2022-12-05
| | | | | | | | | | | | | | | to EXCLUSIVE locks when other connections are holding SHARED. FossilOrigin-Name: 15f0be8a640e7bfa4130edd4650a745337bd96083b119a1553f9abf9ff066806
| * | Remove SQLITE_EXPERIMENTAL tag from sqlite3_vtab_collation() and fix a ↵stephan2022-12-05
| | | | | | | | | | | | | | | related doc typo. FossilOrigin-Name: 35d670b3593a46e13ded541ef477fa35dac6bcb9c31e6cf4b90bd7fa550a8ee2
| * | Remove obsolete "experimental" comments on the virtual-table interfacedrh2022-12-05
| | | | | | | | | | | | | | | documentation in sqlite.h.in. FossilOrigin-Name: 28fc32abdcb1c6af19f0926a3a7317e15930a0ba89645d5ffbf6ce99d8463273
| * | Improved query planner cost estimates. Fix for ticket [e8b674241947eb3b].drh2022-12-05
| |\ \ | | | | | | | | FossilOrigin-Name: 1b779afa3ed2f35a110e460fc6ed13cba744db85b9924149ab028b100d1e1e12
| | * | Use the smaller estimated row size for searching IPK tables, but use thedrh2022-12-05
| | | | | | | | | | | | | | | | | | | | | | | | original larger row size estimate for scanning, since the leaves can have large rows. FossilOrigin-Name: df3818997b822743ac407dde45c5fd75845ca40f461e31350d86963dffec6cd6
| | * | Increase the nominal row size for IPK index lookups slightly, for betterdrh2022-12-03
| | | | | | | | | | | | | | | | | | | | balance. FossilOrigin-Name: 1a61c500add4a2bfe80c0c691d559cfca166dc5f8262651a58da7ec16a51d430
| | * | Further improvements to the estimated cost of sorting. Take into accountdrh2022-12-03
| | | | | | | | | | | | | | | | | | | | the number of columns to be sorted. FossilOrigin-Name: f3290cf83b7c02d17d85d8942954f052b486c370cd5ec732969da9061dc1d19a
| | * | Tuning the query planner by adjusting the weights that predict the relativedrh2022-12-03
| | | | | | | | | | | | | | | | | | | | performance of sorting and index lookup. FossilOrigin-Name: 9f2806da4d88beceac2e81e05421f00481dd3dd100b096cd2ae6c828adb42ca7
| * | | Fix safe mode authorizer callback to reject disallowed UDFs. Reported at ↵larrybr2022-12-04
| | |/ | |/| | | | | | | | | | [forum:/forumpost/07beac8056151b2f|Forum post 07beac8056151b2f]. FossilOrigin-Name: cefc032473ac5ad244c0b6402c541b2f76c0c65a041bda03bfbe7c0e2c11fac2
| * | Doc typo fix for SQLITE_MAX_ALLOCATION_SIZE in malloc.c. No code changes.stephan2022-12-03
| | | | | | | | | FossilOrigin-Name: ed1ed21221b048ac5a5275cdfc4d9b2a406acdc7d4b648c3b61bcc822d88d955
| * | Move kvvfs xRead()/xWrite() buffer from function-local stack memory to heap ↵stephan2022-12-03
| |/ | | | | | | | | memory to accommodate changes in emsdk 3.1.27. FossilOrigin-Name: f1da32410ca7b808b3bef5f5a59766e7281e9e6ea343c8b979599bf1fc1060f5
* | Add loops and rows counters to "USE TEMP B-TREE FOR ORDER BY" records. Also ↵dan2022-12-05
| | | | | | | | | | fix the sqliteHwtime() function so that it returns a 64-bit value. FossilOrigin-Name: 41a0e05e8c0fca3b803fe4bd017a157c172b2ca518356a2a4d4ed4f12d01a1e3
* | Enhance SQLITE_SCANSTAT_NCYCLE so that it reports on virtual tables.dan2022-12-03
| | | | | | FossilOrigin-Name: 622d8eb3724bee617b55d6fb71f1a2d683db6858065adced6bf3ce9525bcd6b5
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-19 16:22:03 +0000