This Day In History For 2020-07-06
2 Years Ago (more context)
|
2018-07-06
| ||
| 17:19 | Try to improve the error messages for misformed frame specifications in window definitions. (check-in: 927b95a0 user: drh tags: trunk) | |
| 14:31 | Also disallow non-constant expressions in "<expr> PRECEDING" or "<expr> FOLLOWING" clauses. (check-in: a6dffecc user: dan tags: trunk) | |
| 14:15 | Ensure an error is returned if the user specifies an unsupported frame type. (check-in: 0f3f8fcd user: dan tags: trunk) | |
| 13:48 | Prevent "UNBOUNDED FOLLOWING" from being used as the starting boundary of a window-frame. And "UNBOUNDED PRECEDING" from being used as the ending boundary. (check-in: e51fdf66 user: dan tags: trunk) | |
| 13:25 | Remove some bad assert() statements from the implementations of window functions percent_rank() and cume_dist(). (check-in: 443f0c28 user: dan tags: trunk) | |
| 07:42 | Return an error if DISTINCT is used with a window-function (e.g. "count(DISTINCT <expr>) OVER (...)"). (check-in: d59bcc8e user: dan tags: trunk) | |
| 07:41 | • Edit [d59bcc8eea4fcf0e|d59bcc8e]: Edit check-in comment. (artifact: c653d8f9 user: dan) | |
| 07:41 | • Edit [d59bcc8eea4fcf0e|d59bcc8e]: Edit check-in comment. (artifact: 298b0cce user: dan) | |
3 Years Ago (more context)
|
2017-07-06
| ||
| 22:43 | Small adjustment to main.mk that facilitates giving non-standard compile-time options to the shell. (check-in: 7c7d53a9 user: drh tags: trunk) | |
| 22:40 | Always load the schema before starting tab-completion. (check-in: 907fd3aa user: drh tags: experimental-namelist) | |
| 20:08 | Tab-completion now also works using readline/editline. (check-in: c906739f user: drh tags: experimental-namelist) | |
| 19:26 | Use the sqlite3_namelist() interface to implement simple tab-completion using linenoise. (check-in: 5cc7b0e2 user: drh tags: experimental-namelist) | |
| 18:52 | Change the sqlite3_namelist() interface to return a pointer to an array of pointers to strings, and to avoid duplicates. (check-in: 70291110 user: drh tags: experimental-namelist) | |
| 18:25 | The sqlite3_namelist() routine now works for all name types. (check-in: e41d6217 user: drh tags: experimental-namelist) | |
| 17:36 | Initial implementation of a highly experimental interface for listing all keywords and symbolic names for an SQLite database connection. (check-in: 04ef6783 user: drh tags: experimental-namelist) | |
| 16:33 | Change the (machine-generated) keywordhash.h file to increase the scope of the tables used for keyword matching, so that the tables are accessible to functions other then keywordCode(). (check-in: c5ed5ebd user: drh tags: trunk) | |
| 13:51 | More compact implementation of the typeof() SQL function. (check-in: efb4aab0 user: drh tags: trunk) | |
| 13:23 | Avoid unnecessary upper-to-lower case conversion for function names when registering the built-in functions. (check-in: 06269257 user: drh tags: trunk) | |
| 03:06 | Small size reduction in findCollSeqEntry(). (check-in: 55ecd303 user: drh tags: trunk) | |
| 02:49 | Avoid unnecessary calls to sqlite3GetCollSeq() for a small performance gain. (check-in: 503ba172 user: drh tags: trunk) | |
| 01:28 | Slightly more compact implementation of the byte-code generator for the COMMIT and ROLLBACK commands. (check-in: 4da663d9 user: drh tags: trunk) | |
| 01:02 | Small performance increase in sqlite3SrcListAppend(). (check-in: 7b2623f1 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2016-07-06
| ||
| 21:08 | • Edit [2683b375ad129117|2683b375]: Edit check-in comment. (artifact: f3830053 user: drh) | |
| 18:42 | Add the SQLITE_DBSTATUS_CACHE_USED_SHARED sqlite3_db_status() parameter. This option is similar to DBSTATUS_CACHE_USED, except that it divides memory used by shared caches evenly between all connections. (check-in: 06cf2680 user: dan tags: trunk) | |
| 18:12 | Change the name of the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED to SQLITE_DBSTATUS_CACHE_USED_SHARED. (Closed-Leaf check-in: d58401ab user: dan tags: dbstatus-prop-cache-used) | |
| 10:17 | Fix a test script problem causing a test to fail if the ICU extension is enabled. (check-in: 0c228f5d user: dan tags: trunk) | |
| 10:12 | Add the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED sqlite3_db_status() parameter. (check-in: 118321c8 user: dan tags: dbstatus-prop-cache-used) | |
| 09:19 | Fix a memory leak in recently added test code. (check-in: 724e4cdc user: dan tags: trunk) | |
| 08:32 | Fix a typo in test program bc_test1.c. (check-in: 2c61b7ab user: dan tags: begin-concurrent) | |
5 Years Ago (more context)
|
2015-07-06
| ||
| 20:57 | A unified cache is now only used for SQLITE_ENABLE_MEMORY_MANAGEMENT, or if SQLITE_CONFIG_PAGECACHE defines a shared start-time page cache buffer and the application is single-threaded. (check-in: d5ff1d69 user: drh tags: pcache-bulk-local) | |
| 20:27 | Speed up seek operations on fts5 b-tree structures. (check-in: 7b7da1eb user: dan tags: trunk) | |
| 18:54 | Enhance separate pcache1 to allocate a block of pages from heap on startup, if possible, for a 5.2% performance improvement. (check-in: aa7341c8 user: drh tags: pcache-bulk-local) | |
10 Years Ago (more context)
|
2010-07-06
| ||
| 20:37 | Minor changes to Makefile.in to bring it more inline with main.mk. (check-in: 5621862b user: shaneh tags: trunk) | |
| 20:34 | Changes to pager1.test to support Windows. (check-in: fce689eb user: shaneh tags: trunk) | |
| 20:33 | Modified the xWrite() method on Windows to differentiate between IO and disk full error returns. (check-in: ca4b7ffb user: shaneh tags: trunk) | |
| 11:26 | Do not do the *-closeallfiles test for notify2.test. It uses multiple threads. (check-in: fb09152d user: dan tags: trunk) | |
| 10:55 | Before calling Tcl_ExitThread() in a multi-threaded test, call Tcl_DoOneEvent() as many times as necessary to handle any queued events. (check-in: b3399b40 user: dan tags: trunk) | |
| 09:29 | Reorder variable declarations in the previous check-in to avoid putting code before declarations when not testing. (check-in: d1fe8ab4 user: drh tags: trunk) | |
| 07:36 | Ensure the correct error code is returned if an attempt to parse a database schema made by an ATTACH statement fails. (check-in: c2721961 user: dan tags: trunk) | |
15 Years Ago (more context)
|
2005-07-06
| ||
| 13:51 | Fix a quoting problem in the configure script. (CVS 2536) (check-in: b34647a2 user: drh tags: trunk) | |