readysettech / readyset

Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
https://readyset.io
Other
4.54k stars 125 forks source link

Add default search schema path for no-upstream-connections mode #1377

Closed jasobrown-rs closed 1 month ago

jasobrown-rs commented 1 month ago

Description

When running in --no-upstream-connections mode, the adapter does not get the schema_search_path. This is a problem for PG users. This problem means queries, which appear legit to the unsuspecting user, will fail as we aren't setting the schema_search_path to correctly identify the schema namespace within the database.