Strange behaviour with inferred nullability when using JOIN

[pantonshire]

I recently ran into some confusing behaviour with inferred nullability in the query_as macro when I use JOIN in a query. I'm using Postgres.

If I have the following tables:

CREATE TABLE groups (
    id SERIAL PRIMARY KEY,
    name TEXT NOT NULL
);

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    group_id INT NOT NULL REFERENCES groups(id),
    name TEXT NOT NULL
);

Then the following code does not compile; SQLx seems to expect all of the fields to be Option<T>:

struct Row {
    group_id: i32,
    user_id: i32,
    group_name: String,
    user_name: String,
}

let rows = sqlx::query_as!(
    Row,
    "SELECT \
        groups.id AS group_id, users.id AS user_id, \
        groups.name AS group_name, users.name AS user_name \
    FROM users INNER JOIN groups ON users.group_id = groups.id"
)
.fetch_all(&mut conn)
.await?;

But if I add a LIMIT to the query, then it compiles just fine:

struct Row {
    group_id: i32,
    user_id: i32,
    group_name: String,
    user_name: String,
}

let rows = sqlx::query_as!(
    Row,
    "SELECT \
        groups.id AS group_id, users.id AS user_id, \
        groups.name AS group_name, users.name AS user_name \
    FROM users INNER JOIN groups ON users.group_id = groups.id \
    LIMIT 999"
)
.fetch_all(&mut conn)
.await?;

What's going on here? Is this expected behaviour, or a bug?

[cortopy]

also experiencing this, very weird but adding the limit worked