Morph MORPH
SIGN IN SIGN UP
dhruvhead / sqlite UNCLAIMED
0 0 244 C

COMMITS

/ test/altertab3.test
autosetup
March 26, 2024
D
Avoid expanding integer values in columns with real affinity to the full 8-byte representation when editing records as part of a DROP COLUMN command.
dan committed
dcc1219
March 14, 2024
D
Fix a problem with ALTER TABLE and correlated multi-row VALUES clauses.
dan committed
26a3ef7
May 27, 2022
D
Fix further issues with ALTER TABLE and triggers that contain UPDATE..FROM statements.
dan committed
4209d55
April 19, 2022
D
Fix a problem in ALTER TABLE with handling "table.*" expressions within SELECT statements in triggers.
dan committed
cbde37d
September 29, 2021
D
Fix a typo in altertab3.test.
dan committed
0abb7ec
D
Fix another problem with ALTER TABLE and vector UPDATE statements within triggers.
dan committed
ab632bc
September 28, 2021
D
Fix a potential ALTER TABLE problem with expressions like ( (<sub-select>) IN () ).
dan committed
a7f7c1c
January 21, 2021
D
Fix a problem caused by using an SQL variable in an OVER clause within a trigger program.
dan committed
f380c3f
November 2, 2020
D
Fix an another OSS-Fuzz discovered assertion fault due to ALTER TABLE and
drh committed
6d5ab2a
October 31, 2020
D
Update the ALTER TABLE command to correctly handle UPDATE ... FROM statements within trigger programs.
dan committed
7a39fae
July 14, 2020
D
Support UPDATE...FROM statements in trigger programs.
dan committed
e7877b2
December 30, 2019
D
In ALTER TABLE, rename columns and tables in expressions that are optimized out by the "AND 0" optimization. Doing this also fixes an otherwise harmless assert() failure.
dan committed
2b6e670
December 27, 2019
D
Do not attempt to unwind the WITH stack in the Parse object following an error. This fixes a separate case to [de6e6d68].
dan committed
a6c1a71
December 20, 2019
D
Fix a potential problem with ALTER TABLE commands on schemas that contains a triggers or view featuring a sub-query that uses an ON clause with a join that is not a LEFT JOIN.
dan committed
394aa71
December 9, 2019
D
Add a NEVER() to the ALTER TABLE fix in check-in [1d2e53a39b87e364]
drh committed
2bc5cf9
D
Avoid infinite recursion in the ALTER TABLE code when a view contains an unused CTE that references, directly or indirectly, the view itself.
dan committed
3809696
December 5, 2019
D
Fix a problem in ALTER TABLE that could occur if an index, view or trigger in the schema features an expression of the form ((SELECT ...) IN ()) where the SELECT statement uses a CTE.
dan committed
e6dc1e5
December 4, 2019
D
Ensure that an ALWAYS() in the rename logic really is always true, even
drh committed
d63b69b
D
Fix an assert() failure that could occur in ALTER TABLE code when the schema contains a view that uses a CTE.
dan committed
8f40762
October 28, 2019
D
Fix a problem in fts3 causing it to report corruption if a doclist contains consectutive rowid entries that differ by more than 2^63.
dan committed
9930cfe
August 8, 2019
D
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
drh committed
175b8f0
August 5, 2019
D
Fix a problem with renaming a table when a view or trigger within the schema uses a FILTER with an aggregate function that is not currently registered with the database.
dan committed
72d1eac
August 1, 2019
D
Fix a problem in ALTER TABLE triggered by views or triggers that include the construction "ORDER BY true" or "ORDER BY false".
dan committed
71f059c
July 22, 2019
D
Fix a problem with renaming tables when the schema contains an invocation of a currently unregistered aggregate with a FILTER clause.
dan committed
1e60261
July 19, 2019
D
Fix a problem with renaming a table when the schema contains an invocation of a window function that is not currently registered.
dan committed
9bf022d
D
Fix a problem with renaming tables when the schema contains WINDOW definitions with (illegal) non-numeric expressions as part of a PRECEDING or FOLLOWING clause.
dan committed
750c6ba
D
Fix a faulty assert() in walker.c that could fail when processing an ALTER TABLE statement on a schema containing invalid table references that are part of a WINDOW definition.
dan committed
a1ac035
June 15, 2019
D
Add extra test case for one of the problems fixed by the previous commit.
dan committed
44c99ec
June 13, 2019
D
Fix a minor error in a test script, and harmless compiler warnings in the CLI code.
drh committed
4245e04
June 11, 2019
D
Have the ALTER TABLE code handle the case where an entire expression that includes a sub-select is excluded from a view, trigger or index.
dan committed
0b277a9
June 10, 2019
D
Have ALTER TABLE commands ignore the lhs of "expr IN ()" and "expr NOT IN ()" expressions, just as other queries do. Fix for [533010b8ca].
dan committed
e4a9e4d
D
Handle renaming a column or table when the schema contains a (meaningless) index on the constant expression ('text' IN ()) or ('text' NOT IN()).
dan committed
e20a894
April 29, 2019
D
Fix a stack overflow that could occur when renaming a table that has a trigger containing a window function invocation that itself contains a specific syntax error.
dan committed
490e6f2
April 12, 2019
D
Fix minor problems in tcl test scripts.
dan committed
150dfbd
March 20, 2019
D
Fix a potential dangling pointer deference in an ALTER TABLE run on a schema that contains constructs of the form "PRIMARY KEY(column COLLATE collation)".
dan committed
2381f6d
March 15, 2019
D
Ensure that ALTER TABLE commands open statement transactions. Fix for [596d059a].
dan committed
1f3b284
February 11, 2019
D
Build and test fixes for SQLITE_OMIT_WINDOWFUNC builds.
dan committed
8cd2e4a
January 24, 2019
D
Fix a problem with running ALTER TABLE on a schema that contains expressions of the type "col IN ()" (empty set on RHS of IN operator).
dan committed
f467744
January 23, 2019
D
Fix a problem with renaming a table within a schema that contains a composite query that uses a column alias as an ORDER BY term.
dan committed
a5f9f42
D
Fix problems with sub-selects in WINDOW definitions. Also rename-column operations when the column being renamed appears in a WINDOW definition that is part of a VIEW or TRIGGER.
dan committed
d999503