SQLite
Timeline
Not logged in

30 ancestors of [5350229b52]


2014-07-26
20:12
[5350229b52] Leaf: Remove an unreachable branch from the sqlite3_value_numeric_type() interface. (user: drh, tags: trunk)

16:47
[413d728797] Avoid unnecessary no-op calls to applyNumericAffinity() for a small performance improvement. (user: drh, tags: trunk)
2014-07-25
21:35
[e0fa6fdc14] Try to fix harmless compiler warnings reported by Fortify. (user: drh, tags: trunk)
18:37
[2d32e4876e] Improved comments on VDBE opcodes, for better documentation. No code or logic changes. (user: drh, tags: trunk)
18:01
[2230c74f1e] Add constraints (enforced only when SQLITE_DEBUG is enabled) on the use of OP_Next and OP_Prev. (user: drh, tags: trunk)
2014-07-24
23:23
[114dcf3367] Improve the performance of the ANALYZE command by taking advantage of UNIQUE constraints on indices. (user: drh, tags: trunk)
22:41
[6aea2258dd] Fix a bug in the whereRangeSkipScanEst() procedure (added by check-in d09ca6d5efad3e4cfa) where it fails to consider the possibility of a ROWID column when computing the affinity of a table column. (user: drh, tags: trunk)
20:25
[85e2badeeb] Closed-Leaf: Avoid trying to allocation zero bytes when analyzing a unique non-null index. (user: drh, tags: faster-analyze)
19:54
[4690e99c07] Avoid change tests when analyzing single-column unique indexes after getting past the initial NULL entries. (user: drh, tags: faster-analyze)
12:39
[fb1048cb2b] Add the readfile(FILENAME) and writefile(FILENAME,CONTENT) SQL functions to the command-line shell. (user: drh, tags: trunk)
12:19
[f8f79f2878] Add support for hexadecimal integer literals in the parser. (user: drh, tags: trunk)
12:09
[16c8ce10e1] In the command-line shell, in CSV output mode, terminate rows with CRNL but do not expand NL characters in data into CRNL. Provide the extra -newline command-line option and the extra argument to .separator to designate an alternative newline character sequence for CSV output. (user: drh, tags: trunk)
2014-07-23
23:57
[729ece4088] Add experimental "costmult" logic. Only enabled when compiled with -DSQLITE_ENABLE_COSTMULT. (user: drh, tags: trunk)
19:37
[30033f9650] Ugh. Consecutive UNIQUE index entries are only distinct if the index is on NOT NULL columns. So the previous version was not quite right. This check-in fixes the problem. (user: drh, tags: faster-analyze)
19:04
[a3cc027fa7] Closed-Leaf: Enhancements to the hex literal tests. (user: mistachkin, tags: hex-literal)
18:36
[3e1e79e133] Improve the performance of the ANALYZE command by taking advantage of the fact that every row of a UNIQUE index is distinct. (user: drh, tags: faster-analyze)
15:51
[e6225a7bf7] Updated documentation on sqlite3_temp_directory. No changes to code. (user: drh, tags: trunk)
14:52
[a5b383e077] Remove a surplus function prototype. #ifdef code that is not used when hex integers are omitted at compile time. (user: drh, tags: hex-literal)
13:40
[6c6f0de59b] Change the hex literal processing so that only the SQL parser understands hex literals. Casting and coercing string literals into numeric values does not understand hexadecimal integers. This preserves backwards compatibility. Also: Throw an error on any hex literal that is too big to fit into 64 bits. (user: drh, tags: hex-literal)
02:07
[4b86ccdf4f] Casting hex literals directly from string to float always results in a positive number. (user: drh, tags: hex-literal)
01:59
[7e1bbacb11] Reformatting a few test cases for clarity. (user: drh, tags: hex-literal)
01:56
[19054339c4] Test cases for hex literals. (user: drh, tags: hex-literal)
01:26
[34a1f38b7a] Add support for parsing C-style hexadecimal literals. (user: drh, tags: hex-literal)
2014-07-22
22:46
[48f40861db] When running ANALYZE, it is not necessary to check the right-most key column for changes since that column will always change if none of the previous columns have. (user: drh, tags: trunk)
20:02
[77f412caf0] Add the OP_ReopenIdx opcode that works like OP_OpenRead except that it becomes a no-op if the cursor is already open on the same index. Update the OR-optimization logic to make use of OP_ReopenIdx in order to avoid unnecessary cursor open requests sent to the B-Tree layer. (user: drh, tags: trunk)
19:14
[eed754fe93] The optimization of check-in b67a6e33f2 does not work (it generates incorrect VDBE code) if an OR term is AND-ed with a constant expression. So back that optimization out and add a test case to make sure it does not get added back in. (user: drh, tags: trunk)
16:00
[438c348a40] Fix the index name for the shadow tables in the spellfix1 extension so that multiple instances of the spellfix1 virtual table can each have their own index. (user: drh, tags: trunk)
15:33
[48e3780295] Correction: The maximum SQLITE_MAX_ATTACHED value to avoid overflowing a signed 8-bit integer is 125, not 127. (user: drh, tags: trunk)
14:58
[ca2a5a2c77] Enhance the sqlite_stat1.stat parsing to allow additional text parameters at the end. Unrecognized parameters are silently ignored. (user: drh, tags: trunk)
14:42
[b083a961f8] Expire prepared statements after running ANALYZE. (user: drh, tags: trunk)
12:05
[b22dd165da] Enhance the comment on whereLoopAddBtree(). No changes to code. (user: drh, tags: trunk)