Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
35 check-ins tagged with "generated-columns"
2019-10-24
| ||
23:43 | Merge fixes from trunk. (Closed-Leaf check-in: 4ec57d88 user: drh tags: generated-columns) | |
21:02 | The previous fix was incomplete. It is also necessary to disable the Expr.y.pTab field when making the translation. (check-in: b99d5701 user: drh tags: generated-columns) | |
20:29 | Fix handling of covering indexes that use virtual columns. (check-in: e0f7e321 user: drh tags: generated-columns) | |
01:04 | Do not allow ALTER TABLE ADD COLUMN for a STORED column. (check-in: 42fc08bc user: drh tags: generated-columns) | |
2019-10-23
| ||
15:47 | Minor adjustments for clarity and test coverage. (check-in: 30065716 user: drh tags: generated-columns) | |
03:53 | Fix incorrect arguments to testcase() macros. (check-in: 812467fb user: drh tags: generated-columns) | |
00:31 | Fix the foreign key logic to be compatible with generated columns. (check-in: 3de57145 user: drh tags: generated-columns) | |
2019-10-22
| ||
21:01 | Take the declared column time into account when computing the values for generated columns, and apply appropriate affinity. (check-in: 9e04ba22 user: drh tags: generated-columns) | |
20:16 | Merge the row-value fix from trunk. (check-in: 1fbd7438 user: drh tags: generated-columns) | |
15:45 | Do not allow generated columns in the PRIMARY KEY. (check-in: 1a54743a user: drh tags: generated-columns) | |
13:59 | In UPDATE processing, include generated columns in the set of columns being updated if and only if their generator expressions reference some other column that is being updated. (check-in: d38176e9 user: drh tags: generated-columns) | |
13:01 | New testcase() macros. Fix a problem with INSERT when the IPK is to the right of generated columns. (check-in: 412799fc user: drh tags: generated-columns) | |
12:02 | Merge changes on trunk into the generated-columns branch. (check-in: ba123b8c user: drh tags: generated-columns) | |
2019-10-21
| ||
01:04 | Changes to the INSERT logic to make it simpler and faster and so that it works with generated columns and BEFORE triggers. (check-in: bc368cb0 user: drh tags: generated-columns) | |
2019-10-19
| ||
18:47 | Work toward getting generated columns to work with triggers. Still more work to do in this area. (check-in: 932a3727 user: drh tags: generated-columns) | |
15:01 | Add testcase macros. (check-in: fb9c9bb2 user: drh tags: generated-columns) | |
13:29 | Refactor names of column index transformation functions, for clarity. Get generated columns working with ALTER TABLE RENAME COLUMN. (check-in: 27ab41c9 user: drh tags: generated-columns) | |
2019-10-18
| ||
18:33 | Fixes for WITHOUT ROWID tables with VIRTUAL columns and an INTEGER PRIMARY KEY. (check-in: 86074da0 user: drh tags: generated-columns) | |
17:47 | Merge trunk enhancements into the generated-columns branch. (check-in: 85bc4524 user: drh tags: generated-columns) | |
17:42 | Get generated columns working for WITHOUT ROWID tables. (check-in: 9f409649 user: drh tags: generated-columns) | |
12:52 | Claw back some performance from the sqlite3ExprGetColumnOfTable() routine. (check-in: e8426acb user: drh tags: generated-columns) | |
12:14 | Fix sqlite3ColumnOfIndex() to account for virtual columns. (check-in: 44727112 user: drh tags: generated-columns) | |
10:05 | Get indexes working on virtual columns. (check-in: 450c4876 user: drh tags: generated-columns) | |
02:19 | STORED columns can now reference other STORED columns, in any order, as long as there are not loops. (check-in: 0d236698 user: drh tags: generated-columns) | |
2019-10-17
| ||
18:35 | In the Table object, change the nVCol field to nNVCol - the number of non-virtual columns, as that is the quantity that we need most. (check-in: 4ad66af0 user: drh tags: generated-columns) | |
18:07 | Bug fix with INSERT using an explicit column list on a table with a non-final STORED column. (check-in: 61b4459a user: drh tags: generated-columns) | |
17:54 | Some (but not all) INSERT and UPDATE statements now work for STORED columns. (check-in: fe7517bf user: drh tags: generated-columns) | |
16:16 | Fix the xfer optimization for generated columns, so that VACUUM works again. (check-in: 8f67b89b user: drh tags: generated-columns) | |
15:59 | Basic UPDATE functionality working for VIRTUAL columns. (check-in: c21959d4 user: drh tags: generated-columns) | |
14:21 | Bug fixes so that "make test" once against runs with no errors. (check-in: 7bfe0f67 user: drh tags: generated-columns) | |
13:15 | Fix the table_info and table_xinfo pragmas so that they work with virtual columns. Table_info omits virtual columns. Table_xinfo gives them a "hidden" flag of 2, and 3 for STORED columns. (check-in: 069351b8 user: drh tags: generated-columns) | |
2019-10-16
| ||
22:01 | INSERT with named columns for a table with generated columns. (check-in: 64db39f9 user: drh tags: generated-columns) | |
20:05 | ALTER TABLE is able to add a VIRTUAL column. (check-in: 120c6b78 user: drh tags: generated-columns) | |
19:31 | Simple INSERT and SELECT operations working with VIRTUAL columns. (check-in: 7f9f90b1 user: drh tags: generated-columns) | |
12:18 | Initial experimental code for generated column support. Non-functional. (check-in: 11d472c1 user: drh tags: generated-columns) | |