/ 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.

35 check-ins using file src/expr.c version 68552ca7

2017-07-24
19:23
Only open a db in server-mode if there is a directory named "db-journal" in the file-system and the VFS is an exclusive locking VFS. check-in: e77d29f6 user: dan tags: server-process-edition
2017-07-19
18:54
Merge latest trunk changes with this branch. check-in: be0df0a6 user: dan tags: server-process-edition
18:01
Remove some 'breakpoint' commands in test files. check-in: d14fc621 user: mistachkin tags: trunk
17:12
Create "pure" versions of the date/time functions that omit the 'now' feature and are therefore deterministic and usable in an index. Closed-Leaf check-in: 55791928 user: drh tags: pure-date-functions
11:52
Add further tests to unionvtab.test. check-in: c93284cd user: dan tags: trunk
11:20
Add VFS interfaces needed to make use of batch atomic write capabilities in the underlying filesystem. check-in: 929bc46b user: drh tags: batch-atomic-write
2017-07-18
21:19
Fix a crash in unionvtab caused by a misconfiguration. Add other test cases for the same. check-in: 255d6b99 user: dan tags: trunk
20:59
Fix shell.c.in so that it aligns with shell.c. check-in: 505fdc8f user: drh tags: trunk
20:49
Add test cases and fix minor error-handling issues in unionvtab.c. check-in: deadaad2 user: dan tags: trunk
20:30
Fix duplicate test name. No changes to code. check-in: 47b80ecc user: mistachkin tags: trunk
20:28
Fix another harmless compiler warning. Get the MSVC makefile working with unionvtab. check-in: d49639c2 user: drh tags: trunk
20:22
Suppress harmless compiler warnings in union-vtab. check-in: 4d147a1e user: drh tags: trunk
20:17
Remove an unused variable from unionvtab.c. check-in: a447fdf1 user: dan tags: trunk
20:03
Improve the readability of the unionvtab code. check-in: 5bcf0f86 user: dan tags: trunk
19:51
Have unionvtab support constraints on the column that corresponds to the INTEGER PRIMARY KEY field of the underlying source tables in the same way as rowid. check-in: 4a6c416f user: dan tags: trunk
18:50
Add test cases to unionvtab.test. check-in: 6c9128e1 user: dan tags: trunk
18:19
Add the union-vtab extension - still experimental and under active development. check-in: 948f9504 user: drh tags: trunk
17:34
Do not use the flattening optimization for a sub-query on the RHS of a LEFT JOIN if that subquery reads data from a virtual table. Because it prevents the planner from creating an automatic index on the results of the sub-query, the flattening optimization sometimes slows things down in this case. check-in: 9dbae1df user: dan tags: trunk
17:13
Avoid creating an automatic index on the RHS of a LEFT JOIN to optimize an IS term. Fix for [ce68383b]. check-in: d2f0b2e8 user: dan tags: trunk
14:41
Change the default command-line shell history depth to 2000 lines. check-in: 0b69aa7e user: drh tags: trunk
2017-07-17
21:03
Add test cases to test/unionvtab.test. Closed-Leaf check-in: f2c4a584 user: dan tags: union-vtab
20:25
Enhance error detection and fix other issues in unionvtab code. check-in: 9c3f1b9a user: dan tags: union-vtab
20:21
Merge all the latest fixes and enhancements from trunk. check-in: e181225d user: drh tags: apple-osx
18:45
Merge all changes from branch-3.20. Improvements to the fts5() extension interface. Work around a gcc/valgrind bug in the sqlite3_value_pointer() interface. check-in: e0aca7d2 user: drh tags: trunk
17:46
Interchange to branches within an "if" statement in sqlite3_value_pointer() in order to work around a bug in gcc. Closed-Leaf check-in: 8a606e4a user: drh tags: branch-3.20
15:38
Improved the interface to the fts5() extension mechanism for enhanced security. check-in: bc78235f user: drh tags: branch-3.20
13:37
Merge the pointer-type enhancement from the 3.20 branch. check-in: 9e8e1c4a user: drh tags: trunk
12:41
Comment changes clarifying details of the pointer-type parameter. No changes to code. check-in: e4579e50 user: drh tags: branch-3.20
12:27
Add the pointer-type parameter to sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer(). The pointer type is a static string that must match (according to strcmp()) or else the pointer is passed as a NULL. This is a security measure to prevent crossing pointers between different extensions. check-in: e1196567 user: drh tags: branch-3.20
11:39
Improve the sqlite3_result_pointer() interface so that it cannot be faked using sqlite3_result_null() and sqlite3_result_subtype(). Closed-Leaf check-in: c13264d5 user: drh tags: pointer-types
09:30
Use integer handles for fts3 cursors for a small performance improvement. Closed-Leaf check-in: f4f7196b user: dan tags: union-vtab, fts3-int-cursor
00:40
Add an experimental "pointer type" parameter to sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer(). The pointer type is a string that must compare equal using strcmp() or else the pointer comes through as a NULL. check-in: 211cce04 user: drh tags: pointer-types
2017-07-15
20:48
Add the "unionvtab" virtual table extension in ext/misc/unionvtab.c. check-in: 62a86aa6 user: dan tags: union-vtab
20:44
Merge the fix for ticket [a4e06e75a9ab61a12] from trunk. check-in: b64d64c8 user: drh tags: branch-3.20
20:33
Fix a register allocation problem in PRAGMA integrity_check that caused the same register to be used for two different purposes on the first ATTACHed database if the schema for the ATTACHed database was noticable more complex than the schema for the first database. Fix for ticket [a4e06e75a9ab61a1]. check-in: 253945d4 user: drh tags: trunk