Look & Feel inheritance 500 — spell the jsonb cast as CAST()

Shipped

November 14, 2026 at 6:28 PM UTC

Author

Kamo

Commit

db3e26e

Hibernate's native-query parser rewrote '{}'::jsonb into '{}':jsonb, so every GET **************** answered 500 in production (syntax error at or near ":"). That blanked the Look & Feel Studio's inheritance map, the B4 impact lines on Sounds / Click & Touch Effects / Page Transitions, and the passport's Look & Feel line (the per-organization read uses the same SQL). Casts are now CAST('{}' AS jsonb); verified on prod read-only (32 active orgs, 0 custom sound / 1 custom effect layers). Test pins: no '::' in any SQL string.