This is intended as a minimal reproducible example for sequelize/sequelize#17091
Firstly, copy .env.example
to .env
and set the variables to configure the postgres instance and database to connect to in index.js
.
Secondly, install dependencies with npm i
.
Then, npm run start
to reproduce the bug.
An exception should be printed that shows the malformed select query n.b. that the table alias is prefixed with the schema, in this case "dev".
Executing (default): SELECT "relation"."id", "relation"."entityId", "entity"."id" AS "entity.id" FROM "dev"."relation" AS "relation" LEFT OUTER JOIN "dev"."entity" AS "entity" ON "dev"."relation"."entityId" = "entity"."id";
...
DatabaseError [SequelizeDatabaseError]: invalid reference to FROM-clause entry for table "relation"