News for hackers. Stuff that matters.
Re:Scaling Databases at Activision [pdf] by geenat on Sunday April 23, 2023 @03:39AM (#35674186)
Can confirm the inability to select null values. Have not yet found reasonable pattern / workaround.. The reasoning seems to be that null values are not stored-- it's displayed as null in csql, but in reality, that data just does not exist.

For the record, CockroachDB does not store the value either, but it allows querying null.

A workaround may be stepping through the full table manually checking for null "in app" and cleaning them that way.

Noticed INSERTS are treated as UPSERT unless you use IF NOT EXISTS... ScyllaDB doesn't give a dump if it's a unique primary key lol. I can live with the UPSERT footgun, though.

There are no comments on this comment yet.