SQLite

All files named ”test/alter4.test”
Login

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

History for test/alter4.test

2025-04-10
10:18
[37cafe1640] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 10372)
2025-02-27
21:17
[da7a702818] part of check-in [f50c21484d] Approximately 100 typo corrections spanning the whole tree, submitted via forum post 0db9827f0464bc33 and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. (check-in: [f50c21484d] user: stephan branch: trunk, size: 10376)
2024-02-29
13:44
[0ef8e62259] part of check-in [2266086cf0] Add the ability to DROP one or more objects of the same class in a single statement by listing the objects as multiple arguments to the DROP command. (check-in: [2266086cf0] user: drh branch: multi-drop, size: 10344)
2021-04-27
13:04
[716caa071d] part of check-in [d0b15eccbf] RETURNING bug fix: Correctly deal with RETURNING statements on changes to TEMP tables that also have triggers. dbsqlfuzz 78b9400770ef8cc7d9427dfba26f4fcf46ea7dc2 (check-in: [d0b15eccbf] user: drh branch: trunk, size: 10376)
2020-07-29
16:18
[0f19af0e93] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 10336)
2020-05-08
19:02
[dfd6086faf] part of check-in [3a16c0ce4d] Release some restrictions on columns added by ALTER TABLE so that they only apply if the table contains one or more rows. (check-in: [3a16c0ce4d] user: drh branch: trunk, size: 10336)
2019-10-29
16:18
[74b22251c5] part of check-in [4d424f3047] Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] (check-in: [4d424f3047] user: drh branch: trunk, size: 10269)
2018-09-01
20:23
[7e93a21fe1] 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: 10259)
2016-12-16
01:00
[b6d7b86860] part of check-in [8d646905b8] All temp.sqlite_master to be used as an alias for sqlite_temp_master. (check-in: [8d646905b8] user: drh branch: trunk, size: 9581)
2016-07-14
19:13
[0c33c54224] part of check-in [a7db6e45ad] Fix ALTER TABLE so that it does not promote the schema version past 3, as that will cause DESC indexes to go corrupt. Ticket [f68bf68513a1c]. (check-in: [a7db6e45ad] user: drh branch: trunk, size: 9095)
2014-08-25
20:11
[c461150723] part of check-in [91d8a8d0b7] Allow CAST expressions and unary "+" operators to be used in the DEFAULT argument of an ALTER TABLE ADD COLUMN and to be understand on the RHS of range constraints interpreted by STAT3/4. This involves a rewrite of the implementation of the CAST operator. (check-in: [91d8a8d0b7] user: drh branch: trunk, size: 8630)
2014-03-04
21:00
[d6c011fa0d] part of check-in [e072cb3ee2] Fix a problem with "DEFAULT (-(-9223372036854775808))" clauses in ALTER TABLE ... ADD COLUMN commands. (check-in: [e072cb3ee2] user: dan branch: trunk, size: 8629)
2013-08-08
12:21
[8e93bf7a7e] part of check-in [9fec3e3828] Fix a segfault in "ALTER TABLE t1 ADD COLUMN b DEFAULT (-+1)". Also an assert() failure that could occur if SQLITE_ENABLE_STAT4 were not defined. (check-in: [9fec3e3828] user: dan branch: sqlite_stat4, size: 8014)
2011-08-02
00:57
[b2debc14d8] part of check-in [9007586fda] Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. (check-in: [9007586fda] user: mistachkin branch: winopen-retry-logic, size: 7875)
2010-09-06
20:28
[1e5dd6b951] part of check-in [f53856a555] In the test scripts, changes instances of the TCL interface option "-has_codec" into the correct "-has-codec". (check-in: [f53856a555] user: drh branch: trunk, size: 7896)
2009-02-02
18:03
Added: [9386ffd1e9] part of check-in [3b0a25548c] Omit the TEMP keyword from the schema of TEMP tables created using CREATE TEMP TABLE AS SELECT ..... Ticket #3630. (CVS 6232) (check-in: [3b0a25548c] user: drh branch: trunk, size: 9132)