Email or username:

Password:

Forgot your password?
Top-level
Gregory

What will happen when this limit is exceeded? The "reply key" field will get truncated. It's 1024 bytes and stores the IDs of all parent posts as 32-bit integers, always starting from the top-level one. So essentially, all further replies will be erroneously considered replying to the 256th reply in the thread.

Now I don't think this is a problem in any real-world use cases, but yikes

3 comments
Gregory

I was sent another, longer thread, and yay it broke 🎉

Александр :straightally:

@grishka

> 1024 bytes and stores the IDs of all parent posts as 32-bit integers, always starting from the top-level one.
THAT'S yikes.

Is there any reason to store first post after 256/8/2 replies?

Gregory

@saiv46 yes, because I need to be able to select reply subtrees from any level

Go Up