Self Hosted/Local Security Advisor Incorrect Function Search Path Mutable

# Bug report <!-- ⚠️ We receive a lot of bug reports which have already been solved or discussed. If you are looking for help, please try these first: - Docs: https://docs.supabase.com - Discussions: https://github.com/supabase/supabase/discussions - Discord: https://discord.supabase.com Before opening a bug report, please verify the following: --> - [X] I confirm this is a bug with Supabase, not with my own application. - [X] I confirm I have searched the [Docs](https://docs.supabase.com), GitHub [Discussions](https://github.com/supabase/supabase/discussions), and [Discord](https://discord.supabase.com). ## Describe the bug Using the example code below I'm creating a simple security definer function with the search_path hard coded to a specific schema. The security advisor incorrectly advises that the search path is mutable when it is not. The same warning doesn't happen when I run this on the supabase.com hosted version. ## To Reproduce Steps to reproduce the behavior, please provide code snippets or a repository: 1. Run the following code snippet and visit the security advisor page. ``` -- example 1 create schema example_schema; set search_path = example_schema; create or replace function get_tenant_id() returns uuid security definer set search_path from current as $$ select '11111111-1111-1111-1111-111111111111'::uuid; $$ language sql stable; reset search_path; -- example 2 create schema example_schema_2; create or replace function get_tenant_id() returns uuid security definer set search_path = 'example_schema_2' as $$ select '11111111-1111-1111-1111-111111111111'::uuid; $$ language sql stable; ``` ## Expected behavior The example functions have a hard coded search_path and should not flag a warning. ## 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] ``` SERVICE IM…