Unexpected output Supabase SQL Editor

Question

Unexpected all null rows output with missing columns when running query (designed and tested on pgadmin) on Supabase SQL Editor. I already checked an both tables have RLS disabled and no constraints or references on either table despite the pk in the column name The query in question is this one

SELECT * FROM temp_insumos_corregidos t 
LEFT JOIN insumo_corregido i
ON (TRIM(i.insumo) = TRIM(t.nombre_anterior) OR TRIM(i.nombre_anterior) = TRIM(t.nombre_anterior))
WHERE i.pk_insumo IS NULL;

This is the pgAdmin output pgAdmin

This is the Supabase output Supabase

Figured it out myself. Apparently Supabase can't handle duplicate column names. After declaring them explicitly and giving aliases the query worked as intended — Cbas G
– Cbas G, Commented Feb 26 at 23:55

Cbas G · Accepted Answer · 2025-02-27 17:06:54Z

0

Figured it out myself. Apparently Supabase can't handle duplicate column names. After declaring them explicitly and giving aliases the query worked as intended

answered Feb 27 at 17:06

Cbas G

31 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unexpected output Supabase SQL Editor

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related