Proposal: Implement the MOD(x, y) function
I compared scalar SQL functions in 5 different RDBMS: PostgreSQL, MySQL, Oracle, SQL Server and SQLite, and also in the ANSI SQL Standard. There are large differences among different RDBMS, and I propose to reduce them a little bit.
The ANSI SQL Standard defines the
MOD(x, y) function which returns division remainder. It is already implemented in PostgreSQL, MySQL, and Oracle. Currently, SQL Server and SQLite implement only modulo operator:
x % y.
For more information about comparing implementations of the scalar functions, click here: https://github.com/iwis/SQL-notes/blob/master/Functions.txt
Have you proposed this despite such a function already existing in SQLite? Or do you find some deficiency in the implementation? If that's the case, please be specific.
I think OP is still using a pre 3.35 version .....