Integer division (DIV) not supported

[meriturva]

Just an easy request, is it possible to support the DIV Integer division operator?

https://dev.mysql.com/doc/refman/8.4/en/arithmetic-functions.html#operator_div

https://mariadb.com/kb/en/div/

I usually use Math.Truncate and sometimes Math.Floor but we have direct support of integer division on MySql and MariaDb and I guess it will be nice to support it.

Thanks.

[lauxjpn]

We already support and use it internally with MySqlBinaryExpression, with

Pomelo.EntityFrameworkCore.MySql/src/EFCore.MySql/Query/Internal/MySqlSqlExpressionFactory.cs

Lines 204 to 212 in fde6828

	public virtual MySqlBinaryExpression MySqlIntegerDivide(
	SqlExpression left,
	SqlExpression right,
	RelationalTypeMapping typeMapping = null)
	=> MakeBinary(
	MySqlBinaryExpressionOperatorType.IntegerDivision,
	left,
	right,
	typeMapping);

and

Pomelo.EntityFrameworkCore.MySql/src/EFCore.MySql/Query/ExpressionVisitors/Internal/MySqlQuerySqlGenerator.cs

Lines 837 to 872 in fde6828

	public virtual Expression VisitMySqlBinaryExpression(MySqlBinaryExpression mySqlBinaryExpression)
	{
	if (mySqlBinaryExpression.OperatorType == MySqlBinaryExpressionOperatorType.NonOptimizedEqual)
	{
	var equalExpression = new SqlBinaryExpression(
	ExpressionType.Equal,
	mySqlBinaryExpression.Left,
	mySqlBinaryExpression.Right,
	mySqlBinaryExpression.Type,
	mySqlBinaryExpression.TypeMapping);
	Visit(equalExpression);
	}
	else
	{
	Sql.Append("(");
	Visit(mySqlBinaryExpression.Left);
	Sql.Append(")");
	switch (mySqlBinaryExpression.OperatorType)
	{
	case MySqlBinaryExpressionOperatorType.IntegerDivision:
	Sql.Append(" DIV ");
	break;
	default:
	throw new ArgumentOutOfRangeException();
	}
	Sql.Append("(");
	Visit(mySqlBinaryExpression.Right);
	Sql.Append(")");
	}
	return mySqlBinaryExpression;
	}

The simplest way to expose it publicly would probably be to make it available as an extension method on EF.Functions.