971ed34399- Update to release 3.48.0: * Improved EXPLAIN QUERY PLAN output for covering indexes. * Allow a two-argument version of the iif() SQL function. * Also allow if() as an alternative spelling for iif(). * Add the ".dbtotxt" command to the CLI. * Add the SQLITE_IOCAP_SUBPAGE_READ property to the xDeviceCharacteristics method of the sqlite3_io_methods object. * Add the SQLITE_PREPARE_DONT_LOG option to sqlite3_prepare_v3() that prevents warning messages being sent to the error log if the SQL is ill-formed. This allows sqlite3_prepare_v3() to be used to do test compiles of SQL to check for validity without polluting the error log with false messages. * Increase the minimum allowed value of SQLITE_LIMIT_LENGTH from 1 to 30. * Added the SQLITE_FCNTL_NULL_IO file control. * Extend the FTS5 auxiliary API xInstToken() to work with prefix queries via the insttoken configuration option and the fts5_insttoken() SQL function. * Increase the maximum number of arguments to an SQL function from 127 to 1000. * Obsoletes sqlite3-6216bfcb.patch .
Reinhard Max
2025-01-14 15:48:55 +00:00
f000a911f6Accepting request 1231554 from server:database
Ana Guerrero
2024-12-17 18:22:37 +00:00
a619ae7e47- Add sqlite3-6216bfcb.patch to fix a test suite regression in 3.47.0 on s390x. Only the test was broken, not the code itself. https://sqlite.org/forum/forumpost/7b2bab04c5
Reinhard Max
2024-12-16 16:12:19 +00:00
678f641dd2Accepting request 1229466 from server:database
Ana Guerrero
2024-12-10 22:43:09 +00:00
4fc604a019- Update to release 3.47.2: * Fix a problem in text-to-floating-point conversion that affects text values where the first 16 significant digits are '1844674407370955'. This issue was introduced in 3.47.0 and only arises on x64 and i386 hardware. * Other minor bug fixes. - Enable the session extension, because NodeJS 22 needs it.
Reinhard Max
2024-12-09 11:54:34 +00:00
32ab9a8aaeAccepting request 1227134 from server:database
Ana Guerrero
2024-11-30 12:27:12 +00:00
4ccecc7c0d- Update to release 3.47.1: * Fix the makefiles so that they once again honored DESTDIR for the "install" target. * Add the SQLITE_IOCAP_SUBPAGE_READ capability to the VFS, to work around issues on some non-standard VFSes caused by making SQLITE_DIRECT_OVERFLOW_READ the default in version 3.45.0. * Fix incorrect answers to certain obscure IN queries caused by new query optimizations added in the 3.47.0 release. * Other minor bug fixes.
Reinhard Max
2024-11-27 10:20:37 +00:00
ec440d9598Accepting request 1219501 from server:database
Dominique Leuenberger
2024-10-31 15:09:18 +00:00
cb98afc20c- Update to release 3.46.1: * Improved robustness while parsing the tokenize= arguments in FTS5. * Enhancements to covering index prediction in the query planner. * Do not let the number of terms on a VALUES clause be limited by SQLITE_LIMIT_COMPOUND_SELECT, even if the VALUES clause contains elements that appear to be variables due to double-quoted string literals. * Fix the window function version of group_concat() so that it returns an empty string if it has one or more empty string inputs. * In FTS5 secure-delete mode, fix false-positive integrity-check reports about corrupt indexes. * Syntax errors in ALTER TABLE should always return SQLITE_ERROR. In some cases, they were formerly returning SQLITE_INTERNAL. * Other minor fixes.
Reinhard Max
2024-09-24 11:42:43 +00:00
2a591df592Accepting request 1176758 from server:database
Ana Guerrero
2024-05-28 15:27:19 +00:00
954b6b2caa- Update to release 3.46.0: * https://sqlite.org/releaselog/3_46_0.html * Enhance PRAGMA optimize in multiple ways. * Enhancements to the date and time functions. * Add support for underscore ("_") characters between digits in numeric literals. * Add the json_pretty() SQL function. * Query planner improvements. * Allocate additional memory from the heap for the SQL parser stack if that stack overflows, rather than reporting a "parser stack overflow" error. * Allow ASCII control characters within JSON5 string literals. * Fix the -> and ->> JSON operators so that when the right-hand side operand is a string that looks like an integer it is still treated as a string, because that is what PostgreSQL does. * Obsoletes sqlite3-float-i586.patch.
Reinhard Max
2024-05-23 19:30:28 +00:00
6d5984446fAccepting request 1169661 from server:database
Ana Guerrero
2024-04-26 21:26:26 +00:00
155638d144- Update to release 3.45.3: * Fix a long-standing bug (going back to version 3.24.0) that might (rarely) cause the "old.*" values of an UPDATE trigger to be incorrect if that trigger fires in response to an UPSERT. * Reduce the scope of the NOT NULL strength reduction optimization that was added as item 8e in version 3.35.0. The optimization was being attempted in some contexts where it did not work, resulting in incorrect query results. - Add SQLITE_STRICT_SUBTYPE=1 as recommended by upstream.
Reinhard Max
2024-04-18 08:29:52 +00:00
6d6a8c75e3Accepting request 1158281 from server:database
Ana Guerrero
2024-03-17 21:13:29 +00:00
9fe3cba2c3- Add sqlite3-float-i586.patch to fix build on i586. - sqlite3-rtree-i686.patch is not needed anymore.
Reinhard Max
2024-03-15 14:57:36 +00:00
0c4f7bcc97- Update to release 3.45.2: * Added the SQLITE_RESULT_SUBTYPE property for application- defined SQL functions. * Enhancements to the JSON SQL functions * Add the FTS5 tokendata option to the FTS5 virtual table. * The SQLITE_DIRECT_OVERFLOW_READ optimization is now enabled by default. * Query planner improvements * Increase the default value for SQLITE_MAX_PAGE_COUNT from 1073741824 to 4294967294. * Enhancements to the CLI * Restore the JSON BLOB input bug, and promise to support the anomaly in subsequent releases, for backward compatibility. * Fix the PRAGMA integrity_check command so that it works on read-only databases that contain FTS3 and FTS5 tables. * Fix issues associated with processing corrupt JSONB inputs. * Fix a long-standing bug in which a read of a few bytes past the end of a memory-mapped segment might occur when accessing a craftily corrupted database using memory-mapped database. * Fix a long-standing bug in which a NULL pointer dereference might occur in the bytecode engine due to incorrect bytecode being generated for a class of SQL statements that are deliberately designed to stress the query planner but which are otherwise pointless. * Fix an error in UPSERT, introduced in version 3.35.0. * Reduce the scope of the NOT NULL strength reduction optimization that was added in version 3.35.0.
Reinhard Max
2024-03-12 14:59:03 +00:00
f5416321bb- Update to release 3.45.1 * Details will follow... - Abort build when %version and %tarversion don't match.
Reinhard Max
2024-01-30 18:08:35 +00:00
94b67df5adAccepting request 1133118 from server:database
Ana Guerrero
2023-12-15 20:47:09 +00:00
b8b8403beeAccepting request 1131615 from home:dimstar:Factory
Reinhard Max
2023-12-11 08:08:59 +00:00
88c75defdfAccepting request 1130837 from server:database
Ana Guerrero
2023-12-05 16:02:45 +00:00
41cf744a23- Update to release 3.44.2 * Fix a mistake in the CLI that was introduced by the fix in 3.44.1. * Fix a problem in FTS5 that was discovered during internal fuzz testing only minutes after the 3.44.1 release was tagged. * Fix incomplete assert() statements that the fuzzer discovered. * Fix a couple of harmless compiler warnings that appeared in debug builds with GCC 16.
Reinhard Max
2023-11-27 18:18:37 +00:00
78d06b5581- Update to release 3.44.1 * Change the CLI so that it uses UTF-16 for console I/O on Windows. * Other obscure bug fixes.
Reinhard Max
2023-11-22 17:34:30 +00:00
c19bfcdb2bAccepting request 1123976 from server:database
Ana Guerrero
2023-11-08 21:16:42 +00:00
89ae143f90Accepting request 1123191 from home:jengelh:branches:server:database
Reinhard Max
2023-11-07 12:45:51 +00:00
1173f8e2f8Accepting request 1119230 from server:database
Ana Guerrero
2023-10-20 21:16:05 +00:00
e3d4d193d7- sqlite3-rtree-i686.patch: temporary build fix for 32-bit x86.
Reinhard Max
2023-10-19 13:30:43 +00:00
3d3f0ad76c- Update to: 3.42.2: * Fix a couple of obscure UAF errors and an obscure memory leak. * Omit the use of the sprintf() function from the standard library in the CLI, as this now generates warnings on some platforms. * Avoid conversion of a double into unsigned long long integer, as some platforms do not do such conversions correctly.
Reinhard Max
2023-10-10 16:05:16 +00:00
148ae3d8b6- Update to: 3.43.1 * Fix a regression in the way that the sum(), avg(), and total() aggregate functions handle infinities. * Fix a bug in the json_array_length() function that occurs when the argument comes directly from json_remove(). * Fix the omit-unused-subquery-columns optimization (introduced in in version 3.42.0) so that it works correctly if the subquery is a compound where one arm is DISTINCT and the other is not.
Reinhard Max
2023-09-11 14:50:47 +00:00
37c084e88bAccepting request 1106058 from home:amanzini:branches:server:database
Martin Pluskal
2023-08-31 08:06:24 +00:00
1502fa914aAccepting request 1087547 from server:database
Dominique Leuenberger
2023-05-18 13:18:19 +00:00
94156a4c52- Update to 3.42.0: * Add the FTS5 secure-delete command. This option causes all forensic traces to be removed from the FTS5 inverted index when content is deleted. * Enhance the JSON SQL functions to support JSON5 extensions. * The SQLITE_CONFIG_LOG and SQLITE_CONFIG_PCACHE_HDRSZ calls to sqlite3_config() are now allowed to occur after sqlite3_initialize(). * New sqlite3_db_config() options: SQLITE_DBCONFIG_STMT_SCANSTATUS and SQLITE_DBCONFIG_REVERSE_SCANORDER. * Query planner improvements. * Add the --unsafe-testing command-line option. * Allow commands ".log on" and ".log off", even in --safe mode. * "--" as a command-line argument means all subsequent arguments that start with "-" are interpreted as normal non-option argument. * Magic parameters ":inf" and ":nan" bind to floating point literals Infinity and NaN, respectively. * Add the ability for application-defined SQL functions to have the same name as join keywords: CROSS, FULL, INNER, LEFT, NATURAL, OUTER, or RIGHT. * Enhancements to PRAGMA integrity_check * Allow the session extension to be configured to capture changes from tables that lack an explicit ROWID. * Added the subsecond modifier to the date and time functions. * Negative values passed into sqlite3_sleep() are henceforth interpreted as 0. * The maximum recursion depth for JSON arrays and objects is lowered from 2000 to 1000.
Reinhard Max
2023-05-17 09:36:33 +00:00
322f239800Accepting request 1073837 from server:database
Dominique Leuenberger
2023-03-24 14:16:15 +00:00
e14d797334- Update to 3.41.2: * Multiple fixes for reads past the end of memory buffers * Fix the sqlite3_error_offset() so that it does not return out-of-range values when reporting errors associated with generated columns. * Multiple fixes in the query query optimizer for problems that cause incorrect results for bizarre, fuzzer-generated queries. * Increase the size of the reference counter in the page cache object to 64 bits to ensure that the counter never overflows. * Fix a performance regression caused by a bug fix in patch release 3.41.1. * Fix a few incorrect assert() statements.
Reinhard Max
2023-03-22 15:25:48 +00:00
5b479316edAccepting request 1072680 from home:AndreasStieger:branches:server:database
Reinhard Max
2023-03-21 15:10:35 +00:00
b9c0c84f37Accepting request 1071411 from server:database
Dominique Leuenberger
2023-03-15 17:53:14 +00:00
83e27cb4e6Accepting request 1070137 from home:pluskalm:branches:server:database
Martin Pluskal
2023-03-14 08:38:46 +00:00
8a4ae13ce3Accepting request 1067149 from server:database
Dominique Leuenberger
2023-02-23 15:28:13 +00:00
e42e2b9682- Update to 3.41.0: * https://www.sqlite.org/releaselog/3_41_0.html * Various query planner improvements. * Add the built-in unhex() SQL function. * Add the base64 and base85 application-defined functions as an extension and include that extension in the CLI. * In-memory databases created using sqlite3_deserialize() now report their filename as an empty string, not as 'x'. * The ".scanstats est" command provides query planner estimates in profiles. * Enhance the --safe command-line option to disallow dangerous SQL functions. * The double-quoted string misfeature is now disabled by default for CLI builds. * Various other improvements and performance enhancements.
Reinhard Max
2023-02-22 10:09:14 +00:00
e075a7838eAccepting request 1056142 from server:database
Dominique Leuenberger
2023-01-07 16:15:52 +00:00
88d34e2effAccepting request 1045679 from home:AndreasStieger:branches:server:database
Martin Pluskal
2023-01-05 08:30:09 +00:00
41bbe4ffb8Accepting request 1043393 from server:database
Dominique Leuenberger
2022-12-17 19:35:57 +00:00
989c4161c9- bsc#1206337, CVE-2022-46908, sqlite-CVE-2022-46908.patch: relying on --safe for execution of an untrusted CLI script
Reinhard Max
2022-12-13 16:12:14 +00:00
8f855f4179Accepting request 1037900 from server:database
Dominique Leuenberger
2022-11-25 12:11:22 +00:00
603599aa93Accepting request 1033127 from server:database
Dominique Leuenberger
2022-11-04 16:32:11 +00:00
787b628579Accepting request 1032953 from home:AndreasStieger:branches:server:database
Reinhard Max
2022-11-03 15:54:49 +00:00
8394eb7bd6Accepting request 1004661 from server:database
Dominique Leuenberger
2022-09-19 14:39:39 +00:00
8fb7a2b6da* bsc#1189802, CVE-2021-36690: Fix an issue with the SQLite Expert extension when a column has no collating sequence.
Reinhard Max
2022-09-12 09:20:10 +00:00
5ab829baa4Accepting request 1001301 from server:database
Dominique Leuenberger
2022-09-06 11:00:37 +00:00
40bb6fef9c- update to 3.39.3: * Use a statement journal on DML statement affecting two or more database rows if the statement makes use of a SQL functions that might abort. * Use a mutex to protect the PRAGMA temp_store_directory and PRAGMA data_store_directory statements, even though they are decremented and documented as not being threadsafe.
Reinhard Max
2022-09-05 15:20:33 +00:00
db850fbdfdAccepting request 991047 from server:database
Richard Brown
2022-07-26 17:42:21 +00:00
30186d2a5aAccepting request 990677 from home:AndreasStieger:branches:server:database
Reinhard Max
2022-07-25 13:52:39 +00:00
b10f552687- update to 3.39.2: * Fix a performance regression in the query planner associated with rearranging the order of FROM clause terms in the presences of a LEFT JOIN. * Apply fixes for CVE-2022-35737, Chromium bugs 1343348 and 1345947, forum post 3607259d3c, and other minor problems discovered by internal testing.
Reinhard Max
2022-07-21 17:13:33 +00:00
c070330dbfAccepting request 989477 from home:AndreasStieger:branches:server:database
Reinhard Max
2022-07-18 10:24:56 +00:00
4fcb758eecAccepting request 989013 from server:database
Dominique Leuenberger
2022-07-14 14:33:25 +00:00
8c683ec588Accepting request 986303 from home:AndreasStieger:branches:server:database
Reinhard Max
2022-07-13 14:47:10 +00:00
38c80b0039Accepting request 986280 from home:AndreasStieger:branches:server:database
Lars Vogdt
2022-07-01 19:42:51 +00:00
fa350a13aaAccepting request 976547 from server:database
Dominique Leuenberger
2022-05-14 20:52:07 +00:00
6cf8e942d7Accepting request 975631 from home:AndreasStieger:branches:server:database
Reinhard Max
2022-05-12 06:15:29 +00:00
146d3dc6beAccepting request 974414 from server:database
Dominique Leuenberger
2022-05-04 13:10:40 +00:00
52ec937b8fAccepting request 973534 from home:polslinux:branches:server:database
Reinhard Max
2022-05-02 12:00:47 +00:00
af6af228baAccepting request 965652 from server:database
Dominique Leuenberger
2022-04-01 19:34:51 +00:00
c464d12817- update to 3.38.2: * Fix a problem with the Bloom filter optimization that might cause an incorrect answer when doing a LEFT JOIN with a WHERE clause constraint that says that one of the columns on the right table of the LEFT JOIN is NULL. * Other minor patches.
Reinhard Max
2022-03-29 11:46:41 +00:00
c9c9f6d2d8- Remove obsolete configure flags - Package the Tcl bindings here again so that we only ship one copy of SQLite (bsc#1195773). - Use dynamic linking for the sqlite3 shell.
Reinhard Max
2022-03-16 18:44:06 +00:00
c2b2d7c241Accepting request 961697 from server:database
Dominique Leuenberger
2022-03-15 18:04:12 +00:00
d3d0e359feAccepting request 961694 from home:AndreasStieger:branches:server:database
Reinhard Max
2022-03-14 14:15:05 +00:00
c7eaffc52dAccepting request 961471 from home:AndreasStieger:branches:server:database
Reinhard Max
2022-03-14 11:10:19 +00:00
4f59238ce3Accepting request 957745 from home:AndreasStieger:branches:server:database
Martin Pluskal
2022-03-09 09:09:18 +00:00
8011cbf5c1Accepting request 946796 from server:database
Dominique Leuenberger
2022-01-19 23:11:49 +00:00
d43b785c99Accepting request 945927 from home:AndreasStieger:branches:server:database
Reinhard Max
2022-01-16 14:07:07 +00:00
13799e2e9cAccepting request 943473 from server:database
Dominique Leuenberger
2022-01-13 22:20:47 +00:00
6b2ed16806Accepting request 943471 from home:AndreasStieger:branches:server:database
Reinhard Max
2022-01-02 13:02:42 +00:00
b46ae693e3- SQLite3 3.37.0: * STRICT tables provide a prescriptive style of data type management, for developers who prefer that kind of thing. * When adding columns that contain a CHECK constraint or a generated column containing a NOT NULL constraint, the ALTER TABLE ADD COLUMN now checks new constraints against preexisting rows in the database and will only proceed if no constraints are violated. * Added the PRAGMA table_list statement. * Add the .connection command, allowing the CLI to keep multiple database connections open at the same time. * Add the --safe command-line option that disables dot-commands and SQL statements that might cause side-effects that extend beyond the single database file named on the command-line. * CLI: Performance improvements when reading SQL statements that span many lines. * Added the sqlite3_autovacuum_pages() interface. * The sqlite3_deserialize() does not and has never worked for the TEMP database. That limitation is now noted in the documentation. * The query planner now omits ORDER BY clauses on subqueries and views if removing those clauses does not change the semantics of the query. * The generate_series table-valued function extension is modified so that the first parameter ("START") is now required. This is done as a way to demonstrate how to write table-valued functions with required parameters. The legacy behavior is available using the -DZERO_ARGUMENT_GENERATE_SERIES compile-time option. * Added new sqlite3_changes64() and sqlite3_total_changes64() interfaces. * Added the SQLITE_OPEN_EXRESCODE flag option to sqlite3_open_v2(). * Use less memory to hold the database schema.
Reinhard Max
2021-11-30 09:16:25 +00:00
8c9502e57eAccepting request 902392 from server:database
Dominique Leuenberger
2021-06-28 13:33:28 +00:00
5bff214348Accepting request 901301 from home:polslinux:branches:server:database
Reinhard Max
2021-06-25 13:38:01 +00:00
17f33a0e1dAccepting request 887264 from server:database
Dominique Leuenberger
2021-04-22 16:03:28 +00:00
4c5ecbbdeaAccepting request 886927 from home:AndreasStieger:branches:server:database
Reinhard Max
2021-04-21 10:08:49 +00:00
291d62e191Accepting request 886908 from home:dirkmueller:Factory
Reinhard Max
2021-04-20 08:14:11 +00:00
2b5cf2c709Revert the merging of SLE-12 bug references into the changes file
Reinhard Max
2021-04-13 13:40:51 +00:00
fe9c70dea4More merges from SLE12 to the changes file
Reinhard Max
2021-04-06 17:22:46 +00:00
c767c076faAccepting request 882778 from home:AndreasStieger:branches:server:database
Reinhard Max
2021-04-06 14:56:53 +00:00
98346ec9c1- The following CVEs have been fixed in upstream releases up to this point, but were not mentioned in the chane log so far: * bsc#1173641, CVE-2020-15358: heap-based buffer overflow in multiSelectOrderBy due to mishandling of query-flattener optimization * bsc#1164719, CVE-2020-9327: NULL pointer dereference and segmentation fault because of generated column optimizations in isAuxiliaryVtabOperator * bsc#1160439, CVE-2019-20218: selectExpander in select.c proceeds with WITH stack unwinding even after a parsing error * bsc#1160438, CVE-2019-19959: memory-management error via ext/misc/zipfile.c involving embedded '＼0' input * bsc#1160309, CVE-2019-19923: improper handling of certain uses of SELECT DISTINCT in flattenSubquery may lead to null pointer dereference * bsc#1159850, CVE-2019-19924: improper error handling in sqlite3WindowRewrite() * bsc#1159847, CVE-2019-19925: improper handling of NULL pathname during an update of a ZIP archive * bsc#1159715, CVE-2019-19926: improper handling of certain errors during parsing multiSelect in select.c * bsc#1159491, CVE-2019-19880: exprListAppendList in window.c allows attackers to trigger an invalid pointer dereference * bsc#1158960, CVE-2019-19603: during handling of CREATE TABLE and CREATE VIEW statements, does not consider confusion with a shadow table name * bsc#1158959, CVE-2019-19646: pragma.c mishandles NOT NULL in an integrity_check PRAGMA command in certain cases of generated columns * bsc#1158958, CVE-2019-19645: alter.c allows attackers to trigger infinite recursion via certain types of self-referential views in conjunction with ALTER TABLE statements * bsc#1158812, CVE-2019-19317: lookupName in resolve.c omits bits from the colUsed bitmask in the case of a generated column, which allows attackers to cause a denial of service * bsc#1157818, CVE-2019-19244: sqlite3,sqlite2,sqlite: The function sqlite3Select in select.c allows a crash if a sub-select uses both DISTINCT and window functions, and also has certain ORDER BY usage * bsc#928701, CVE-2015-3415: sqlite3VdbeExec comparison operator vulnerability * bsc#928700, CVE-2015-3414: sqlite3,sqlite2: dequoting of collation-sequence names * CVE-2018-20346, bsc#1119687: remote code execution vulnerability in FTS3 (Magellan).
Reinhard Max
2021-04-01 10:56:15 +00:00
b5d6038452Accepting request 880148 from server:database
Dominique Leuenberger
2021-03-21 22:19:31 +00:00
fa38ede2d7Accepting request 880128 from home:marxin:branches:server:database
Reinhard Max
2021-03-19 16:18:37 +00:00
e7732c1be7Accepting request 879748 from home:AndreasStieger:branches:server:database
Reinhard Max
2021-03-18 08:32:44 +00:00
ab763fc6c0Accepting request 879153 from server:database
Richard Brown
2021-03-16 14:43:04 +00:00
b311b5d183Accepting request 879097 from home:dirkmueller:Factory
Reinhard Max
2021-03-15 11:04:30 +00:00
b1ce85ade3Accepting request 866634 from server:database
Dominique Leuenberger
2021-01-30 12:55:25 +00:00
c129602d4dAccepting request 865503 from home:AndreasStieger:branches:server:database
Reinhard Max
2021-01-25 15:23:22 +00:00
30c39510b9Accepting request 852646 from server:database
Dominique Leuenberger
2020-12-05 19:36:08 +00:00
30b3f3ad53- SQLite 3.34.0: * Added the sqlite3_txn_state() interface for reporting on the current transaction state of the database connection. * Enhance recursive common table expressions to support two or more recursive terms as is done by SQL Server, since this helps make queries against graphs easier to write and faster to execute.\ * Improved error messages on CHECK constraint failures. * The .read dot-command now accepts a pipeline in addition to a filename. * Added options --data-only and --nosys to the .dump dot-command. * Added the --nosys option to the .schema dot-command. * Table name quoting works correctly for the .import dot-command. * The generate_series(START,END,STEP) table-valued function extension is now built into the CLI. * The .databases dot-command now show the status of each database file as determined by sqlite3_db_readonly() and sqlite3_txn_state(). * Added the --tabs command-line option that sets .mode tabs. * The --init option reports an error if the file named as its argument cannot be opened. The --init option also now honors the --bail option. * Improved estimates for the cost of running a DISTINCT operator. * When doing an UPDATE or DELETE using a multi-column index where only a few of the earlier columns of the index are useful for the index lookup, postpone doing the main table seek until after all WHERE clause constraints have been evaluated, in case those constraints can be covered by unused later terms of the index, thus avoiding unnecessary main table seeks. * The new OP_SeekScan opcode is used to improve performance of multi-column index look-ups when later columns are constrained by
Reinhard Max
2020-12-02 14:29:05 +00:00
992d20b7b6Accepting request 826778 from server:database
Dominique Leuenberger
2020-08-19 16:43:00 +00:00
a32082d43eAccepting request 826777 from home:AndreasStieger:branches:server:databaseAndreas Stieger2020-08-15 06:19:58 +00:00
Ana Guerrero
Reinhard Max
Dominique Leuenberger
Martin Pluskal
Richard Brown
Lars Vogdt
Richard Brown
Andreas Stieger