**Describe the bug**
When you create a model that has repeated columns and enab…le model caching on it, then the query fails with:
ERROR: column "id_2" does not exist at character 943
HINT: Perhaps you meant to reference the column "model_1_orders.id".
Query with caching enabled (does not work):
SELECT "source"."id" AS "id", "source"."user_id" AS "user_id", "source"."product_id" AS "product_id", "source"."subtotal" AS "subtotal", "source"."tax" AS "tax", "source"."total" AS "total", "source"."discount" AS "discount", "source"."created_at" AS "created_at", "source"."quantity" AS "quantity", "source"."id_2" AS "id_2", "source"."address" AS "address", "source"."email" AS "email", "source"."password" AS "password", "source"."name" AS "name", "source"."city" AS "city", "source"."longitude" AS "longitude", "source"."state" AS "state", "source"."source" AS "source", "source"."birth_date" AS "birth_date", "source"."zip" AS "zip", "source"."latitude" AS "latitude", "source"."created_at_2" AS "created_at_2" FROM (select "id", "user_id", "product_id", "subtotal", "tax", "total", "discount", "created_at", "quantity", "id_2", "address", "email", "password", "name", "city", "longitude", "state", "source", "birth_date", "zip", "latitude", "created_at_2" from "metabase_cache_8b488_2"."model_1_orders") "source" LIMIT 2000
Query without the caching enabled (works):
SELECT "source"."id" AS "id", "source"."user_id" AS "user_id", "source"."product_id" AS "product_id", "source"."subtotal" AS "subtotal", "source"."tax" AS "tax", "source"."total" AS "total", "source"."discount" AS "discount", "source"."created_at" AS "created_at", "source"."quantity" AS "quantity", "source"."People - User__id" AS "People - User__id", "source"."People - User__address" AS "People - User__address", "source"."People - User__email" AS "People - User__email", "source"."People - User__password" AS "People - User__password", "source"."People - User__name" AS "People - User__name", "source"."People - User__city" AS "People - User__city", "source"."People - User__longitude" AS "People - User__longitude", "source"."People - User__state" AS "People - User__state", "source"."People - User__source" AS "People - User__source", "source"."People - User__birth_date" AS "People - User__birth_date", "source"."People - User__zip" AS "People - User__zip", "source"."People - User__latitude" AS "People - User__latitude", "source"."People - User__created_at" AS "People - User__created_at" FROM (SELECT "public"."orders"."id" AS "id", "public"."orders"."user_id" AS "user_id", "public"."orders"."product_id" AS "product_id", "public"."orders"."subtotal" AS "subtotal", "public"."orders"."tax" AS "tax", "public"."orders"."total" AS "total", "public"."orders"."discount" AS "discount", "public"."orders"."created_at" AS "created_at", "public"."orders"."quantity" AS "quantity", "People - User"."id" AS "People - User__id", "People - User"."address" AS "People - User__address", "People - User"."email" AS "People - User__email", "People - User"."password" AS "People - User__password", "People - User"."name" AS "People - User__name", "People - User"."city" AS "People - User__city", "People - User"."longitude" AS "People - User__longitude", "People - User"."state" AS "People - User__state", "People - User"."source" AS "People - User__source", "People - User"."birth_date" AS "People - User__birth_date", "People - User"."zip" AS "People - User__zip", "People - User"."latitude" AS "People - User__latitude", "People - User"."created_at" AS "People - User__created_at" FROM "public"."orders" LEFT JOIN "public"."people" "People - User" ON "public"."orders"."user_id" = "People - User"."id") "source" LIMIT 2000
**To Reproduce**
1) enable model caching (settings->admin->caching->enable model caching-> set it to every minute)
2) go to the database settings to turn on the caching for that DB (settings->admin->databases->select the db-> turn model caching on)
3) then do new->question: orders join people. Visualize, save it as a model. See the question
4) then turn model caching on for that model. See the error
**Expected behavior**
Build the query correctly
**Screenshots**
Now it works
Now it doesn't
**Information about your Metabase Installation:**
- Your databases: postgres 14
- Metabase version: 44.1
- Metabase hosting environment: Docker
- Metabase internal database: Postgres
**Severity**
P1'ish
**Additional context**
NA