Supabase•3y ago

Could there be a bug in the or query?

The or query returns the data 2 times. Is this normal or is it a bug?

garyaustin•12/5/23, 7:12 PM

I doubt there is a bug and it does not return data two times unless there are two rows that match.

Ggaryaustin I doubt there is a bug and it does not return data two times unless there are tw...

TolgahanOP•12/5/23, 7:32 PM

What I want here is to return userId or startedBroadcast values. when I add this, these data return 2 times each. I will check and send screenshots

TolgahanOP•12/5/23, 7:32 PM

Is my usage correct? right ?

garyaustin•12/5/23, 7:33 PM

It looks correct as far as format, except:

garyaustin•12/5/23, 7:33 PM

What is startedBroadcast though?

garyaustin•12/5/23, 7:34 PM

Why is that not like ${startedBroadcast} ?

Ggaryaustin Why is that not like ${startedBroadcast} ?

TolgahanOP•12/5/23, 7:36 PM

cuz it's a static data

TolgahanOP•12/5/23, 7:37 PM

garyaustin•12/5/23, 7:37 PM

Ah.

TheCat•12/5/23, 7:53 PM

I think you need to give more context of what you want the query to do and the data you are querying. But to me it looks like it's probably a data issue and you have a record with the

user_id=={user_id} and is_admin==true

user_id=={user_id} and is_admin==true

and another record

user_id==startedBroadcast and is_admin==true

user_id==startedBroadcast and is_admin==true

. and it's returning both of those?

TTheCat I think you need to give more context of what you want the query to do and the d...

TolgahanOP•12/5/23, 7:57 PM

It returns the same data 2 times. For example, if there are 7, it shows 14 times

TolgahanOP•12/5/23, 7:57 PM

i will show you, wait a min

garyaustin•12/5/23, 7:59 PM

For the image you showed above if that was all the data and is_admin is true for all the rows you would get 8 results plugging in the user_id.

garyaustin•12/5/23, 8:03 PM

It is going to find all rows with either condition.

Socal•12/5/23, 10:48 PM

if you're getting the same result twice in a row, then whatever is calling that is running twice.

if you're only getting 1 response with 2x data, then it's a problem with your data

Could there be a bug in the or query?

Similar Threads

Similar Threads

Similar Threads