/ File History
Login

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

History of tool/sqldiff.c

2020-01-10
00:20
[27026696] part of check-in [3d23a275] Begin making changes to turn off trusted schema in command-line tools that open SQLite databases. There are a lot of these, and a lot of places to change, which makes me wonder if trusted schema should be off by default. (check-in: [3d23a275] user: drh branch: default-untrusted-schema, size: 62503)
2018-11-09
23:41
[7b9b7238] part of check-in [a8d65214] Fix invalid use of unprotected sqlite3_value objects in the sqldiff utility, when using the --changeset option. (check-in: [a8d65214] user: drh branch: trunk, size: 62438)
2018-04-25
19:02
[579d7e4e] part of check-in [7dd34e37] Add new interfaces for accessing the list of SQL keywords: sqlite3_keyword_count(), sqlite3_keyword_name(), sqlite3_keyword_check(). (check-in: [7dd34e37] user: drh branch: trunk, size: 62543)
17:10
[c86f7e70] part of check-in [77a98a07] Add the new DO and NOTHING keywords to the keyword lists maintained by various extensions and auxiliary programs. (check-in: [77a98a07] user: drh branch: trunk, size: 64182)
2017-05-22
18:09
[30879bbc] part of check-in [0bb23c48] Fix incompatibilities between the "sqldiff --changeset" command and the sessions module. Specifically, allow sessions to process changesets containing tables with zero operations on them and have sqldiff output the expected output for tables with multi-column primary keys. (check-in: [0bb23c48] user: dan branch: trunk, size: 64161)
2016-09-12
14:23
[3fb48a6c] part of check-in [264e9c75] Fix a bug in sqldiff causing it to confuse blobs zero bytes in size with NULL values. (check-in: [264e9c75] user: dan branch: trunk, size: 64164)
2016-09-01
14:03
[7f567367] part of check-in [f4ba894a] Have "sqldiff --rbu" ignore rows with NULL values in primary key fields. RBU can't handle such rows and the documentation already says sqldiff ignores them. Because the code now uses "=" instead of "IS" to filter on primary key columns, diffs on virtual tables are faster now too. (check-in: [f4ba894a] user: dan branch: trunk, size: 64108)
2016-08-11
09:55
[c965d49b] part of check-in [ab83d707] Fix a 1 byte buffer overwrite in the "sqldiff --rbu" command. (check-in: [ab83d707] user: dan branch: trunk, size: 63968)
2016-07-22
10:09
[4478f0d3] part of check-in [87e25fc4] Fix a problem with upper case module names in the "sqldiff --vtab" command. (check-in: [87e25fc4] user: dan branch: trunk, size: 63966)
2016-07-08
02:14
[af5d80cd] part of check-in [8bb8d886] In the sqldiff program, make sure the first argument to the db_prepare() utility function is always a valid format string. (check-in: [8bb8d886] user: drh branch: trunk, size: 63951)
2016-06-21
10:34
[131e9c6e] part of check-in [5d0a9d4c] Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. (check-in: [5d0a9d4c] user: dan branch: sqldiff-vtab-support, size: 63934)
2016-03-19
16:21
[ca315aca] part of check-in [1f7afb6e] Update the sqldiff tool so that it generates an rbu_count table. (check-in: [1f7afb6e] user: dan branch: rbu-percent-progress, size: 59700)
2016-03-17
23:16
[0e9b76f9] part of check-in [65ba2f0b] Fix harmless compiler warnings that arise with -DSQLITE_OMIT_LOAD_EXTENSION (check-in: [65ba2f0b] user: drh branch: trunk, size: 59239)
2016-01-14
12:23
[5a262051] part of check-in [74808a79] Fix harmless compiler warnings in sqldiff.c. (check-in: [74808a79] user: drh branch: trunk, size: 59197)
2015-11-29
21:46
[653db1a9] part of check-in [64263ccb] Fix the sqldiff utility program so that it works for schemas that have tables with zero-length column names. (check-in: [64263ccb] user: drh branch: trunk, size: 59183)
2015-11-13
13:15
[db1232df] part of check-in [8882d1f3] Add the --transaction option to the sqldiff tool. (check-in: [8882d1f3] user: drh branch: trunk, size: 59133)
2015-11-09
12:47
[40e3458f] part of check-in [e0ed4c3e] Fix incorrect WHERE clause in sqldiff, as reported on the mailing list by Youcef Hilem. (check-in: [e0ed4c3e] user: drh branch: trunk, size: 58751)
2015-11-07
18:32
[37ab2cd4] part of check-in [7ea036ac] Enhance the sqldiff utility to deal gracefully with ALTER TABLE ADD COLUMN. (check-in: [7ea036ac] user: drh branch: trunk, size: 58748)
2015-08-20
21:09
[b318efc2] part of check-in [072279d4] Fix compiler warnings in the sqldiff tool seen with MSVC. (check-in: [072279d4] user: mistachkin branch: msvcWarn, size: 58293)
2015-08-08
22:47
[a6988cc6] part of check-in [be190fe7] Fix compiler warnings and remove unreachable code. (check-in: [be190fe7] user: drh branch: warnings, size: 58185)
2015-07-31
19:52
[4fe09e78] part of check-in [e26ef165] Add support for "fossil deltas" to RBU and "sqldiff --rbu". (check-in: [e26ef165] user: dan branch: trunk, size: 59362)
15:13
[664fbb0e] part of check-in [93449e70] Fix a problem causing [sqldiff --rbu] to fail on tables for which all columns are part of the PRIMARY KEY. (check-in: [93449e70] user: dan branch: trunk, size: 44036)
2015-07-30
20:26
[7ed3a042] part of check-in [098bea26] Add the --rbu switch to the "sqldiff" utility. (check-in: [098bea26] user: dan branch: trunk, size: 43785)
2015-05-12
12:24
[0748c0da] part of check-in [07c7d392] Try to get recent sqlite3_analyzer and sqldiff tests working for all tested combinations of compile-time options, especially SQLITE_OMIT_VIRTUALTABLE and SQLITE_OMIT_LOAD_EXTENSION. (check-in: [07c7d392] user: drh branch: trunk, size: 37831)
00:46
[e740816b] part of check-in [c223910e] Fix sqldiff.exe so that it always runs in single-thread mode. (check-in: [c223910e] user: drh branch: trunk, size: 37747)
2015-05-04
15:04
[10e3c011] part of check-in [9f428530] Fix a bug in --changeset output for sqldiff.exe for floating-point values. Also fix harmless compiler warnings in sqldiff.exe. (check-in: [9f428530] user: drh branch: trunk, size: 37701)
13:25
[81fff1d5] part of check-in [a117e8f6] Add the --lib option to the sqldiff.exe command-line utility. (check-in: [a117e8f6] user: drh branch: trunk, size: 37690)
2015-04-25
18:39
[8999f959] part of check-in [5f48d6f6] Fix compiler warnings in sqldiff. (check-in: [5f48d6f6] user: drh branch: trunk, size: 36841)
2015-04-17
12:16
[393b0f5b] part of check-in [b355ca3a] Fix the header comment on the sqldiff utility program. No code changes. (check-in: [b355ca3a] user: drh branch: trunk, size: 36841)
2015-04-14
19:01
[5c16cf3a] part of check-in [88b22761] Add the --summary option to the sqldiff command-line tool. (check-in: [88b22761] user: drh branch: trunk, size: 36702)
2015-04-11
13:48
[51c05cc1] part of check-in [1a2e2803] The --changeset option now appears to be working. (check-in: [1a2e2803] user: drh branch: sqldiff-changeset, size: 32201)
12:07
[ed945df3] part of check-in [5611fa9b] First complete attempt to generate a working changeset. Still contains bugs. (check-in: [5611fa9b] user: drh branch: sqldiff-changeset, size: 30744)
2015-04-10
19:41
[3e6f5435] part of check-in [463e38d7] Work toward adding the --changeset option to the sqldiff utility program. Changes are incomplete. This is an incremental check-in. (check-in: [463e38d7] user: drh branch: sqldiff-changeset, size: 28703)
2015-04-09
19:39
[05076365] part of check-in [ee53b460] Fix incorrect column names in UPDATE statements generated by the sqldiff utility. (check-in: [ee53b460] user: drh branch: trunk, size: 24398)
18:14
[9334ebc7] part of check-in [5063f907] Add the --primarykey option to the sqldiff tool, which causes it to use the schema-defined PRIMARY KEY. (check-in: [5063f907] user: drh branch: trunk, size: 24394)
13:40
[a28d17d8] part of check-in [32ab2bb9] Fix comment typos in the sqldiff.c utility program. (check-in: [32ab2bb9] user: drh branch: trunk, size: 22545)
13:34
[9c1c1e0a] part of check-in [88da5bf5] Add the "sqldiff" utility program. (check-in: [88da5bf5] user: drh branch: trunk, size: 22541) Added