Select request aren't updating

[ianrtracey]

Bug report

Describe the bug

Hey Team 👋

I am experiencing a strange issue where I am getting stale results when using the .select SQL function.

def does_signup_exist(phone_number: str) -> Union[bool, None]:
    query = f"* from signups where phone_number = '{phone_number}'"
    print(query)
    data = client.table("signups").select(query).execute()
    print(data)

I've changed the phone number several times but I still get back results despite certain phone numbers not existing. When I copy and paste the query into the interactive Supbase SQL console in the browser I get a different result than the client.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Query for a result, r1, using the syntax seen above
2. Query for a different result, r2, using the syntax seen above
3. Observe the results r1 == r2

Expected behavior

New result r2 should be updated based on the new query

Screenshots

If applicable, add screenshots to help explain your problem.

System information

• OS: [e.g. macOS, Windows]
• Browser (if applies) [e.g. chrome, safari]
• Version of supabase-js: [e.g. 6.0.2]
• Version of Node.js: [e.g. 10.10.0]

Additional context

Add any other context about the problem here.

[dreinon]

I don't think you can execute a SQL query directly. This is due to security reasons, mainly, to prevent SQL Injection.
You can read JS Client docs on how to use them.

I haven't tried it but I think you might want to do the following:

client.table("signups").select('*').eq('phone_number', f'{phone_number}').execute()

[dreinon]

@ianrtracey did I solved your doubts??

[dreinon]

@J0 this should be closed due to inactivity and it was an issue of the user wrongly using the api.

[J0]

Hey @ianrtracey,

We are closing this due to inactivity, please let us know if you're still facing any issues!

Thanks!