This Day In History For 2022-01-08

1 Year Ago (more context)

2021-01-08
19:53		Fix an issue with sha3_query() when the first argument contains blank SQL statements. (check-in: 24baab9a9f user: drh tags: trunk)

2 Years Ago (more context)

2020-01-08
22:22		Block edgy functions used in DEFAULT constraints. (check-in: da434dc149 user: drh tags: new-security-options)
20:37		Performance improvements and test cases added. Allow "PRAGMA trusted_schema=ON" (check-in: 30882ca80f user: drh tags: new-security-options)
17:28		Check for whether or not it is safe to use non-innocuous functions as the function is being coded, not when its name is resolved. (check-in: 1da802d54b user: drh tags: new-security-options)
15:44		Provide the -innocuous option to the "db func" method in the TCL interface. (check-in: 0138652b6c user: drh tags: new-security-options)
15:43		Fix the rot13.c extension to be deterministic. Add the noop.c extension. (check-in: a679122ca8 user: drh tags: new-security-options)
14:39		In the TreeView debugging output, show a "DDL" mark on SrcList and Expr nodes that derive from a non-TEMP schema. (check-in: fe7472fd2a user: drh tags: new-security-options)
13:08		Merge recent changes from trunk. (check-in: 5962921fce user: drh tags: new-security-options)
12:17		• Fixed ticket [9eda2697f5]: Incorrect result for COUNT(), UTF16be encoding and SUBSTR plus 5 other changes (artifact: e2b031bd69 user: drh)
12:17		When doing a text-to-double conversion on a BLOB with an odd number of bytes and assuming a UTF16 encoding, ignore the last byte. Ticket [9eda2697f5cc1aba]. (check-in: 1c76f1d8ec user: drh tags: trunk)
11:36		Fix a minor formatting error in the display of BLOB values during VDBE tracing. (check-in: 295442887a user: drh tags: trunk)
10:57		Improvements to the documentation of sqlite3_create_collation(). (check-in: fa866aec56 user: drh tags: trunk)
10:37		• New ticket [9eda2697f5] Incorrect result for COUNT(), UTF16be encoding and SUBSTR. (artifact: d39be4d2eb user: mrigger)
04:36		Simplification of the logic in the constant-propagation optimization. (check-in: 1c3e5c20a9 user: drh tags: trunk)
01:44		• Fixed ticket [82ac75ba00]: Incorrect result for query with 0 >= t0.c0 AND t0.c0 = v0.c0 condition plus 6 other changes (artifact: fc968219cd user: drh)
01:43		Fix the constant propagation optimization so that it does not try to propagate constant expressions that have affinity. Ticket [82ac75ba0093e5dc] (check-in: 6db1c3498f user: drh tags: trunk)
00:39		Fix a misworded comment. No code changes. (check-in: ee0bc7ede0 user: drh tags: trunk)

3 Years Ago (more context)

2019-01-08
20:02		Use 64-bit math to compute the sizes of memory allocations in extensions. (check-in: ca67f2ec0e user: drh tags: trunk)
15:18		Performance improvement on the instr() function, especially for large haystacks. (check-in: ce51f1a2b6 user: drh tags: trunk)
14:28		Fix a possible memory leak when trying to UPDATE a corrupt RTREE index. (check-in: 63eb803dbc user: drh tags: trunk)
08:02		Fix further problems with fts5 and corrupt databases causing integer overflow. (check-in: 673a7dd698 user: dan tags: trunk)

4 Years Ago (more context)

2018-01-08
20:04		Test cases for sqlite3_normalize(). (Closed-Leaf check-in: 658f42257d user: drh tags: normalize)
19:59		Update the zipfile module so that it matches the documentation. (check-in: 7e7e472fa9 user: dan tags: trunk)
19:29		Special handling of the NULL keyword. Sometimes it is a literal, and sometimes it is a keyword. (check-in: db5d138e97 user: drh tags: normalize)
19:18		Add IN-operator normalizating and the SQLITE_NORMALIZE_CLI compile-time option for generating a stand-alone program. (check-in: d77dbb398a user: drh tags: normalize)
17:34		Fix problems in the sqlite3expert.c code revealed by -fsanitize. (check-in: 7a93dd784b user: dan tags: trunk)
17:12		Add an "ifcapable trace {}" block to a test in fkey1.test that uses SQL tracing. (check-in: 7182591d35 user: dan tags: trunk)
17:09		Remove a superfluous define from the 'fileio' extension when compiled for Win32. (check-in: 6dcba6693f user: mistachkin tags: trunk)
17:05		Fix a malloc/sqlite3_free mismatch in the shell tool code. (check-in: fe053b2ecd user: dan tags: trunk)
16:54		First code for an auxiliary function that will normalize an SQL statement. (check-in: 84814aac81 user: drh tags: normalize)
14:24		Fix compilation of 'sqltclsh.exe' for MSVC. (check-in: abb112d9e1 user: mistachkin tags: trunk)

10 Years Ago (more context)

2012-01-08
22:18		Fix typos in commands. Combine the ExpandBlob and expandBlob macros into one. (check-in: fc9179e154 user: drh tags: trunk)
12:32		Make sure the shared-memory filename sythesized by os_win.c is double-zero terminated, so that it can be used with sqlite3_uri_parameter(). (check-in: 429380f99c user: drh tags: trunk)
00:54		Fix harmless compiler warning seen with MSVC. (check-in: 9612bcd648 user: mistachkin tags: trunk)

15 Years Ago (more context)

2007-01-08
22:40		Additional tests of sqlite3_prepare_v2. (CVS 3577) (check-in: b0650aa6cf user: drh tags: trunk)
21:07		Fix a critical bug in sqlite3_prepare_v2 that can lead to segfaults when the schema changes and the statement is recompiled automatically. Ticket #2154. (CVS 3576) (check-in: 3401388dba user: drh tags: trunk)
16:20		Fix a date round-off problem in strftime(). Ticket #2153. (CVS 3575) (Leaf check-in: 47fee16ba9 user: drh tags: version_2)
16:19		Fix another round-off problem in strftime(). Ticket #2153. (CVS 3574) (check-in: d49ddc5ff0 user: drh tags: trunk)
14:31		Updates to the sqlite3 command-line shell documentation. Ticket #2144. (CVS 3573) (check-in: 3a422bb9ee user: drh tags: trunk)
13:43		Fix a round-off error in the %W conversion of strftime(). Ticket #2150. (CVS 3572) (check-in: e6a18741a4 user: drh tags: version_2)
13:40		Add the $(BEXE) suffix to every mention of "lemon" in the Makefile.in, so that the build will work on OS/2. Ticket #2149. (CVS 3571) (check-in: f5989a0bd3 user: drh tags: trunk)
13:07		Fix a round-off error in the %W and %j conversions of the strftime() function. Ticket #2150. (CVS 3570) (check-in: 5206793780 user: drh tags: trunk)