SQLite
Timeline
Not logged in

20 most recent timeline items

2014-07-24
12:09
[16c8ce10e1] Leaf: 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] Leaf: 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:31
[bdc58fd28a] Leaf: Add a snippet() function to fts5. (user: dan, tags: fts5)
19:04
[a3cc027fa7] Leaf: Enhancements to the hex literal tests. (user: mistachkin, tags: hex-literal)
18:41 • Edit 3e1e79e133: Move to branch faster-analyze... (user: drh)
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)