Read foreign table range() returning more rows than specified.

[magiusdarrigo]

Hello!

This snippet:

            const { locationId } = req.params;          
            const { data: menus, error } = await supabase
            .from('menus')
            .select(`
              all_level,
              locations (
                id
              )
            `).eq('locations.id', locationId)
            .range(0,1);

returns me both menu rows (2) instead of 0 or 1.

locationId equals: b891f5b6-d447-42af-a9e6-2af29697ca19

The rows in my menus table:

The rows in my locations table:

What am I doing wrong? Thanks!

[magiusdarrigo]

I was using .eq() incorrectly. I changed it to:

            const { data: menus, error } = await supabase
            .from('locations')
            .select(`
              menus (
                  all_level
              )
            `).eq('id', locationId)
            .range(0,1);

and now it returns the 1 expected menu row. Apologies!