Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/altertab.test
|
2023-04-13
| ||
| 18:44 | [8a2712f907] part of check-in [c4845a7c5f] Fix an obscure issue with ALTER TABLE RENAME that comes up with triggers that have UPDATE statements that contain errors. Forum post ff3840145a. (check-in: [c4845a7c5f] user: drh branch: trunk, size: 25132) | |
|
2021-11-04
| ||
| 00:51 | [7273b8506e] part of check-in [005a864277] First the shadow table mechanism so that it works even if the shadow table comes before the virtual table in the sqlite_schema table, as can happen after a VACUUM. (check-in: [005a864277] user: drh branch: trunk, size: 24593) | |
|
2021-07-02
| ||
| 12:08 | [a13e11cb19] part of check-in [79443aabe1] Fix a harmless assertion fault discovered by OSSFuzz. The assertion fault is harmless because the assert() checks a condition that that is harmless if false and the assert() is disabled in production builds. (check-in: [79443aabe1] user: drh branch: trunk, size: 24581) | |
|
2021-06-14
| ||
| 20:08 | [466b975763] part of check-in [c09d90eec2] Fix an ALTER TABLE problem with handling infinite loops of CTEs in the database schema. (check-in: [c09d90eec2] user: dan branch: trunk, size: 24252) | |
|
2021-06-10
| ||
| 19:37 | [4120b9b2ba] part of check-in [5079b5d58f] Fix an assert() added by the previous commit that could fail with some database schemas. (check-in: [5079b5d58f] user: dan branch: alter-table-cte-fix-1, size: 23872) | |
| 19:08 | [8483f9b13f] part of check-in [32e3ecfc8b] Fix problems with ALTER TABLE and schemas that contain views with complex CTEs. (check-in: [32e3ecfc8b] user: dan branch: alter-table-cte-fix-1, size: 22214) | |
|
2021-06-01
| ||
| 15:37 | [a96e2169bb] part of check-in [587a304446] Fix a problem with running ALTER TABLE against schemas that contain compound SELECT statements with ORDER BY clauses containing one or more references to the second or subsequent component SELECT statements. This fixes the problem reported by forum post 31ceaa8461. (check-in: [587a304446] user: dan branch: trunk, size: 20665) | |
|
2021-05-17
| ||
| 16:20 | [c7966d92e4] part of check-in [4c6cd54a8d] Fix problems with refering to CTEs from within sub-selects in PARTITION BY or ORDER BY clauses of window frame definitions. Also a problem with renaming a column when the schema contains a trigger containing a correlated sub-select within a window frames PARTITION BY or ORDER BY clause. (check-in: [4c6cd54a8d] user: dan branch: trunk, size: 20144) | |
|
2021-05-01
| ||
| 12:09 | [281e89a693] part of check-in [20a4f3f12c] Back out the NEVER() inserted by [c7309ed3c7588c7e] because it is reachable after all. dbsqlfuzz bc17a306a09329bba0ecc61547077f6178bcf321 (check-in: [20a4f3f12c] user: drh branch: trunk, size: 19673) | |
|
2021-04-26
| ||
| 20:18 | [2591f93cc1] part of check-in [db03215693] refix altertab.test (check-in: [db03215693] user: larrybr branch: trunk, size: 19135) | |
|
2021-04-25
| ||
| 23:13 | [2f5a008e0c] part of check-in [6fcb2438f8] Skip test when no JSON. (check-in: [6fcb2438f8] user: larrybr branch: trunk, size: 19129) | |
|
2021-04-24
| ||
| 12:20 | [51e744cd23] part of check-in [32255e39cb] Fix testcase altertab-25.1 due to check-in [c7909e8e0d0577c6] disallowing ALTER TABLE on eponymous virtual tables. (check-in: [32255e39cb] user: drh branch: trunk, size: 19104) | |
|
2021-04-23
| ||
| 11:37 | [2af1ca53fd] part of check-in [dfadb96edf] Fix an assert() in fts5_index.c that may fail if the database records are corrupt. (check-in: [dfadb96edf] user: dan branch: trunk, size: 19081) | |
|
2021-03-20
| ||
| 15:11 | [d15362de3d] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 18784) | |
|
2021-03-08
| ||
| 17:22 | [7691872aad] part of check-in [9c9ba36e85] Add test cases for ALTER TABLE. (check-in: [9c9ba36e85] user: dan branch: trunk, size: 18785) | |
|
2020-10-12
| ||
| 15:27 | [6d7bbac2c4] part of check-in [bc4bb9433f] Fix ALTER TABLE so that it can run even if the schema contains unknown collation sequences. (check-in: [bc4bb9433f] user: dan branch: trunk, size: 18067) | |
|
2020-07-01
| ||
| 16:19 | [b8b2104212] part of check-in [27d4a9a7b5] Ensure that the "PRAGMA schema_version" command causes the schema to be reparsed and reloaded. (check-in: [27d4a9a7b5] user: drh branch: trunk, size: 17221) | |
|
2020-04-09
| ||
| 18:51 | [935bdca186] part of check-in [d6fda470fe] Merge recent trunk changes into the apple-osx branch. (check-in: [d6fda470fe] user: drh branch: apple-osx, size: 16769) | |
|
2020-04-03
| ||
| 11:52 | [523ba6368e] part of check-in [684293882c] Do not suppress errors when resolving references in an ORDER BY clause belonging to a compound SELECT within a view or trigger within ALTER TABLE. Fix for ticket [a10a14e9b4ba2]. (check-in: [684293882c] user: dan branch: trunk, size: 16666) | |
| 11:20 | [2c41e347c0] part of check-in [d09f8c3621] Fix a case when a pointer might be used after being freed in the ALTER TABLE code. Fix for [4722bdab08cb1]. (check-in: [d09f8c3621] user: dan branch: trunk, size: 16100) | |
|
2020-02-23
| ||
| 17:34 | [89735fee87] part of check-in [c431b3fd8f] Fix a problem with ALTER TABLE for views that have a nested FROM clause. Ticket [f50af3e8a565776b]. (check-in: [c431b3fd8f] user: drh branch: trunk, size: 15880) | |
|
2020-01-17
| ||
| 15:33 | [784e2afcff] part of check-in [b302b260ca] More restrictions on changes to shadow tables when in defensive mode. (check-in: [b302b260ca] user: drh branch: branch-3.28, size: 14456) | |
| 14:56 | [d85205b033] part of check-in [ad1f760f16] Do not allow shadow tables to be dropped in defensive mode. (check-in: [ad1f760f16] user: drh branch: branch-3.28, size: 13877) | |
|
2020-01-15
| ||
| 12:49 | [8f94e669ea] part of check-in [dadedf41c7] Merge all recent enhancements and fixes from trunk into the apple-osx branch. (check-in: [dadedf41c7] user: drh branch: apple-osx, size: 15501) | |
|
2020-01-01
| ||
| 15:43 | [bd61e5b73d] part of check-in [473892a8ec] New test-only SQL functions: implies_nonnull_row(), expr_compare(), and expr_implies_expr(). The SQLITE_TESTCTRL_INTERNAL_FUNCTIONS test-control is modified to toggle internal function access on and off for a single database connection. (check-in: [473892a8ec] user: drh branch: trunk, size: 15398) | |
|
2019-12-19
| ||
| 03:14 | [a85f1462f2] part of check-in [4146c629c6] More restrictions on changes to shadow tables when in defensive mode. (check-in: [4146c629c6] user: drh branch: branch-3.30, size: 15380) | |
|
2019-11-16
| ||
| 14:15 | [4d8b79b0b8] part of check-in [6aef58b629] Do not allow CREATE TABLE or CREATE VIEW of an object with a name that looks like a shadow table name. (check-in: [6aef58b629] user: drh branch: defensive-improvements, size: 15396) | |
| 12:04 | [8069e5a8cb] part of check-in [70390bbca4] Do not allow shadow tables to be dropped in defensive mode. (check-in: [70390bbca4] user: drh branch: trunk, size: 14817) | |
|
2019-08-08
| ||
| 15:24 | [b2004ac589] part of check-in [1e17ea2fd1] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2fd1] user: drh branch: omit-stat3, size: 14710) | |
|
2019-05-06
| ||
| 16:15 | [b690128747] part of check-in [91f701d398] Fix a problem with renaming an INTEGER PRIMARY KEY column of a WITHOUT ROWID table using ALTER TABLE. (check-in: [91f701d398] user: dan branch: trunk, size: 14711) | |
|
2019-04-19
| ||
| 16:34 | [372df7d8f0] part of check-in [a2ead8aa45] Fix a problem with renaming a table that starts with "sqlite". Fix for ticket [f00d7b65]. (check-in: [a2ead8aa45] user: dan branch: trunk, size: 14068) | |
|
2018-12-18
| ||
| 20:31 | [6e13f13d8c] part of check-in [23e200da5c] In defensive mode, do not allow shadow tables to be renamed using ALTER TABLE. (check-in: [23e200da5c] user: dan branch: trunk, size: 13770) | |
|
2018-11-26
| ||
| 18:09 | [17e46baa6b] part of check-in [6e1330545e] Do not allow direct access to internal-use SQL functions such as sqlite_rename_column() and sqlite3_rename_table() except when the new SQLITE_TESTCTRL_INTERNAL_FUNCTIONS flag is set. (check-in: [6e1330545e] user: drh branch: trunk, size: 12466) | |
|
2018-11-07
| ||
| 02:17 | [ebb159e815] part of check-in [3212733cb6] Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. (check-in: [3212733cb6] user: drh branch: read-only-shadow, size: 12346) | |
|
2018-10-01
| ||
| 07:04 | [fb8a9a2ab6] part of check-in [c52f457e56] Fix a problem with ALTER TABLE commands when the schema features an INSTEAD of trigger that uses NEW.* or OLD.*. (check-in: [c52f457e56] user: dan branch: trunk, size: 12347) | |
|
2018-09-17
| ||
| 08:27 | [3b830144c1] part of check-in [1856ea63b3] Add extra test for the fix on this branch. Also fix a pointer-compare-after-free problem that occurs in similar cases. (check-in: [1856ea63b3] user: dan branch: tkt-b41031ea, size: 11259) | |
|
2018-09-07
| ||
| 18:56 | [fe08624ef1] part of check-in [64c3ee3c25] Add extra test case to altertab.test. (check-in: [64c3ee3c25] user: dan branch: trunk, size: 10133) | |
| 15:50 | [d986bf9e29] part of check-in [ceb60bd7e5] Fix a problem with renaming a non-temp table that has at least one temp trigger and shares its name with a temp table. (check-in: [ceb60bd7e5] user: dan branch: trunk, size: 9672) | |
|
2018-09-06
| ||
| 18:56 | [16a0673660] part of check-in [91aab32e71] Fix a problem with ALTER TABLE when there are views or triggers in the schema that contain "<expr> IS NULL" expressions. (check-in: [91aab32e71] user: dan branch: trunk, size: 9246) | |
| 17:47 | [65f08c3bc8] part of check-in [fa835145e6] Fix a problem in ALTER TABLE with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: [fa835145e6] user: dan branch: trunk, size: 9208) | |
| 17:23 | [97aa6977e8] part of check-in [37ad064e5f] Fix test script problems causing SQLITE_OMIT_VIRTUALTABLE builds to fail. (check-in: [37ad064e5f] user: dan branch: trunk, size: 9119) | |
| 16:01 | [bd1fbe88c9] part of check-in [ffecfca511] Ensure that the tbl_name column in the sqlite_temp_master table is updated correctly as part of a RENAME TABLE operation. (check-in: [ffecfca511] user: dan branch: alter-table-rename-column, size: 9068) | |
|
2018-09-05
| ||
| 17:45 | [51698a8ada] part of check-in [f804336f08] Fix some test script errors. And an incorrect assert() in fts5. (check-in: [f804336f08] user: dan branch: alter-table-rename-column, size: 8071) | |
|
2018-09-03
| ||
| 20:05 | [6c37c18200] part of check-in [6805b5900d] Improve the error messages emitted by RENAME TABLE. (check-in: [6805b5900d] user: dan branch: alter-table-rename-column, size: 7692) | |
|
2018-09-01
| ||
| 20:38 | [0221db3e69] part of check-in [828e8849fa] Add another test case to altertab.test. (check-in: [828e8849fa] user: dan branch: alter-table-rename-column, size: 6669) | |
| 20:23 | [c273f24c1b] part of check-in [336b8a0923] Fix a problem with renaming a column in a table that has a temp trigger that references another attached database. (check-in: [336b8a0923] user: dan branch: alter-table-rename-column, size: 5947) | |
|
2018-08-30
| ||
| 20:03 | [8c9631e9da] part of check-in [f3c27d916d] Test the schema after renaming a table. Ensure that temp database triggers and views are updated when renaming a column. (check-in: [f3c27d916d] user: dan branch: alter-table-rename-table, size: 5080) | |
| 16:26 | [5b768709de] part of check-in [72cfb1be29] Fix an ALTER TABLE problem with processing temp schema views and triggers. (check-in: [72cfb1be29] user: dan branch: alter-table-rename-table, size: 4394) | |
|
2018-08-29
| ||
| 21:00 | Added: [6b2ebbe3a8] part of check-in [01308bae3a] Extend RENAME TABLE to edit triggers and views. Still buggy. (check-in: [01308bae3a] user: dan branch: alter-table-rename-table, size: 3943) | |