Liquibase not applying changesets in expected order

General Discussion
1
I have a Spring Boot 1 application running on PostgreSQL where I've setup my changelog.xml file as follows:
select * from databasechangelog;
-[ RECORD 1 ]-+-----------------------------------
id            | 1
author        | user1
filename      | classpath:/db/changelog/schema.sql
dateexecuted  | 2020-04-30 20:03:46.771527
orderexecuted | 1
exectype      | EXECUTED
md5sum        | 8:d3c3aed234be3b66182833f56d1febe3
description   | sql
comments      | Initial schema
tag           |
liquibase     | 3.8.9
contexts      |
labels        |
deployment_id | 8302226596

My understanding is that the files would be executed in order from top to bottom, but it doesn't appear to be the case for me. 

What am I missing here?  Thanks
2

I found the problem.

In my schema.sql I had my create table statement as:

CREATE TABLE public.user_detail …

but in my insert_user_local.sql I had only:

INSERT INTO user_detail(…

instead of public.user_detail.  Just needed to be consistent with the schema naming convention.

3

Glad you found the issue!