I have found these related issues/pull requests

I haven't found similar issues

Description

If a field in the query statement is of super data-type an error is reported: error returned from database: cannot cast type regtype to character varying

Reproduction steps

let mut stream = sqlx::query(sql).fetch(&*POOL).take(limit);
let mut values = vec![];
while let Some(res) = stream.next().await {
    match res {
        Ok(row) => values.push(row_to_value(&row)),
        Err(err) => tracing::error!(%err),
    }
}
Ok(values)

SQLx version

0.8.3

Enabled SQLx features

"runtime-tokio-rustls", "postgres", "chrono", "bigdecimal"

Database server and version

AWS Redshift

Operating system

linux

Rust version

rustc 1.87.0-nightly (f04bbc60f 2025-02-20)