generateChangeLog not all Sequences

General Discussion
1

This command generate changelog

liquibase --changeLogFile=dbchangelog.xml generateChangeLog

My db has 23 sequences but generateChangeLog generate only 6.

2

Hi @rolton ,

Could you please add some additional details of the problem? I think it would help to understand better and possible have an answer:

  • what RDBMS are you using (MySQL, SQL Server etc)?
  • An example of the structure of both a sequence that is generated and of one that it isn’t.

Thanks,
Eduard

3

Postgres 12.5
this one not generated

CREATE SEQUENCE public.budget_data_id_seq
INCREMENT 1
START 1
MINVALUE 1
MAXVALUE 2147483647
CACHE 1;

ALTER SEQUENCE public.budget_data_id_seq
OWNER TO postgres;

this is generated

CREATE SEQUENCE public.dict_ebc_func_seq
INCREMENT 1
START 1
MINVALUE 1
MAXVALUE 2147483647
CACHE 1;

ALTER SEQUENCE public.dict_ebc_func_seq
OWNER TO postgres;

<changeSet author="larix (generated)" id="1616020525397-42">
    <createSequence cacheSize="1" cycle="false" dataType="integer" incrementBy="1" maxValue="2147483647" minValue="1" sequenceName="dict_ebc_func_seq" startValue="1"/>
</changeSet>

budget_data_id_seq has dependecies

Type Name Restriction
Column public.budget_data.id auto

while dict_ebc_func_seq has

Type Name Restriction
Column dict_ebk_func.id normal