/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around 2e2ebad3ab636c4c.

2019-06-14
13:24
Fix the implementation of the built-in RTRIM collating sequence so that it works for control characters at the end of the string. Ticket [f1580ba1b574e9e9] check-in: 86fa0087 user: drh tags: trunk
12:28
Refactor the LIKE optimization decision logic so that it uses sqlite3AtoF() on both boundary keys to determine if the optimization can be used when the LHS is something that might not have TEXT affinity. Ticket [ce8717f0885af975]. See also [c94369cae9b561b1], [b043a54c3de54b28], [fd76310a5e843e07], and [158290c0abafde67]. check-in: b4a9e09e user: drh tags: trunk
2019-06-13
16:14
Add a new requirement mark on the ctime.c code. check-in: c4b40568 user: drh tags: trunk
14:07
Do not use the %lld printf conversion in the platform printf() as some legacy platforms do not support it. check-in: f8696b60 user: drh tags: trunk
13:52
Fix a minor error in a test script, and harmless compiler warnings in the CLI code. check-in: eaa34626 user: drh tags: trunk
2019-06-12
22:46
Adjust requirements marks and add new requirements tests. check-in: ebb81dad user: drh tags: trunk
20:51
As a special case, casting '-0.0' into numeric should yield 0. Fix for ticket [674385aeba91c774]. check-in: 491f0f9b user: drh tags: trunk
20:11
Enhancements to the printf() logic in order to render a negative zero with a minus sign. Leaf check-in: 6ba4be66 user: drh tags: negative-zero
13:49
Handle expressions like "expr IS TRUE COLLATE xyz" in the same way as "expr IS TRUE". Fix for [4d01eda8115b10d1]. check-in: 5c6146b5 user: dan tags: trunk
2019-06-11
21:02
The affinity of the unlikely() function and its cousins should be "none". Ticket [0c620df60bffd9ef] check-in: 614ecb0a user: drh tags: trunk
18:07
Make sure the affinity of the RHS of an IN operator does not affect the outcome even if the RHS expression contains a COLLATE clause. Ticket [57353f8243c637c0] check-in: 0f748fe5 user: drh tags: trunk
16:43
Mark an unreachable branch with an ALWAYS macro. check-in: d4755aca user: drh tags: trunk
16:07
New test case in fuzzdata8.db. check-in: e96641f0 user: drh tags: trunk
16:06
Off-by-one error in the CAST to NUMERIC logic. check-in: 25b89630 user: drh tags: trunk
12:03
Have the ALTER TABLE code handle the case where an entire expression that includes a sub-select is excluded from a view, trigger or index. check-in: f2c8179f user: dan tags: trunk
10:43
Add the new sqlite3ExprUnmapAndDelete() function and use it in place of separate calls to sqlite3RenameExprUnmap() and sqlite3ExprDelete(). check-in: 36ea13e0 user: drh tags: trunk
02:43
The ALTER TABLE command should not attempt to rename objects that are contained within an expression tree that has been optimized out because it is the other branch of an "AND false" expression. Ticket [533010b8cacebe82] check-in: 04bd5cb7 user: drh tags: trunk
01:56
Fix repeated test numbers in the altertab2.test file. check-in: e82f235e user: drh tags: trunk
01:30
Remove a comment made obsolete by check-in [71643deb6bbad4b4]. No changes to code. check-in: 211c8002 user: drh tags: trunk
2019-06-10
23:45
A string consisting of a single '.' is not a floating point literal with extra text at the end. Fix for ticket [412bba9b22c677da] check-in: 57050162 user: drh tags: trunk
19:17
Have ALTER TABLE commands ignore the lhs of "expr IN ()" and "expr NOT IN ()" expressions, just as other queries do. Fix for [533010b8ca]. check-in: 71643deb user: dan tags: trunk
19:07
Improvements to the documentation for the xAccess method of the VFS. Ticket [5e0423b058fa5adf] check-in: 7078d77e user: drh tags: trunk
18:33
Make sure a CAST to "NUMERIC" results in an integer if the value can be losslessly expressed as an integer, as the documentation requires. Ticket [dd6bffbfb6e61db9]. check-in: c0c90961 user: drh tags: trunk
15:34
Handle renaming a column or table when the schema contains a (meaningless) index on the constant expression ('text' IN ()) or ('text' NOT IN()). Fix for [fd76310a]. check-in: 567b1309 user: dan tags: trunk
13:46
Do not attempt the LIKE optimization on a column with numeric affinity if the rhs of the operator begins with whitespace. Fix for ticket [fd76310a5e]. check-in: 94b58ab0 user: dan tags: trunk
2019-06-07
22:51
Remove code in the round() SQL function that became unreachable due to the optimization of check-in [e95138f5f4febde5] check-in: b141bae3 user: drh tags: trunk
22:26
When casting string values into numeric and the string has a prefix that looks like a number but total string is not a well-formed number, then take extra care that the result is either integer or real depending on what the prefix looks like. Fix for tickets [e8bedb2a184001] and [4c2d7639f076aa]. check-in: 67a68af5 user: drh tags: trunk
18:56
Also upgrade script config.sub to the latest version. This should have been part of the previous commit. check-in: efbf31b8 user: dan tags: trunk
18:53
Upgrade the config.guess script to the latest version. check-in: be843813 user: dan tags: trunk
2019-06-05
14:29
CLI enhancements: Add the ".filectrl" command. Make the ".testctrl" command visible to ".help". check-in: 7b3a99fc user: drh tags: trunk
13:14
Add a test case for the unix SQLITE_FCNTL_CHUNK_SIZE file-control. check-in: 3a477fd0 user: dan tags: trunk
2019-06-04
18:21
In the CLI, add a small delay (0.1 seconds) after launching the output command for ".once" before deleting the temporary file. check-in: 4979f138 user: drh tags: trunk
15:47
New dbsqlfuzz test cases add to test/fuzzdata8.db. check-in: 873aa46d user: drh tags: trunk
13:11
Fix a segfault in fts3 that could occur when processing corrupt fts records. check-in: dff24c6c user: dan tags: trunk
2019-06-03
15:10
Fix harmless compiler warning in lemon. check-in: 3a052429 user: mistachkin tags: branch-3.28
15:09
Fix harmless compiler warning in lemon. check-in: 2da0eea0 user: mistachkin tags: trunk
14:02
Updates to the shared_schema.md notes document. check-in: 51af2ade user: drh tags: reuse-schema
13:53
Fix the count-of-view optimization so that it is (correctly) disabled for a query that includes a WHERE clause or a GROUP BY clause. Cherrypick of [05897ca48a40c6771]. check-in: 583e5a0a user: mistachkin tags: branch-3.28
13:46
In the CLI, add ".help" text for the .shared-schema command. check-in: 3ba6f790 user: drh tags: reuse-schema
2019-05-30
13:47
Optimization to the round() SQL function for large input values without a fractional part. check-in: e95138f5 user: drh tags: trunk
00:46
Smaller and faster sqlite3IsNaN() implementation makes deserialization of floating point values much faster. check-in: ea748ede user: drh tags: trunk
2019-05-29
21:18
Much faster implementation of applyNumericAffinity() by avoiding some unnecessary calls to sqlite3Atoi64(). check-in: c1d8a3f6 user: drh tags: trunk
18:33
Add an assert() as an additional test for fix in check-in [523b42371122d9e1b3]. check-in: f9e85e6c user: drh tags: trunk
17:22
Fix the query flattener optimization so that it preserve the "SF_Compound" bit when flattening a compound subquery into a non-compound outer query. Failure to preserve that bit could allow subsequent flattenings which are not valid. Fix for ticket [c41afac34f15781fe09cd]. check-in: 523b4237 user: drh tags: trunk
2019-05-28
14:42
Fix an assert() in fts3 that could fail when processing corrupt records. Also some minor sanitizer warnings. check-in: c736c40a user: dan tags: trunk
2019-05-27
11:21
Fix an error message on the blobread() extension function so that it says "read" instead of "write". check-in: 7cbb9a5f user: drh tags: trunk
11:09
Fix a memory leak in the delta_parse() table-valued function of the fossildelta.c extension. check-in: c86ca3f0 user: drh tags: trunk
00:29
Improved rounding even on systems with an 8-byte "long double" type. check-in: 15202aee user: drh tags: trunk
2019-05-25
18:17
Performance enhancement in sqlite3AtoF(). About 8% faster. check-in: 81721aa5 user: drh tags: trunk
17:41
Use "long double" literals to initialize an array of "long double" objects. check-in: 2e2ebad3 user: drh tags: trunk
13:14
Add new cases to speedtest1 for measuring performance of binary to/from decimal conversions of floating point values. check-in: b84e7057 user: drh tags: trunk
00:17
Disable the new rounding tests on systems without long double support. check-in: ed250b4e user: drh tags: trunk
2019-05-24
22:58
Improvements to rounding behavior in the round() and printf() functions. check-in: 641b2d21 user: drh tags: trunk
13:15
The ".shared-schema" command in the CLI requires the sqlite_dbpage table, so disable it if the build does not include that extension. check-in: 0913ff4d user: drh tags: reuse-schema
13:04
Merge recent enhancements from trunk. check-in: ff9f3e09 user: drh tags: reuse-schema
11:55
Fix an fts5 segfault that could occur after parsing a corrupt structure record. check-in: 600daa9c user: dan tags: trunk
2019-05-23
16:40
Add test cases for the fix in the previous commit. check-in: c1057b2a user: dan tags: trunk
16:38
Improvements to the view-self-join optimization so that it works on all VIEWs, not just on Common Table Expressions. check-in: d2fe370c user: drh tags: trunk
2019-05-22
23:12
New test case for check-in [74ef97bf51dd531a] that takes the fix in the previous check-in into account. check-in: cb1d0652 user: drh tags: trunk
22:49
Renumber the Select.selId values in the copies of SELECT statements that implement VIEWs when the VIEW is expanded, so that when the same VIEW is used twice in the same join, each expansion as a distinct selId. This fixes ticket [ce823231949d3abf42453c8]. check-in: 3cacc4b9 user: drh tags: trunk
14:35
New dbsqlfuzz find added to test/fuzzdata8.db. check-in: 42af7c81 user: drh tags: trunk
14:22
Fix a buffer overread that could in fts3 when dealing with corrupt records. check-in: 1660d773 user: dan tags: trunk
2019-05-21
17:04
Combine the implementations of the key and hexkey pragmas into a single case. Have both pragmas return "ok" if they are implemented. check-in: b3692c40 user: drh tags: trunk
16:32
Fix a problem in [b5ca442a] causing an assert() to fail in REINDEX commands. check-in: a3e77c77 user: dan tags: trunk
14:42
Use a statement journal for all CREATE INDEX statements in case an indexed exprsesion throws an exception when it is evaluated. Fix for [b5ca442a]. check-in: b8071d10 user: dan tags: trunk
2019-05-20
19:46
Fix a segfault that could occur in sqlite3session_diff() if NULL were passed as the pzErrMsg argument. check-in: aee73fd2 user: dan tags: trunk
18:43
Improvements to the automatic compile-time selection of byte-order, as suggested on the mailing list by Seb Kemper. check-in: b7aad929 user: drh tags: trunk
18:35
A minor variation on check-in [1685610ef8e0dc] which (hopefully) makes the logic a little easier to follow. Also disallows the use of the double-quoted string hack in the query expression used for VACUUM INTO, which is not strictly required, but moves us toward the goal of disallowing the double-quoted string hack everywhere. check-in: 3e1b55f3 user: drh tags: trunk
17:14
Disallow string constants enclosed in double-quotes within new CREATE TABLE and CREATE INDEX statements. It is still possible to enclose column names in double-quotes, and existing database schemas that use double-quotes for strings can still be loaded. This addresses ticket [9b78184b]. check-in: 1685610e user: dan tags: trunk
10:36
Update the sqlite3ExprCompare() routine so that it does not think "? IS NOT TRUE" is the same as "? IS TRUE". Fix for [d3e7f2ba5b3]. check-in: 99eba69b user: dan tags: trunk
2019-05-18
21:22
Fix an assert() failure that could occur in a join query if the RHS of an IN() operator is a list containing correlated expressions. This problem was introduced by checkin [e130319317e7611938] which was part of the fix for ticket [787fa716be3a7f650c] - so this commit is part of that ticket's fix too. check-in: 778b1224 user: dan tags: trunk
19:49
Avoid including the comment in the output of "PRAGMA table_info" in situations where there is a comment following a DEFAULT value within a CREATE TABLE statement. check-in: d91095ba user: dan tags: trunk
2019-05-17
20:37
Disable PRAGMA journal_mode=OFF when SQLITE_DBCONFIG_DEFENSIVE is turned on. Ticket [f4ec250930342e0c]. check-in: a0f5eb5c user: drh tags: trunk
15:59
Always store a REAL value in a column with REAL affinity if the integer equivalent would require 8 bytes of storage. Fix for [3c27b97e3]. check-in: 14c00b10 user: dan tags: trunk
2019-05-16
20:40
Add test cases to test/fuzzdata7.db for (harmless) dbfuzz2 finds. check-in: 1eb2a628 user: drh tags: trunk
20:36
Initialize the 18-byte overrun area on the buffer used to reconstruct overflow btree cells during a btree search, to avoid a harmless jump-depends-on-uninit-values warning. check-in: 4b05caeb user: drh tags: trunk
20:13
Fix an assert() in the OP_Delete opcode that could fail with a corrupt database. check-in: 915388ab user: dan tags: trunk
16:44
Add new test file fts5corrupt4.test. check-in: 5dfc4fe9 user: dan tags: trunk
11:47
Fix a harmless use-of-initialized-value fault in the assert() logic added by check-in [d612fb7873cf59d] check-in: 3dac9072 user: drh tags: trunk
03:47
Fix harmless compiler warning in the session extension. check-in: dff823ca user: mistachkin tags: trunk
01:22
Make sure the OP_Concat opcode always correctly zero-terminates a UTF16 string, even if the input strings are ill-formed. This is a followup to check-in [3a16ddf91f0c9c516a7] that fixes a case the previous check-in missed. Also add assert()s to prove correct zero termination. check-in: d612fb78 user: drh tags: trunk
2019-05-15
18:42
Fix the count-of-view optimization so that it is (correctly) disabled for a query that includes a WHERE clause or a GROUP BY clause. check-in: 05897ca4 user: drh tags: trunk
10:16
Simplify the "Verifying Code Authenticity" section of the README.md file. No code changes. check-in: adebffc1 user: drh tags: trunk
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. check-in: 018f3199 user: drh tags: reuse-schema
22:07
Merge the latest trunk and wal2 enhancements. check-in: 3deaa6e2 user: drh tags: begin-concurrent-pnu-wal2
22:02
Merge the latest trunk enhancements into the wal2 branch. check-in: 23ec34e4 user: drh tags: wal2
21:51
Merge the latest trunk enhancements into begin-concurrent-pnu. check-in: e70878b3 user: drh tags: begin-concurrent-pnu
21:51
Merge the latest trunk enhancements into begin-concurrent. check-in: 5d3a6e18 user: drh tags: begin-concurrent
20:25
Fix a problem with the fix for [9cf6c9bb51] (commit [658b84d7]) that could cause a cursor to be left in an invalid state following a (rowid < text-value) search. check-in: bc7d2c16 user: dan tags: trunk
19:39
Merge recent enhancements from trunk into apple-osx. check-in: 40362d51 user: drh tags: apple-osx
19:20
New test cases in test/fuzzdata8.db. check-in: 228e1087 user: drh tags: trunk
18:33
Fix a problem with corrupt db handling in the fts5_vocab module. check-in: 456ced57 user: dan tags: trunk
11:33
Fix an assert() and potential buffer overrun in fts5 that could occur if the database was corrupt. check-in: 8be8bd0d user: dan tags: trunk
00:43
Disable index seek optimizations on REINDEX when the order of primary keys in the index differs from the main table. Fix for ticket [bba7b69f9849b5bf11b4]. check-in: f7aadfab user: drh tags: trunk
2019-05-13
11:52
Fix an assert() failure in fts5 that could occur when processing a corrupt database. check-in: f158c048 user: dan tags: trunk
2019-05-11
19:36
A new implementation for the sqlite3ExprImpliesExpr() theorem prover that does a better job of answering TRUE to "(NOT A) OR B" when B is a NOT NULL expression. check-in: b3413197 user: drh tags: trunk
16:14
When considering partial indexes, do not assume that a "CASE x ..." expression implies "x IS NOT NULL". check-in: 1b243032 user: dan tags: trunk
13:04
Do not assume that "x IS NOT ?" implies "x NOT NULL" when considering partial indexes. Fix for ticket [8025674847]. check-in: 0ba6d709 user: dan tags: trunk
2019-05-10
20:44
Add tests for the RBU module. check-in: a194e536 user: dan tags: trunk
17:54
Fix harmless compiler warnings. check-in: 956ca2a4 user: drh tags: trunk