'invalid input syntax for type uuid: "collection_share.shared_with"'

The following query works as expected:

SELECT 
  public.users.id, 
  public.users.username, 
  public.users.display_name 
FROM public.users 
INNER JOIN public.collection_share 
ON public.collection_share.shared_with = public.users.id
WHERE public.collection_share.collection_id = '9cf35bd2-544f-4e09-8e88-3e0db7601c36'

SELECT 
  public.users.id, 
  public.users.username, 
  public.users.display_name 
FROM public.users 
INNER JOIN public.collection_share 
ON public.collection_share.shared_with = public.users.id
WHERE public.collection_share.collection_id = '9cf35bd2-544f-4e09-8e88-3e0db7601c36'

SELECT 
  public.users.id, 
  public.users.username, 
  public.users.display_name 
FROM public.users 
INNER JOIN public.collection_share 
ON public.collection_share.shared_with = public.users.id
WHERE public.collection_share.collection_id = '9cf35bd2-544f-4e09-8e88-3e0db7601c36'

SELECT 
  public.users.id, 
  public.users.username, 
  public.users.display_name 
FROM public.users 
INNER JOIN public.collection_share 
ON public.collection_share.shared_with = public.users.id
WHERE public.collection_share.collection_id = '9cf35bd2-544f-4e09-8e88-3e0db7601c36'

However, trying to convert that to supabase orm:

await supabase.from('users')
.select('id, username, display_name, collection_share!inner(collection_id, shared_with)')
.eq('id', 'collection_share.shared_with')
.eq('collection_share.collection_id', collection_id)

await supabase.from('users')
.select('id, username, display_name, collection_share!inner(collection_id, shared_with)')
.eq('id', 'collection_share.shared_with')
.eq('collection_share.collection_id', collection_id)

await supabase.from('users')
.select('id, username, display_name, collection_share!inner(collection_id, shared_with)')
.eq('id', 'collection_share.shared_with')
.eq('collection_share.collection_id', collection_id)

await supabase.from('users')
.select('id, username, display_name, collection_share!inner(collection_id, shared_with)')
.eq('id', 'collection_share.shared_with')
.eq('collection_share.collection_id', collection_id)

throws:

'invalid input syntax for type uuid: "collection_share.shared_with"'

'invalid input syntax for type uuid: "collection_share.shared_with"'

'invalid input syntax for type uuid: "collection_share.shared_with"'

'invalid input syntax for type uuid: "collection_share.shared_with"'

What does this mean?
what is the right syntax?

screenshot of result from SQL query:

garyaustin•12/19/23, 1:59 PM

.eq('id', 'collection_share.shared_with').eq('id', 'collection_share.shared_with')
Won't work. The format is 'column name', value'column name', value You have to code an actual value or local variable. There is no compare of two columns. Normally a join has to be done with a foreign key relationship in the API.

MMr Void The following query works as expected: ```sql SELECT public.users.id, publ...

Socal•12/19/23, 6:16 PM

remove this part. if it doesn't work, add a contraint on either using the supabase ui or a sql query

SSocal remove this part. if it doesn't work, add a contraint on either using the supaba...

Mr VoidOP•12/20/23, 3:19 AM

that worked

thank you so much!

'invalid input syntax for type uuid: "collection_share.shared_with"'

Similar Threads

Similar Threads

Similar Threads