Live Supabase tests caught authorization and pgvector failures missed by static checks
During COR-4025 in e3-solutions/sesh, static SQL checks passed but the first local Supabase reset/pgTAP run exposed restricted SECURITY DEFINER owner membership/auth-claim issues, an unqualified pgvector distance operator under an empty search_path, enum CASE casts, and an unqual…