aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* The SET DEFAULT and SET NULL conflict resolution actions for foreign keydrh2019-11-01
| | | | | constraints should cause an error when they appear on a generated column. FossilOrigin-Name: b47513d2b32b61ba42c1e9b59287d28f6fee231e6c65de2a3aa19effbbaf1e7f
* Fix a potential use-after-free bug that follows an OOM error in codedrh2019-11-01
| | | | | | added two days ago by check-in [84e02d773d60cffe]. Problem discovered by OSSFuzz. FossilOrigin-Name: 0a2eb949f8a759e5745d9468c8183d3c0b4b30e0fa2a14b3062620eb9e1d5c1d
* Add another missing column number translation to the foreign key logic.drh2019-11-01
| | | FossilOrigin-Name: 32df5edcfef2605009f45d6ef1b97c63a99df07c7b4e00dc70f93001cfb8d81f
* Omit the optimization that reduces the column-count on rowid-table cursorsdrh2019-11-01
| | | | | | when the table has generated columns, because we do not know what columns the generator expressions might try to access. FossilOrigin-Name: e6c96ed91e7a96d2bd30ea9df132644ac02d5a321a62f81f8f3984a8e49ed94b
* Add missing column translations to foreign key logic.drh2019-11-01
| | | | | Ticket [c28a01da72f8957c] FossilOrigin-Name: bc6a43e7ee6353b9ef3dea4309c77e170a1c798eefcfaa7636bf5a93e51c47ee
* Correctly generate pre-UPDATE content for virtual columns that are useddrh2019-10-31
| | | | | by foreign key constraints. Ticket [b9befa4b83a660cc] FossilOrigin-Name: 40d3282ec285d9f724f6548283f48b601510cf5284da17485723fd650a68f436
* Ignore differences in Expr.op2 in sqlite3ExprCompare() in cases where itdrh2019-10-31
| | | | | does matter. Ticket [1d2a8efc6c3a595a]. FossilOrigin-Name: 329820673a12ff6a6c8759f40989d4ccf272441064b0366a5f491695b55ad0e9
* Enhance the TreeView logic to show information about Expr.op2 fordrh2019-10-31
| | | | | FUNCTION and COLUMN nodes. FossilOrigin-Name: aceeaf9e28767a0880a16872867a1f57bff163acd0f10d19d5688068077590fa
* Always disallow the use of non-deterministic functions in CHECK constraints,drh2019-10-30
| | | | | | | even date/time functions that use the 'now' or similar keywords. Provide improved error messages when this requirement is not met. Ticket [830277d9db6c3ba1] FossilOrigin-Name: 2978b65ebe25eeabe543b67cb266308cceb20082a4ae71565d6d083d7c08bc9f
* Simplify the bytecode generation for SQL function calls such that thedrh2019-10-30
| | | | | | OP_Function or OP_PureFunc opcodes are coded directly, rather than using the intermediate OP_Function0 or OP_PureFunc0 - opcodes that are now removed. FossilOrigin-Name: 84e02d773d60cffe619104991d21d7f0c68616c0f6bb99686bf54f5306c756d0
* New tokens ALWAYS, GENERATED, and STORED used by generated columns shoulddrh2019-10-30
| | | | | all be fallback tokens. FossilOrigin-Name: 13fe6978b7de208d2e27460d824f7fc778cf6ea0aabfe566b32bb410b8816f63
* Remove the legacy_file_format PRAGMA. In its place, provide thedrh2019-10-29
| | | | | | SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] FossilOrigin-Name: 4d424f3047b48fc441475137f30a719d2f079390c86fe2617710ddfb05c5e240
* Tighten the generated column requirement such that every table must havedrh2019-10-29
| | | | | at least one non-generated column. Ticket [166347c6fc994155]. FossilOrigin-Name: 4fba090e678ef184736277c9ec9a9374c8bd4df4d41f51a3dc6818e2efcc103b
* Add a missing translation from table column numbers to storage table numbersdrh2019-10-29
| | | | | | while processing constraints on an UPDATE statement. Ticket [9621dd78a024d07a] FossilOrigin-Name: 361ea81ae8a13e7d2ec4c2412f30e049bb6ee320980d502c86bedc315cdd3bc0
* Disallow tables that have only virtual columns.drh2019-10-29
| | | FossilOrigin-Name: 591973217f1caf24cde91dc15b7edca2edda05dac8ae2b2cd8d71e7aa072f7d1
* Remove a NEVER() comparison from sqlite3ExprCompare().drh2019-10-28
| | | FossilOrigin-Name: f4285297e1e7ebef90bfc0f71402a4e1726d31bc15b69fec13a1f0d98fed1f08
* ALWAYS macro added for coverage.drh2019-10-28
| | | FossilOrigin-Name: a1e1ba9145049491c593ac70d9e05149662d34770129c270d702f284cd19a481
* Improved detection of attempts to use a generated column as part of thedrh2019-10-27
| | | | | primary key. Ticket [91e86951016a6802] FossilOrigin-Name: 6d1bbba9a004a2491c76b4a7d09edb9b738102c46fdcb3e0f7b22bffa719518e
* Remove code from the constraint checker that generates virtual column valuesdrh2019-10-26
| | | | | | | with the incorrect time. Turns out the the regular code for all other columns works correctly and so the incorrect special-case code is not actually needed. Fix for ticket [3ea175512444b0d1]. FossilOrigin-Name: 5b4c0f2ddc6f324e23bbde0ee3d1ab672cfe8ab5044c9b693f4c33cdd75c211e
* Remove redundant code resulting from a merge error on the previous check-in.drh2019-10-26
| | | FossilOrigin-Name: 713fe86b8c9f3c9ef8af952019e99ba2f4741326226264de6a66baaeb1803d2a
* Add support for generated columns.drh2019-10-26
|\ | | | | FossilOrigin-Name: b855acf1831943b3914491ed0bc333131321930cab480a5281012a3aebbba492
| * Merge fixes from trunk.drh2019-10-24
| |\ | | | | | | FossilOrigin-Name: 4ec57d88415fa4ea2e99d4a5671074ec6829d6824bc8509d5ae9c978d47d1419
| * | The previous fix was incomplete. It is also necessary to disable thedrh2019-10-24
| | | | | | | | | | | | | | | Expr.y.pTab field when making the translation. FossilOrigin-Name: b99d5701312f7472e6b606bd824f9273617e2655920485bf50aa96d408064721
| * | Fix handling of covering indexes that use virtual columns.drh2019-10-24
| | | | | | | | | FossilOrigin-Name: e0f7e321eca91c49102649f70728de69347cbd7b16599b854203c24cfdc348e6
| * | Do not allow ALTER TABLE ADD COLUMN for a STORED column.drh2019-10-24
| | | | | | | | | FossilOrigin-Name: 42fc08bc1528a34a603c2c085b515766a8d33ae7ea0350a52b0ca24b94ebcbc5
| * | Minor adjustments for clarity and test coverage.drh2019-10-23
| | | | | | | | | FossilOrigin-Name: 30065716878d4058e75eb510b0b27b68e5193d04625eb173210de8061f20f499
| * | Fix incorrect arguments to testcase() macros.drh2019-10-23
| | | | | | | | | FossilOrigin-Name: 812467fbf04ce00228a8381a5eee471e4e35cc63184a4538129fcd70b7cec979
| * | Fix the foreign key logic to be compatible with generated columns.drh2019-10-23
| | | | | | | | | FossilOrigin-Name: 3de57145a18c62ff9b556c7218d8b276000d0052e4890212fa9335235f22d03c
| * | Take the declared column time into account when computing the values fordrh2019-10-22
| | | | | | | | | | | | | | | generated columns, and apply appropriate affinity. FossilOrigin-Name: 9e04ba22dfce3998e61331ac229ff543ecccc590284c9dd5def21efbe594fba0
| * | Merge the row-value fix from trunk.drh2019-10-22
| |\ \ | | | | | | | | FossilOrigin-Name: 1fbd7438611174aa594485241c8cc2f4ea6d09c57ef2fc16c8995e8061fdfdd6
| * | | Do not allow generated columns in the PRIMARY KEY.drh2019-10-22
| | | | | | | | | | | | FossilOrigin-Name: 1a54743a3d327efc8ecc45b9fde91ddfea3fca36408f9b753453c31f2e4cc69c
| * | | In UPDATE processing, include generated columns in the set of columns beingdrh2019-10-22
| | | | | | | | | | | | | | | | | | | | | | | | updated if and only if their generator expressions reference some other column that is being updated. FossilOrigin-Name: d38176e93a628e03f1bd8b689fbc4152a1495388da917c2d89cefed04353d2d6
| * | | New testcase() macros. Fix a problem with INSERT when the IPK is to thedrh2019-10-22
| | | | | | | | | | | | | | | | | | | | right of generated columns. FossilOrigin-Name: 412799fc5527aaca987e4e04b8a4f774dcdb70fb80e3a126dc3a26d48a66935c
| * | | Merge changes on trunk into the generated-columns branch.drh2019-10-22
| |\ \ \ | | | | | | | | | | FossilOrigin-Name: ba123b8c201053d8f9387de38f3513b06f7721b28d79fab8489f96d336105117
| * | | | Changes to the INSERT logic to make it simpler and faster and so thatdrh2019-10-21
| | | | | | | | | | | | | | | | | | | | | | | | | it works with generated columns and BEFORE triggers. FossilOrigin-Name: bc368cb090376d33d3844e3689c4f6bd19eed758e39b878ee67fef93b1c839ea
| * | | | Work toward getting generated columns to work with triggers. Still moredrh2019-10-19
| | | | | | | | | | | | | | | | | | | | | | | | | work to do in this area. FossilOrigin-Name: 932a37275d7e932f8237d32c8fc6087ed8cd342fe01ef2f7a43c7237ab84c9ac
| * | | | Add testcase macros.drh2019-10-19
| | | | | | | | | | | | | | | FossilOrigin-Name: fb9c9bb284d441bd7aa34c87b6fd8ce57d036c17623d82354154fc6286bdd134
| * | | | Refactor names of column index transformation functions, for clarity.drh2019-10-19
| | | | | | | | | | | | | | | | | | | | | | | | | Get generated columns working with ALTER TABLE RENAME COLUMN. FossilOrigin-Name: 27ab41c9102e7801ff829488fc123a8040da008bef373d6704efbe2f93e1da90
| * | | | Fixes for WITHOUT ROWID tables with VIRTUAL columns and an INTEGER PRIMARY KEY.drh2019-10-18
| | | | | | | | | | | | | | | FossilOrigin-Name: 86074da0fd2949e231898ef0bc672d90fd89cefa49fb0eb50ff398fbdd91d1ad
| * | | | Merge trunk enhancements into the generated-columns branch.drh2019-10-18
| |\ \ \ \ | | | | | | | | | | | | FossilOrigin-Name: 85bc4524d76999080faa4474e8880d2b6a2ac3a7f6a76239af4de1a42f8138c8
| * | | | | Get generated columns working for WITHOUT ROWID tables.drh2019-10-18
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: 9f409649ec4282a47f0a8b079b419f1922e0c24779b297f477ced168d5b7910d
| * | | | | Claw back some performance from the sqlite3ExprGetColumnOfTable() routine.drh2019-10-18
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: e8426acb94179ff49549aced6ea3c26c49ba4761c2f414fa1772d6a031edc79d
| * | | | | Fix sqlite3ColumnOfIndex() to account for virtual columns.drh2019-10-18
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: 447271123e3b467d9271a4c0cf27f47af2f865c9298b8c355d9e766411a1f422
| * | | | | Get indexes working on virtual columns.drh2019-10-18
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: 450c48766c8e62653d074c95f69b0576de3880d183a1d1e5992d88b6fce6cc39
| * | | | | STORED columns can now reference other STORED columns, in any order, as longdrh2019-10-18
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | as there are not loops. FossilOrigin-Name: 0d236698e64b2a4b46f91a25279c406e0bf392fe66116678456f0a034c11d7b4
| * | | | | In the Table object, change the nVCol field to nNVCol - the number ofdrh2019-10-17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | non-virtual columns, as that is the quantity that we need most. FossilOrigin-Name: 4ad66af04a654d92711d2d056ce8f35cd21eac4b99fb8d78be1a314620b6d29e
| * | | | | Bug fix with INSERT using an explicit column list on a table withdrh2019-10-17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | a non-final STORED column. FossilOrigin-Name: 61b4459ae6a6cc182c11abbc8b1dd629f77beb088d7ccad5e563d8d4769056df
| * | | | | Some (but not all) INSERT and UPDATE statements now work for STORED columns.drh2019-10-17
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: fe7517bf4d360597576ab9aba29627d7926d23f2bbbfb3e7bf4d32761617574c
| * | | | | Fix the xfer optimization for generated columns, so that VACUUM works again.drh2019-10-17
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: 8f67b89b04622c1509dc102a83be7a80057dc791625804fc2c294089c98b97e4
| * | | | | Basic UPDATE functionality working for VIRTUAL tables.drh2019-10-17
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: c21959d4eb5d742a097a98e1874c0bf132dc962a97a65be1ab22d6ca3cf2b261