This Day In History For 2019-10-01

1 Year Ago (more context)

2018-10-01
21:41		Add the "PRAGMA table_xinfo" command that works like table_info but also shows hidden columns in virtual tables and adds the "hidden" boolean column. (check-in: defa0515b8 user: drh tags: trunk)
21:36		Test case for PRAGMA table_xinfo. (Closed-Leaf check-in: 7694b9bc30 user: drh tags: pragma-table-vinfo)
21:26		Change the name of the pragma to PRAGMA table_xinfo. Improve the mkpragmatab.tcl script to reuse column names where appropriate. (check-in: 2fdd068987 user: drh tags: pragma-table-vinfo)
18:28		Add the extra "hidden" column to the end of the PRAGMA table_vinfo output. (check-in: cf1b76135f user: drh tags: pragma-table-vinfo)
17:33		Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. (check-in: 310b4b65b8 user: dan tags: trunk)
17:15		Bring the PRAGMA table_vinfo statement up to date with trunk. (check-in: 6f606f9923 user: drh tags: pragma-table-vinfo)
14:05		Fix a potential crash that can occur while reading an index from a corrupt database file. The corruption is a record-header-size that is larger than 0x7fffffff. Problem detected by OSSFuzz against GDAL and reported to us (with a suggested fix) by Even Rouault. The test case is in TH3. (check-in: 5d29165896 user: drh tags: branch-3.25)
13:54		Fix a potential crash that can occur while reading an index from a corrupt database file. The corruption is a record-header-size that is larger than 0x7fffffff. Problem detected by OSSFuzz against GDAL and reported to us (with a suggested fix) by Even Rouault. The test case is in TH3. (check-in: 8ac2cdda68 user: drh tags: trunk)
11:00		Ensure that the OP_VColumn opcode does set sqlite3_vtab_nochange() unless the OPFLAG_NOCHNG bit is set in P5. Fix for ticket [69d642332d25aa3b7315a6d385] (check-in: 31ac8dbae4 user: drh tags: branch-3.25)
07:04		Fix a problem with ALTER TABLE commands when the schema features an INSTEAD of trigger that uses NEW.* or OLD.*. (check-in: c52f457e56 user: dan tags: trunk)

3 Years Ago (more context)

2016-10-01
23:55		Add SQLITE_USE_ALLOCA to the --lean configuration in speed-check.sh. (check-in: fe07609efc user: drh tags: trunk)
21:43		Rearrange fields in the Parse object to reduce the amount of initialization required. (check-in: 361940b44d user: drh tags: trunk)
20:43		Reduce the width of a memset() to avoid double-initializing some variables. (check-in: 34edbfd12d user: drh tags: trunk)
19:32		Remove an unnecessary memset() call. (check-in: a76bff74ce user: drh tags: trunk)
19:21		Use sqlite3DbMallocRawNN() where appropriate, instead of sqlite3DbMallocRaw(). (check-in: 54a449a41d user: drh tags: trunk)
16:53		Make sure deleting an unused prepared statement does not reference uninitialized fields in the structure. (check-in: 7983eef042 user: drh tags: trunk)
11:39		Avoid accessing Vdbe.pc if it is uninitialized. Check Vdbe.magic first. (check-in: 6ac6e4462a user: drh tags: trunk)
00:37		Avoid unnecessary zeroing of fields in the Vdbe object when it is allocated. (check-in: 1e21bbe836 user: drh tags: trunk)

4 Years Ago (more context)

2015-10-01
18:31		Fix an fts3 bug causing NEAR queries on uncommitted data to malfunction. (check-in: 6f90839e91 user: dan tags: trunk)
16:35		Changes to the sesssions module ensure that tables appear within changesets and patchsets in the same order that they were attached to the sessions object. (check-in: 7695890230 user: dan tags: sessions)

5 Years Ago (more context)

2014-10-01
13:17		Show the TK_DOT operator in the TreeView debugging output. No changes to production code. (check-in: 07c89940c4 user: drh tags: trunk)
12:02		• Closed ticket [e3a290961a]: out-of-bounds write when using non-default malloc implementation and SQLITE_DIRECT_OVERFLOW_READ plus 6 other changes (artifact: 347802e2b6 user: dan)
12:01		Avoid ever writing before the start of an allocated buffer in the DIRECT_OVERFLOW_READ code. Fix for [e3a290961a6]. (check-in: c3c15d20c6 user: dan tags: trunk)
11:54		• New ticket [e3a290961a] out-of-bounds write when using non-default malloc implementation and SQLITE_DIRECT_OVERFLOW_READ. (artifact: 72fdf8427d user: dan)
01:52		Merge the latest enhancements from trunk. (check-in: 2695772c98 user: drh tags: sessions)
01:46		Merge the latest enhancements from trunk. (check-in: 2078454ac9 user: drh tags: apple-osx)

10 Years Ago (more context)

2009-10-01
17:13		Add test cases to cover the branches added by the previous commit. (check-in: aaa005b6da user: dan tags: trunk)
16:09		If an update does not modify any child or parent key columns, omit foreign key processing for the statement. (check-in: edff350005 user: dan tags: trunk)
07:27		• Ticket [2fd50fa665] cygwin-1.7 issues: winFullPathname and tempname status still Open with 4 other changes (artifact: 07b923927e user: rogerb)
07:23		• New ticket [43d2aa29b9] H13015 needs to be completed. (artifact: ac8d312a42 user: rogerb)
07:17		• New ticket [3211d778c0] replace function works on blobs. (artifact: b3d4e9eb41 user: rogerb)
07:07		• New ticket [8440a8e22f] LENGTH & QUOTE stop at first zero. (artifact: 7a9cbc2f25 user: rogerb)
06:47		• Ticket [19b44e3575] sqlite3_bind_text inconsistent with NULL pointers, zero length etc status still Open with 3 other changes (artifact: 4fc1eaf923 user: rogerb)
06:44		• New ticket [19b44e3575]. (artifact: 44e184970d user: rogerb)
06:31		• New ticket [72adc99de9] shell mode insert doesn't output blobs as blobs. (artifact: 7fb1b8cba6 user: rogerb)
04:35		Add tests to check that FK support interacts with count-changes correctly. (check-in: 5b8366154b user: dan tags: trunk)
02:05		• Ticket [e063139eb3] Download .zip excludes shell but .tar includes it status still Open with 1 other change (artifact: 053b43a0cd user: rogerb)
02:04		• Ticket [f12a9eeedc] Shell command argument parsing is lax status still Open with 3 other changes (artifact: 8d0a5cd234 user: rogerb)

15 Years Ago (more context)

2004-10-01
18:21		make diskfull test work on Windows; see check-in (1994) (CVS 1996) (check-in: 4493e28780 user: dougcurrie tags: trunk)
15:11		Fix for ticket #905. (CVS 1995) (check-in: bf90799d88 user: drh tags: version_2)
14:38		Additional code to test the SQLITE_FULL return when the disk is full. (CVS 1994) (check-in: 44e56f0bba user: drh tags: trunk)
03:02		Fully release exclusive locks in the Unlock primitive of Unix. Ticket #913. (CVS 1993) (check-in: 11a37a74b1 user: drh tags: trunk)
02:00		Use type i64 instead of off_t for file offsets since off_t is giving portability problems. Ticket #924. (CVS 1992) (check-in: 8972c004dc user: drh tags: trunk)