/ Timeline
Login

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

50 descendants of 529fb55e3d00472f

2018-08-28
19:23
Stricter enforcement of the JSON and GeoJSON standards in the Geopoly extension. check-in: c0bf3ff3af user: drh tags: trunk
15:51
Fix new issues in the geopoly module discovered by TH3. check-in: 22fff9afc2 user: drh tags: trunk
11:23
Fix a problem causing spurious SQLITE_CORRUPT errors when using the snapshot API to read from old database snapshots. check-in: 535155be58 user: dan tags: trunk
2018-08-27
17:13
Add support for the Geopoly extension to the R-Tree extension. This also involves adding the SQLITE_INDEX_CONSTRAINT_FUNCTION capability to the xFindFunction method of the sqlite3_module object, and to the sqlite3_index_info.aConstraint.op field in the xBestIndex implementation of virtual tables. check-in: 666133e32c user: drh tags: trunk
17:05
Minor changes to the visual01.txt test script. Closed-Leaf check-in: 4bc28eed32 user: drh tags: rtree-geopoly
15:55
Split the three-argument version of geopoly_within() off into a separate function named geopoly_contains_point(). check-in: 5a0e154103 user: drh tags: rtree-geopoly
2018-08-25
23:03
Enhance the geopoly virtual table so that it does a better job of optimizing geopoly_within() queries. check-in: 1f71738534 user: drh tags: rtree-geopoly
19:51
Provide the two-argument geopoly_within(P1,P2) routine that determines if polygon P2 is contained within polygon P1. Make this function available to the query planner for optimized rtree lookups. Update the visual01.txt script to verify that the new functionality actually works. check-in: 6eb5d09b7f user: drh tags: rtree-geopoly
18:57
Fix a harmless compiler warning. check-in: d49be9838d user: drh tags: rtree-geopoly
16:22
Fix a minor issue in the altercol.test script so that it runs on Windows. check-in: 62089c6daf user: drh tags: alter-table-rename-column
16:14
Invoke the authorizer for ALTER TABLE RENAME COLUMN. check-in: fc293bcb34 user: drh tags: alter-table-rename-column
03:29
Remove an unnecessary IN_RENAME_COLUMN macro from resolve.c. check-in: 5858c0bde7 user: drh tags: alter-table-rename-column
02:04
The implementation of sqlite_rename_column() must be holding the schema mutexes. check-in: f0eed21d4e user: drh tags: alter-table-rename-column
2018-08-24
20:20
Fix a problem by renaming a column when the schema contains an trigger program featuring an UPSERT that uses an "excluded.*" reference to a different table. check-in: 83d5f5abce user: dan tags: alter-table-rename-column
20:10
Fix a problem with renaming a column that occurs as an "excluded.colname" construction in an UPSERT that is part of a trigger program. check-in: bb2f723496 user: dan tags: alter-table-rename-column
19:04
Set SQLITE_PTRSIZE to 4 when compiling with xlc on 32-bit AIX. check-in: d158e5b12e user: mistachkin tags: trunk
17:55
After modifying and reparsing the schema as part of an ALTER TABLE RENAME COLUMN, check that no new schema errors have been introduced (e.g. ambiguous column names in views) before committing the operation. check-in: a0e06d2c5e user: dan tags: alter-table-rename-column
16:04
Avoid incorrectly replacing tokens that refer to a column being renamed via an alias. For example, do not overwrite "xyz" when "a" is renamed in "CREATE VIEW v1 AS SELECT a AS xyz FROM tbl WHERE xyz=1" check-in: ad072a835f user: dan tags: alter-table-rename-column
2018-08-23
20:09
Add the "atrc" test program to the Makefiles. Fix a typo in the instructions in the header comment of the atrc program. check-in: 2130a407dd user: drh tags: alter-table-rename-column
19:32
Fix harmless compiler warnings in the ALTER TABLE logic. Rephrase an error message to use active voice. check-in: a7dae59a7e user: drh tags: alter-table-rename-column
18:56
Automatically detect when compiling for AArch64 on windows and set SQLITE_BYTEORDER to little-endian to avoid compile-time testing. check-in: ef6729be85 user: drh tags: trunk
18:50
The Expr.iColumn field must also be initialized in tokenExpr(). check-in: 772985f18b user: drh tags: alter-table-rename-column
18:22
Make sure the Expr.iTable field is initialized by tokenExpr(). check-in: 02a05a3b3c user: drh tags: alter-table-rename-column
14:54
Merge enhancements from trunk. check-in: c446c88411 user: drh tags: rtree-geopoly
2018-08-21
17:03
Fix a test case that was failing for SQLITE_ENABLE_STAT4 builds. check-in: 1e29fd430d user: dan tags: trunk
16:32
Rename internal function sqlite3RenameToken() to sqlite3RenameTokenMap() and sqlite3MoveRenameToken() to sqlite3RenameTokenRemap(). check-in: b9ae9a0a18 user: dan tags: alter-table-rename-column
15:06
Rationalize some duplicated code in alter.c. Also improve error messages for ALTER TABLE RENAME COLUMN in some cases. check-in: 5d2163c734 user: dan tags: alter-table-rename-column
12:46
Further attempts to reduce the number of false-positives genenerated by static analysis tools. check-in: 38f9ce6503 user: drh tags: trunk
12:16
Fix various harmless warnings generated by static analysis tools. check-in: a04a0ea9e3 user: drh tags: trunk
08:29
Minor changes to function tokenExpr() in order to claw back cycles lost to the rename-column change. check-in: 479976955e user: dan tags: alter-table-rename-column
2018-08-20
20:01
Add further tests for RENAME COLUMN. check-in: 82c4c10a96 user: dan tags: alter-table-rename-column
16:16
Ensure that it is not possible to rename columns of system tables, views or virtual tables. check-in: 786b5991dc user: dan tags: alter-table-rename-column
2018-08-18
18:27
Additional fixes for harmless compiler warnings that are specific to this branch. check-in: 9d8e73bf71 user: drh tags: alter-table-rename-column
18:14
Merge trunk fixes. check-in: ccad277927 user: drh tags: alter-table-rename-column
18:01
Have ALTER TABLE RENAME COLUMN also edit trigger and view definitions. check-in: 7908e8a4a3 user: dan tags: alter-table-rename-column
17:35
Improvements to error handling in ALTER TABLE RENAME COLUMN. Closed-Leaf check-in: 7fa1faeaff user: dan tags: edit-trigger-wrapper
2018-08-17
21:14
Fix harmless compiler warnings only seen with STAT4 enabled. check-in: 6f5e84bafc user: mistachkin tags: trunk
18:08
Allow an ALTER TABLE RENAME COLUMN to proceed even if the schema contains a virtual table for which the module is unavailable. check-in: 7b72b2360a user: dan tags: edit-trigger-wrapper
17:18
Ensure that CREATE VIEW, TRIGGER or INDEX statements can be edited by ALTER TABLE RENAME COLUMN even if they use collation-sequences or user-defined-functions that are not available. check-in: 540014efd6 user: dan tags: edit-trigger-wrapper
2018-08-16
19:49
Further progress on updating trigger programs as part of ALTER TABLE RENAME COLUMN. check-in: 3f47222b6e user: dan tags: edit-trigger-wrapper
16:24
Fix a harmless unused-variable compiler warning that only came up in certain compile-time configurations. check-in: 456842924b user: drh tags: trunk
15:29
Fix EXPLAIN QUERY PLAN so that it describes IN operators implemented using a ROWID lookup. check-in: 60045fbf52 user: drh tags: trunk
2018-08-15
20:28
Have ALTER TABLE RENAME COLUMN edit trigger programs. Only partly working. check-in: e272dc2b1c user: dan tags: edit-trigger-wrapper
14:03
Allow sqlite3_snapshot_open() to be called to change the snapshot after a read transaction is already open on database. check-in: 4139916995 user: dan tags: trunk
2018-08-14
21:05
Fix a problem when renaming an IPK column that is also part of a child key. check-in: 6e6a2bfdbb user: dan tags: edit-trigger-wrapper
21:03
Fix a problem when renaming an IPK column that is also part of a child key. check-in: ad15486022 user: dan tags: alter-table-rename-column
20:40
Merge latest trunk and ALTER TABLE error message improvements into this branch. check-in: 7a45802daf user: dan tags: edit-trigger-wrapper
20:38
Do not allow ALTER TABLE RENAME COLUMN on a virtual table. check-in: f6d6b47271 user: drh tags: alter-table-rename-column
19:27
Improved error messages when an ALTER TABLE RENAME COLUMN fails due to a duplicate column name. check-in: 37d11b8e82 user: drh tags: alter-table-rename-column
18:12
Merge fixes and enhancements from trunk. check-in: dff0314b7e user: drh tags: alter-table-rename-column
15:12
Fix UPSERT so that it checks the target-constraint first and fires the DO UPDATE if that constraint is violated regardless of whether or not other constraints are in violation. This aligns SQLite behavior with what PostgreSQL does. Fix for ticket [908f001483982c43cdb476dfb590a1a]. check-in: 529fb55e3d user: drh tags: trunk