Changelogs sourced from existing Postgres db generateChangeLog/diffChangeLog commands - out of logical order XML/SQL?

I’m new to Liquibase and seem to have things configured and producing and comparing pretty much as expected. However, I tried to generate changes with both the generateChangeLog/diffChangeLog commands with both XML and SQL outputs from the generateChangeLog/diffChangeLog commands on some already existing demo databases. It behaved the same for both. There are “alter table” statements at the beginning of the XML/SQL in both cases – for when the target DB is obviously empty. The tables obviously wouldn’t exist in the DB at the beginning of the scripts where the alter table statements are. Am I missing something or an argument somewhere? Is the XML ordered in the file? And if not, why would the SQL file that we produced match the order of the XML?

Version info: Liquibase at 18:26:58 (version 4.3.3 #52 built at 2021-04-12 17:08+0000)
Running the Liquibase docker image liquibase/liquibase

Here’s my command line

liquibase --liquibaseProLicenseKey=redacted --driver=org.postgresql.Driver --referenceDriver=org.postgresql.Driver --url=jdbc:postgresql://localhost/emptydb --referenceurl=jdbc:postgresql://localhost/model_db --classpath=postgresql-42.2.20.jar --username=postgres --password=password --defaultSchemaName=public --referenceusername=postgres --referencepassword=password --changeLogFile=/liquibase/changelog/diff_db_emptydb_public_to_db_model_db_public.xml diffChangeLog

Additionally, I moved the alter statements later in the file to beyond where all of the table create steps are, and then get failures on the alter commands as the columns already exists??? Why are these alter table commands in the generated output anyway?

Could you provide examples of the files that were generated?

Thanks for the follow up, and absolutely! I am doing a spike using a data model that’s more than just trivial to get a better comparison to a real world already existing product that we’ll be implenting with. The source for the database that I created is the SportsDB model (postgres version) sourced from here in case you’d like to try it yourself: The Sports Standards Alliance.

Here’s the echo of the command line that executed:
liquibase --driver=org.postgresql.Driver --referenceDriver=org.postgresql.Driver --url=jdbc:postgresql://localhost/emptydb
–referenceurl=jdbc:postgresql://localhost/testdb --classpath=postgresql-42.2.20.jar
–username=postgres --password=Password --defaultSchemaName=public --referenceusername=postgres --referencepassword=Password
–changeLogFile=/liquibase/changelog/diff_db_172_17_0_2_emptydb_public_to_db_172_17_0_2_testdb_public.sql
–liquibaseProLicenseKey=REDACTED diffChangeLog
Liquibase Pro 4.3.3 by Datical licensed to Liquibase Pro Evaluation until Wed May 26 00:00:00 UTC 2021

PARTIAL OUTPUT
UPDATE: The output is about 4 times longer than the message allows. I truncated enough off to get it to allow me to post which just shows the alter statements prior to any create table statements at all.

– liquibase formatted sql

– changeset ?:1619806142790-1
ALTER TABLE “public”.“baseball_event_states” ADD “batter_id” INTEGER;

– changeset ?:1619806142790-2
ALTER TABLE “public”.“baseball_event_states” ADD “pitcher_id” INTEGER;

– changeset ?:1619806142790-3
ALTER TABLE “public”.“addresses” ADD “postal_code” VARCHAR(100);

– changeset ?:1619806142790-4
ALTER TABLE “public”.“person_phases” ADD “end_season_id” INTEGER;

– changeset ?:1619806142790-5
ALTER TABLE “public”.“addresses” ADD “region” VARCHAR(100);

– changeset ?:1619806142790-6
ALTER TABLE “public”.“person_phases” ADD “start_season_id” INTEGER;

– changeset ?:1619806142790-7
ALTER TABLE “public”.“baseball_event_states” ADD “runner_on_third_id” INTEGER;

– changeset ?:1619806142790-8
ALTER TABLE “public”.“addresses” ADD “locality” VARCHAR(100);

– changeset ?:1619806142790-9
ALTER TABLE “public”.“baseball_event_states” ADD “runner_on_second_id” INTEGER;

– changeset ?:1619806142790-10
ALTER TABLE “public”.“standings” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-11
ALTER TABLE “public”.“documents” ADD “source_id” INTEGER;

– changeset ?:1619806142790-12
ALTER TABLE “public”.“baseball_event_states” ADD “runner_on_first_id” INTEGER;

– changeset ?:1619806142790-13
ALTER TABLE “public”.“american_football_event_states” ADD “team_in_possession_id” INTEGER;

– changeset ?:1619806142790-14
ALTER TABLE “public”.“documents” ADD “document_fixture_id” INTEGER NOT NULL;

– changeset ?:1619806142790-15
ALTER TABLE “public”.“persons” ADD “death_location_id” INTEGER;

– changeset ?:1619806142790-16
ALTER TABLE “public”.“media” ADD “creation_location_id” INTEGER NOT NULL;

– changeset ?:1619806142790-17
ALTER TABLE “public”.“person_event_metadata” ADD “team_id” INTEGER;

– changeset ?:1619806142790-18
ALTER TABLE “public”.“injury_phases” ADD “season_id” INTEGER;

– changeset ?:1619806142790-19
ALTER TABLE “public”.“team_phases” ADD “role_id” INTEGER;

– changeset ?:1619806142790-20
ALTER TABLE “public”.“persons” ADD “residence_location_id” INTEGER;

– changeset ?:1619806142790-21
ALTER TABLE “public”.“person_phases” ADD “regular_position_id” INTEGER;

– changeset ?:1619806142790-22
ALTER TABLE “public”.“baseball_action_substitutions” ADD “person_replacing_position_id” INTEGER;

– changeset ?:1619806142790-23
ALTER TABLE “public”.“documents” ADD “revision_id” VARCHAR(75);

– changeset ?:1619806142790-24
ALTER TABLE “public”.“person_event_metadata” ADD “position_id” INTEGER;

– changeset ?:1619806142790-25
ALTER TABLE “public”.“baseball_action_substitutions” ADD “person_replacing_id” INTEGER;

– changeset ?:1619806142790-26
ALTER TABLE “public”.“persons” ADD “hometown_location_id” INTEGER;

– changeset ?:1619806142790-27
ALTER TABLE “public”.“injury_phases” ADD “end_date_time” TIMESTAMP WITHOUT TIME ZONE;

– changeset ?:1619806142790-28
ALTER TABLE “public”.“media” ADD “credit_id” INTEGER NOT NULL;

– changeset ?:1619806142790-29
ALTER TABLE “public”.“stats” ADD “context” VARCHAR(40) NOT NULL;

– changeset ?:1619806142790-30
ALTER TABLE “public”.“stats” ADD “stat_coverage_id” INTEGER;

– changeset ?:1619806142790-31
ALTER TABLE “public”.“injury_phases” ADD “start_date_time” TIMESTAMP WITHOUT TIME ZONE;

– changeset ?:1619806142790-32
ALTER TABLE “public”.“person_event_metadata” ADD “role_id” INTEGER;

– changeset ?:1619806142790-33
ALTER TABLE “public”.“documents” ADD “priority” VARCHAR(100);

– changeset ?:1619806142790-34
ALTER TABLE “public”.“core_person_stats” ADD “position_id” INTEGER;

– changeset ?:1619806142790-35
ALTER TABLE “public”.“baseball_action_pitches” ADD “pitch_type” VARCHAR(100);

– changeset ?:1619806142790-36
ALTER TABLE “public”.“person_phases” ADD “phase_status” VARCHAR(40);

– changeset ?:1619806142790-37
ALTER TABLE “public”.“participants_events” ADD “event_outcome” VARCHAR(100);

– changeset ?:1619806142790-38
ALTER TABLE “public”.“persons” ADD “birth_location_id” INTEGER;

– changeset ?:1619806142790-39
ALTER TABLE “public”.“stats” ADD “stat_coverage_type” VARCHAR(100);

– changeset ?:1619806142790-40
ALTER TABLE “public”.“media” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-41
ALTER TABLE “public”.“baseball_action_substitutions” ADD “person_original_position_id” INTEGER;

– changeset ?:1619806142790-42
ALTER TABLE “public”.“affiliation_phases” ADD “end_season_id” INTEGER;

– changeset ?:1619806142790-43
ALTER TABLE “public”.“baseball_action_pitches” ADD “umpire_call” VARCHAR(100);

– changeset ?:1619806142790-44
ALTER TABLE “public”.“wagering_total_score_lines” ADD “team_id” INTEGER NOT NULL;

– changeset ?:1619806142790-45
ALTER TABLE “public”.“wagering_straight_spread_lines” ADD “team_id” INTEGER NOT NULL;

– changeset ?:1619806142790-46
ALTER TABLE “public”.“wagering_runlines” ADD “team_id” INTEGER NOT NULL;

– changeset ?:1619806142790-47
ALTER TABLE “public”.“wagering_odds_lines” ADD “team_id” INTEGER NOT NULL;

– changeset ?:1619806142790-48
ALTER TABLE “public”.“wagering_moneylines” ADD “team_id” INTEGER NOT NULL;

– changeset ?:1619806142790-49
ALTER TABLE “public”.“stats” ADD “stat_holder_id” INTEGER;

– changeset ?:1619806142790-50
ALTER TABLE “public”.“events” ADD “site_id” INTEGER;

– changeset ?:1619806142790-51
ALTER TABLE “public”.“american_football_action_participants” ADD “score_type” VARCHAR(100);

– changeset ?:1619806142790-52
ALTER TABLE “public”.“person_phases” ADD “role_id” INTEGER;

– changeset ?:1619806142790-53
ALTER TABLE “public”.“baseball_action_substitutions” ADD “person_original_id” INTEGER;

– changeset ?:1619806142790-54
ALTER TABLE “public”.“american_football_action_plays” ADD “drive_result” VARCHAR(100);

– changeset ?:1619806142790-55
ALTER TABLE “public”.“document_fixtures” ADD “document_class_id” INTEGER NOT NULL;

– changeset ?:1619806142790-56
ALTER TABLE “public”.“locations” ADD “country_code” VARCHAR(100);

– changeset ?:1619806142790-57
ALTER TABLE “public”.“media_captions” ADD “caption_author_id” INTEGER NOT NULL;

– changeset ?:1619806142790-58
ALTER TABLE “public”.“participants_events” ADD “alignment” VARCHAR(100);

– changeset ?:1619806142790-59
ALTER TABLE “public”.“team_phases” ADD “affiliation_id” INTEGER NOT NULL;

– changeset ?:1619806142790-60
ALTER TABLE “public”.“sub_seasons” ADD “sub_season_type” VARCHAR(100) NOT NULL;

– changeset ?:1619806142790-61
ALTER TABLE “public”.“standings” ADD “sub_season_id” INTEGER NOT NULL;

– changeset ?:1619806142790-62
ALTER TABLE “public”.“person_event_metadata” ADD “status” VARCHAR(100);

– changeset ?:1619806142790-63
ALTER TABLE “public”.“stats” ADD “stat_holder_type” VARCHAR(100);

– changeset ?:1619806142790-64
ALTER TABLE “public”.“affiliation_phases” ADD “start_season_id” INTEGER;

– changeset ?:1619806142790-65
ALTER TABLE “public”.“american_football_action_plays” ADD “score_attempt_type” VARCHAR(100);

– changeset ?:1619806142790-66
ALTER TABLE “public”.“affiliations” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-67
ALTER TABLE “public”.“baseball_defensive_players” ADD “position_id” INTEGER NOT NULL;

– changeset ?:1619806142790-68
ALTER TABLE “public”.“american_football_action_participants” ADD “participant_role” VARCHAR(100) NOT NULL;

– changeset ?:1619806142790-69
ALTER TABLE “public”.“person_phases” ADD “membership_id” INTEGER NOT NULL;

– changeset ?:1619806142790-70
ALTER TABLE “public”.“documents_media” ADD “media_caption_id” INTEGER NOT NULL;

– changeset ?:1619806142790-71
ALTER TABLE “public”.“sites” ADD “location_id” INTEGER;

– changeset ?:1619806142790-72
ALTER TABLE “public”.“bookmakers” ADD “location_id” INTEGER;

– changeset ?:1619806142790-73
ALTER TABLE “public”.“seasons” ADD “league_id” INTEGER NOT NULL;

– changeset ?:1619806142790-74
ALTER TABLE “public”.“document_fixtures_events” ADD “latest_document_id” INTEGER NOT NULL;

– changeset ?:1619806142790-75
ALTER TABLE “public”.“teams” ADD “home_site_id” INTEGER;

– changeset ?:1619806142790-76
ALTER TABLE “public”.“participants_events” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-77
ALTER TABLE “public”.“team_phases” ADD “end_season_id” INTEGER;

– changeset ?:1619806142790-78
ALTER TABLE “public”.“document_package_entry” ADD “document_id” INTEGER NOT NULL;

– changeset ?:1619806142790-79
ALTER TABLE “public”.“documents” ADD “date_time” TIMESTAMP WITHOUT TIME ZONE;

– changeset ?:1619806142790-80
ALTER TABLE “public”.“baseball_action_pitches” ADD “baseball_defensive_group_id” INTEGER;

– changeset ?:1619806142790-81
ALTER TABLE “public”.“stats” ADD “stat_repository_id” INTEGER NOT NULL;

– changeset ?:1619806142790-82
ALTER TABLE “public”.“team_phases” ADD “start_season_id” INTEGER;

– changeset ?:1619806142790-83
ALTER TABLE “public”.“sub_seasons” ADD “season_id” INTEGER NOT NULL;

– changeset ?:1619806142790-84
ALTER TABLE “public”.“teams” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-85
ALTER TABLE “public”.“sites” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-86
ALTER TABLE “public”.“seasons” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-87
ALTER TABLE “public”.“persons” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-88
ALTER TABLE “public”.“events” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-89
ALTER TABLE “public”.“documents” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-90
ALTER TABLE “public”.“document_fixtures” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-91
ALTER TABLE “public”.“bookmakers” ADD “publisher_id” INTEGER NOT NULL;

– changeset ?:1619806142790-92
ALTER TABLE “public”.“baseball_defensive_players” ADD “player_id” INTEGER NOT NULL;

– changeset ?:1619806142790-93
ALTER TABLE “public”.“baseball_action_plays” ADD “play_type” VARCHAR(100);

– changeset ?:1619806142790-94
ALTER TABLE “public”.“american_football_action_plays” ADD “play_type” VARCHAR(100);

– changeset ?:1619806142790-95
ALTER TABLE “public”.“american_football_action_participants” ADD “person_id” INTEGER NOT NULL;

– changeset ?:1619806142790-96
ALTER TABLE “public”.“participants_events” ADD “participant_id” INTEGER NOT NULL;

– changeset ?:1619806142790-97
ALTER TABLE “public”.“person_phases” ADD “membership_type” VARCHAR(40) NOT NULL;

– changeset ?:1619806142790-98
ALTER TABLE “public”.“media_keywords” ADD “media_id” INTEGER NOT NULL;

– changeset ?:1619806142790-99
ALTER TABLE “public”.“documents_media” ADD “media_id” INTEGER NOT NULL;

– changeset ?:1619806142790-100
ALTER TABLE “public”.“latest_revisions” ADD “latest_document_id” INTEGER NOT NULL;

– changeset ?:1619806142790-101
ALTER TABLE “public”.“key_aliases” ADD “key_root_id” INTEGER NOT NULL;

– changeset ?:1619806142790-102
ALTER TABLE “public”.“injury_phases” ADD “injury_status” VARCHAR(100);

– changeset ?:1619806142790-103
ALTER TABLE “public”.“wagering_total_score_lines” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-104
ALTER TABLE “public”.“wagering_straight_spread_lines” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-105
ALTER TABLE “public”.“wagering_runlines” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-106
ALTER TABLE “public”.“wagering_odds_lines” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-107
ALTER TABLE “public”.“wagering_moneylines” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-108
ALTER TABLE “public”.“person_event_metadata” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-109
ALTER TABLE “public”.“document_fixtures_events” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-110
ALTER TABLE “public”.“baseball_event_states” ADD “current_state” SMALLINT;

– changeset ?:1619806142790-111
ALTER TABLE “public”.“american_football_event_states” ADD “current_state” SMALLINT;

– changeset ?:1619806142790-112
ALTER TABLE “public”.“affiliation_phases” ADD “ancestor_affiliation_id” INTEGER;

– changeset ?:1619806142790-113
ALTER TABLE “public”.“affiliations” ADD “affiliation_type” VARCHAR(100);

– changeset ?:1619806142790-114
ALTER TABLE “public”.“standing_subgroups” ADD “affiliation_id” INTEGER NOT NULL;

– changeset ?:1619806142790-115
ALTER TABLE “public”.“positions” ADD “abbreviation” VARCHAR(100) NOT NULL;

– changeset ?:1619806142790-116
ALTER TABLE “public”.“team_phases” ADD “team_id” INTEGER NOT NULL;

– changeset ?:1619806142790-117
ALTER TABLE “public”.“sub_seasons” ADD “sub_season_key” VARCHAR(100) NOT NULL;

– changeset ?:1619806142790-118
ALTER TABLE “public”.“events_sub_seasons” ADD “sub_season_id” INTEGER NOT NULL;

– changeset ?:1619806142790-119
ALTER TABLE “public”.“stats” ADD “stat_repository_type” VARCHAR(100);

– changeset ?:1619806142790-120
ALTER TABLE “public”.“outcome_totals” ADD “standing_subgroup_id” INTEGER NOT NULL;

– changeset ?:1619806142790-121
ALTER TABLE “public”.“standing_subgroups” ADD “standing_id” INTEGER NOT NULL;

– changeset ?:1619806142790-122
ALTER TABLE “public”.“sites” ADD “site_key” INTEGER NOT NULL;

– changeset ?:1619806142790-123
ALTER TABLE “public”.“seasons” ADD “season_key” INTEGER NOT NULL;

– changeset ?:1619806142790-124
ALTER TABLE “public”.“roles” ADD “role_key” VARCHAR(100) NOT NULL;

– changeset ?:1619806142790-125
ALTER TABLE “public”.“latest_revisions” ADD “revision_id” VARCHAR(75) NOT NULL;

– changeset ?:1619806142790-126
ALTER TABLE “public”.“publishers” ADD “publisher_key” VARCHAR(100) NOT NULL;

– changeset ?:1619806142790-127
ALTER TABLE “public”.“persons” ADD “person_key” VARCHAR(100) NOT NULL;

– changeset ?:1619806142790-128
ALTER TABLE “public”.“person_phases” ADD “person_id” INTEGER NOT NULL;

– changeset ?:1619806142790-129
ALTER TABLE “public”.“person_event_metadata” ADD “person_id” INTEGER NOT NULL;

– changeset ?:1619806142790-130
ALTER TABLE “public”.“injury_phases” ADD “person_id” INTEGER NOT NULL;

– changeset ?:1619806142790-131
ALTER TABLE “public”.“sub_periods” ADD “period_id” INTEGER NOT NULL;

– changeset ?:1619806142790-132
ALTER TABLE “public”.“participants_events” ADD “participant_type” VARCHAR(100) NOT NULL;

– changeset ?:1619806142790-133
ALTER TABLE “public”.“periods” ADD “participant_event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-134
ALTER TABLE “public”.“document_classes” ADD “name” VARCHAR(100);

– changeset ?:1619806142790-135
ALTER TABLE “public”.“teams_media” ADD “media_id” INTEGER NOT NULL;

– changeset ?:1619806142790-136
ALTER TABLE “public”.“persons_media” ADD “media_id” INTEGER NOT NULL;

– changeset ?:1619806142790-137
ALTER TABLE “public”.“media_contents” ADD “media_id” INTEGER NOT NULL;

– changeset ?:1619806142790-138
ALTER TABLE “public”.“media_captions” ADD “media_id” INTEGER NOT NULL;

– changeset ?:1619806142790-139
ALTER TABLE “public”.“events_media” ADD “media_id” INTEGER NOT NULL;

– changeset ?:1619806142790-140
ALTER TABLE “public”.“affiliations_media” ADD “media_id” INTEGER NOT NULL;

– changeset ?:1619806142790-141
ALTER TABLE “public”.“addresses” ADD “location_id” INTEGER NOT NULL;

– changeset ?:1619806142790-142
ALTER TABLE “public”.“key_roots” ADD “key_type” VARCHAR(100);

– changeset ?:1619806142790-143
ALTER TABLE “public”.“key_aliases” ADD “key_id” INTEGER NOT NULL;

– changeset ?:1619806142790-144
ALTER TABLE “public”.“document_fixtures” ADD “fixture_key” VARCHAR(100);

– changeset ?:1619806142790-145
ALTER TABLE “public”.“events” ADD “event_key” VARCHAR(100) NOT NULL;

– changeset ?:1619806142790-146
ALTER TABLE “public”.“weather_conditions” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-147
ALTER TABLE “public”.“tennis_event_states” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-148
ALTER TABLE “public”.“soccer_event_states” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-149
ALTER TABLE “public”.“motor_racing_event_states” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-150
ALTER TABLE “public”.“ice_hockey_event_states” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-151
ALTER TABLE “public”.“basketball_event_states” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-152
ALTER TABLE “public”.“baseball_event_states” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-153
ALTER TABLE “public”.“american_football_event_states” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-154
ALTER TABLE “public”.“affiliations_events” ADD “event_id” INTEGER NOT NULL;

– changeset ?:1619806142790-155
ALTER TABLE “public”.“document_package_entry” ADD “document_package_id” INTEGER NOT NULL;

– changeset ?:1619806142790-156
ALTER TABLE “public”.“teams_documents” ADD “document_id” INTEGER NOT NULL;

– changeset ?:1619806142790-157
ALTER TABLE “public”.“persons_documents” ADD “document_id” INTEGER NOT NULL;

– changeset ?:1619806142790-158
ALTER TABLE “public”.“events_documents” ADD “document_id” INTEGER NOT NULL;

– changeset ?:1619806142790-159
ALTER TABLE “public”.“documents_media” ADD “document_id” INTEGER NOT NULL;

– changeset ?:1619806142790-160
ALTER TABLE “public”.“document_contents” ADD “document_id” INTEGER NOT NULL;

– changeset ?:1619806142790-161
ALTER TABLE “public”.“affiliations_documents” ADD “document_id” INTEGER NOT NULL;

– changeset ?:1619806142790-162
ALTER TABLE “public”.“document_fixtures_events” ADD “document_fixture_id” INTEGER NOT NULL;

– changeset ?:1619806142790-163
ALTER TABLE “public”.“documents” ADD “doc_id” VARCHAR(75) NOT NULL;

– changeset ?:1619806142790-164
ALTER TABLE “public”.“wagering_total_score_lines” ADD “bookmaker_id” INTEGER NOT NULL;

– changeset ?:1619806142790-165
ALTER TABLE “public”.“wagering_straight_spread_lines” ADD “bookmaker_id” INTEGER NOT NULL;

– changeset ?:1619806142790-166
ALTER TABLE “public”.“wagering_runlines” ADD “bookmaker_id” INTEGER NOT NULL;

– changeset ?:1619806142790-167
ALTER TABLE “public”.“wagering_odds_lines” ADD “bookmaker_id” INTEGER NOT NULL;

– changeset ?:1619806142790-168
ALTER TABLE “public”.“wagering_moneylines” ADD “bookmaker_id” INTEGER NOT NULL;

– changeset ?:1619806142790-169
ALTER TABLE “public”.“baseball_action_substitutions” ADD “baseball_event_state_id” INTEGER NOT NULL;

– changeset ?:1619806142790-170
ALTER TABLE “public”.“baseball_action_plays” ADD “baseball_event_state_id” INTEGER NOT NULL;

– changeset ?:1619806142790-171
ALTER TABLE “public”.“baseball_defensive_players” ADD “baseball_defensive_group_id” INTEGER NOT NULL;

– changeset ?:1619806142790-172
ALTER TABLE “public”.“baseball_action_pitches” ADD “baseball_action_play_id” INTEGER NOT NULL;

– changeset ?:1619806142790-173
ALTER TABLE “public”.“baseball_action_contact_details” ADD “baseball_action_pitch_id” INTEGER NOT NULL;

– changeset ?:1619806142790-174
ALTER TABLE “public”.“american_football_action_plays” ADD “american_football_event_state_id” INTEGER NOT NULL;

– changeset ?:1619806142790-175
ALTER TABLE “public”.“american_football_action_participants” ADD “american_football_action_play_id” INTEGER NOT NULL;

– changeset ?:1619806142790-176
ALTER TABLE “public”.“affiliations” ADD “affiliation_key” VARCHAR(100) NOT NULL;

– changeset ?:1619806142790-177
ALTER TABLE “public”.“standings” ADD “affiliation_id” INTEGER NOT NULL;

– changeset ?:1619806142790-178
ALTER TABLE “public”.“positions” ADD “affiliation_id” INTEGER NOT NULL;

– changeset ?:1619806142790-179
ALTER TABLE “public”.“affiliation_phases” ADD “affiliation_id” INTEGER NOT NULL;

– changeset ?:1619806142790-180
ALTER TABLE “public”.“db_info” ADD “version” VARCHAR(100) DEFAULT ‘16’ NOT NULL;

– changeset ?:1619806142790-181
ALTER TABLE “public”.“teams_media” ADD “team_id” INTEGER NOT NULL;

– changeset ?:1619806142790-182
ALTER TABLE “public”.“teams_documents” ADD “team_id” INTEGER NOT NULL;

– changeset ?:1619806142790-183
ALTER TABLE “public”.“persons_media” ADD “person_id” INTEGER NOT NULL;

– changeset ?:1619806142790-184
ALTER TABLE “public”.“persons_documents” ADD “person_id” INTEGER NOT NULL;

– changeset ?:1619806142790-185
ALTER TABLE “public”.“weather_conditions” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-186
ALTER TABLE “public”.“wagering_total_score_lines” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-187
ALTER TABLE “public”.“wagering_straight_spread_lines” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-188
ALTER TABLE “public”.“wagering_runlines” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-189
ALTER TABLE “public”.“wagering_odds_lines” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-190
ALTER TABLE “public”.“wagering_moneylines” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-191
ALTER TABLE “public”.“tennis_service_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-192
ALTER TABLE “public”.“tennis_return_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-193
ALTER TABLE “public”.“tennis_event_states” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-194
ALTER TABLE “public”.“tennis_action_volleys” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-195
ALTER TABLE “public”.“tennis_action_points” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-196
ALTER TABLE “public”.“teams” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-197
ALTER TABLE “public”.“team_phases” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-198
ALTER TABLE “public”.“team_american_football_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-199
ALTER TABLE “public”.“sub_seasons” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-200
ALTER TABLE “public”.“sub_periods” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-201
ALTER TABLE “public”.“stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-202
ALTER TABLE “public”.“standings” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-203
ALTER TABLE “public”.“standing_subgroups” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-204
ALTER TABLE “public”.“soccer_offensive_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-205
ALTER TABLE “public”.“soccer_foul_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-206
ALTER TABLE “public”.“soccer_event_states” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-207
ALTER TABLE “public”.“soccer_defensive_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-208
ALTER TABLE “public”.“sites” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-209
ALTER TABLE “public”.“seasons” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-210
ALTER TABLE “public”.“roles” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-211
ALTER TABLE “public”.“publishers” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-212
ALTER TABLE “public”.“positions” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-213
ALTER TABLE “public”.“persons” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-214
ALTER TABLE “public”.“person_phases” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-215
ALTER TABLE “public”.“person_event_metadata” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-216
ALTER TABLE “public”.“periods” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-217
ALTER TABLE “public”.“participants_events” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-218
ALTER TABLE “public”.“outcome_totals” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-219
ALTER TABLE “public”.“motor_racing_race_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-220
ALTER TABLE “public”.“motor_racing_qualifying_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-221
ALTER TABLE “public”.“motor_racing_event_states” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-222
ALTER TABLE “public”.“media_keywords” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-223
ALTER TABLE “public”.“media_contents” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-224
ALTER TABLE “public”.“media_captions” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-225
ALTER TABLE “public”.“media” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-226
ALTER TABLE “public”.“locations” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-227
ALTER TABLE “public”.“latest_revisions” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-228
ALTER TABLE “public”.“key_roots” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-229
ALTER TABLE “public”.“key_aliases” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-230
ALTER TABLE “public”.“injury_phases” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-231
ALTER TABLE “public”.“ice_hockey_player_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-232
ALTER TABLE “public”.“ice_hockey_offensive_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-233
ALTER TABLE “public”.“ice_hockey_event_states” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-234
ALTER TABLE “public”.“ice_hockey_defensive_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-235
ALTER TABLE “public”.“ice_hockey_action_plays” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

– changeset ?:1619806142790-236
ALTER TABLE “public”.“ice_hockey_action_participants” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;

TRUNCATED HERE

An even different example. I had 2 databases with the exact same structure (the Sports_db baseline). I changed one of them then did the diffchangelog and got similar results… See below… really odd… Why would alter statements appear before creating the object that they are intended to be in??

– liquibase formatted sql

– changeset ?:1619813533454-1

ALTER TABLE “public”.“demo_table1” ADD “id” INTEGER NOT NULL;

– changeset ?:1619813533454-2

CREATE TABLE “public”.“demo_table1” (“id” INTEGER NOT NULL, “name” TEXT NOT NULL, “age” INTEGER NOT NULL, “address” CHAR(50), “salary” FLOAT4, CONSTRAINT “demo_table1_pkey” PRIMARY KEY (“id”));

– changeset ?:1619813533454-3

CREATE TABLE “public”.“demo_audit” (“emp_id” INTEGER NOT NULL, “entry_date” TEXT NOT NULL);

Thanks for your assistance. I have found the issue. My configuration was that I was executing liquibase from the liquibase/liquibase docker container hosted on WSL2 Windows 10. This is the only location that the erroneous output was ever seen. Moving the code base over to Ubuntu 20.10 and running the exact same scripts eliminates the issue completely and provides the expected results. Thank you again for taking the time to investigate.

2 Likes