COUNT no rows doesn't give 0

[amacfie]

from sqlglot.executor import execute

execute("""
    select count(id)
    from t
    """,
    tables=dict(t=[dict(id=1)]),
)
# _col_0
#      1

execute("""
    select count(id)
    from t
    where false
    """,
    tables=dict(t=[dict(id=1)]),
)
# _col_0

I'd expect the second to give

# _col_0
#      0

instead. Is it a bug or am I doing something wrong?

[tobymao]

it's a bug

it's fixed now