Hello I am sorry if this is a stupid question. I am very new to liquibase. I am running 4.23 against Postgres 14.8. I have set up my first project and I am seeing some behavior I was not expecting. I have set up my root changelog to include 2 sql files:
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:pro="http://www.liquibase.org/xml/ns/pro"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.1.xsd
http://www.liquibase.org/xml/ns/pro
http://www.liquibase.org/xml/ns/pro/liquibase-pro-4.1.xsd">
<include file="changelog/name_id.sql"/>
<include file="changelog/obect_id.sql"/>
</databaseChangeLog>
my files look like this:
❯ cat changelog/name_id.sql
--liquibase formatted sql
--changeset lee.horner:not_null_pk_02
ALTER TABLE ecldb_obj000.name ALTER COLUMN id SET NOT NULL;
❯ cat changelog/obect_id.sql
--liquibase formatted sql
--changeset leehorner:not_null_pk_01
ALTER TABLE ecldb_obj000.object ALTER COLUMN id SET NOT NULL;
When I run liquibase history the Changeset Author is “Includeall” and the Changeset ID is raw. I was not expecting that. Is this expected? Am I doing something wrong?
+---------------+-------------------+------------------------+------------------+--------------+
| Deployment ID | Update Date | Changelog Path | Changeset Author | Changeset ID |
+---------------+-------------------+------------------------+------------------+--------------+
| 0308807864 | 7/25/23, 11:13 AM | changelog/name_id.sql | includeAll | raw |
+---------------+-------------------+------------------------+------------------+--------------+
| 0308807864 | 7/25/23, 11:13 AM | changelog/obect_id.sql | includeAll | raw |
+---------------+-------------------+------------------------+------------------+--------------+```