element-hq / element-hq/synapse
users has a bunch of nullable columns
Open
A-Database
T-Task
- Dominant language
- Python
- Stars
- 4.6k
- Forks
- 600
- Avg merge
- 5d 22h
- Merged PRs (30d)
- 51
Description
This issue has been migrated from [#16442](https://github.com/matrix-org/synapse/issues/16442).
---
> Additionally:
> - name is a nullable field (?!?!?!)
> With that said, on matrix.org:
>
> ```
> matrix=> select count(*) from users;
> count
> ══════════
> 62887652
> (1 row)
>
> Time: 12499.198 ms (00:12.499)
> matrix=> select count(*) from users where name IS NULL;
> count
> ═══════
> 0
> (1 row)
> ```
_Originally posted by @DMRobertson in https://github.com/matrix-org/synapse/pull/16434#discussion_r1347991716_
Contributor guide
Assessment
This issue has not been assessed yet.