MySQL MOD() is broken: Is this the best alternative explain ?

Question

Could anybody solve this query? MySQL MOD() is broken: Is this the best alternative to explain?

Answer 1

 k = x - n * trunc(x / n)

Where you are expecting the implementation to use floored division:

k = x - n * floor(x / n)

Since this is how you implemented your first workaround, I'd say it's probably the best alternative to the Mod operator.

 

 

It seems like more imperative programming languages implement truncated division and more functional mathematical languages seem to use floored division.