search

supabase / supabase-js

An isomorphic Javascript client for Supabase. Query your Supabase database, subscribe to realtime events, upload and download files, browse typescript examples, invoke postgres functions via rpc, invoke supabase edge functions, query pgvector.
https://supabase.com
MIT License
2.83k stars 219 forks source link

Max rows in API Settings doesn't work on local development #993

Open danielvoelk opened 1 month ago

danielvoelk commented 1 month ago

Describe the bug

In my config.toml I'm settings the max rows:

max_rows = 1000000

But the value is not applied. It only returns 1000 rows.

To Reproduce

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

  1. Set max rows to a higher value than 1000
  2. Fetch data from a table with more than 1000 rows
  3. See that only 1000 rows will be returned

Expected behavior

I exptected to receive all rows, until a maximum of 1000000.

Screenshots

If applicable, add screenshots to help explain your problem.

System information

Additional context

In my staging and production environment it works. Only the local development environment ignores the max_row configuration.