sqlx(default) does not work

[ItsEthra]

Bug Description

#[sqlx(default)] attribute is supposed to use default value for the type instead of taking it from the query but it doesn't, and causes missing field error.

Minimal Reproduction

#[derive(sqlx::FromRow)]
struct Foo {
    id: i32,

    #[sqlx(default)]
    name: Option<String>,
}

#[tokio::main(flavor = "current_thread")]
async fn main() {
    let pg = sqlx::PgPool::connect("postgres://testing@localhost/testing").await;

    sqlx::query_as!(Foo, "SELECT id FROM Foo");
}

Table foo was created with like that

create table foo(id SERIAL PRIMARY KEY, name TEXT NOT NULL);

Info

• SQLx version: 0.7.4
• SQLx features enabled: postgres,runtime-tokio
• Database server and version: postgres 16.2
• Operating system: Arch linux
• rustc --version: rustc 1.78.0-nightly (3cbb93223 2024-03-13)

[abonander]

query_as!() does not use FromRow. It says right in the docs: https://docs.rs/sqlx/latest/sqlx/macro.query_as.html

See also #514