asyncpg-ambiguousparametererror-explicit-type-casts-needed

asyncpg AmbiguousParameterError:

asyncpg AmbiguousParameterError: explicit type casts needed in mixed-context params. asyncpg is stricter than psql about parameter type deduction. When $2appearsasbothVARCHAR(16)columnvalue(INSERT)andinCASEWHEN$2::text = ‘PASS’ comparison (same query), asyncpg can’t resolve type. Fix: add ::varchar cast at ambiguous usage site. Rule: When a single $N parameter is used in multiple SQL contexts with different type expectations, explicitly cast at the ambiguous site.